File Formats

Gnumeric supports numerous file formats in addition to its own XML based format. The table below lists the formats currently supported. In the table below, the name of the format is a link which can be used to jump to the section which discusses the format.

Table 14-1The file formats supported by Gnumeric
Format Extension Open Save Import Export MIME type
Gnumeric .gnumeric / .gnm / .xml YES YES application/x-gnumeric
Applix .as YES application/x-applix-spreadsheet
Comma Separated Values .csv YES YES text/plain
Data Interchange Format .dif YES YES
GNU Oleo .oleo YES application/x-oleo
HTML .html / .htm YES YES text/html
LaTeX .tex YES text/x-tex
Linear and Integer Program none / .mps YES application/x-mps
Lotus 1-2-3 .wk1 / .wks YES application/vnd.lotus-1-2-3, application/x-123
Microsoft Excel Old Binary Format (versions 2 - 5) .xls / .xlt / .xlw YES application/vnd.ms-excel
Microsoft Excel Binary Format (Excel 95 - 2003) .xls / .xlt / .xlw YES YES application/vnd.ms-excel
Microsoft Excel 2003 SpreadsheetML .xlsx YES application/vnd.ms-excel
Microsoft Office Open SpreadsheetML (MOOX/ECMA376/ISO29500) .xlsx YES YES application/vnd.ms-excel
OpenOffice.Org / StarOffice Old Format .sxc / .stc YES application/vnd.sun.xml.calc
OpenDocument Format (OASIS ODF and ISO/IEC 26300:2006) .ods / .odt / .sxc / .stc YES YES application/vnd.oasis.opendocument.spreadsheet
Paradox Database .px / .db YES YES
Plan Perfect .pln YES application/x-planperfect
Psion 5 Sheet Files .psisheet YES
Postscript .ps / .eps YES application/postscript
PDF .pdf YES application/pdf
Quattro Pro .wb1 / .wb2 / .wb3 YES application/x-quattropro, application/x-quattro-pro
SC/XSpread none / .sc YES application/x-sc
Multiplan (SYLK) .sylk / .slk YES YES application/x-sylk
Tab Separated Values .tsv / .tab YES YES text/plain
Text Formats .txt / .text YES YES text/plain
TROFF .me YES application/x-troff
Xbase .dbf YES application/dbase, application/dbf, application/x-dbase, application/x-dbf, application/x-xbase, zz-application/zz-winassoc-dbf
XHTML .xhtml / .html YES application/xhtml+xml

Files in the file formats marked as Save/Open can be opened or saved with the Open, Save, and Save As menu items in the File menu. Files in the file formats marked as Import/Export can be imported or exported with the items on the Import Data and Export Data submenus of the Data menu.