Gnumeric can open files which have been created in several formats by other spreadsheet programs or databases. The details of these formats are provided in Section 14.2 ― File Formats and the name of each file type in the table below skips to the appropriate section of Section 14.2 ― File Formats. The opening of text formatted files is described in Section 14.4 ― Importing Text Files. Gnumeric can also import text data or HTML and XHTML tables through the clipboard mechanism, as is explained in Section 5.7.4 ― Cut and Paste Between Gnumeric and Other Applications.
Most of these formats are provided by plugins, which are independent, configurable modules. If a format described below does not appear in the File Open dialog, this may be because the appropriate plugin has not been configured or started. This can be verified by examining the list of plugins which are currently running in the Plugin Manager dialog.
The Plugin Manager dialog lists the plugins which are currently in use and provides a way to start plugins which are currently disabled. The Plugin Manager can be started by selecting, in the Tools menu, the Plug-ins... menu item; see Section 13.4 ― Plugins for more information.
| Format | Extension |
|---|---|
| Gnumeric | .gnumeric / .gnm |
| Applix | .as |
| Comma Separated Values | .csv |
| Data Interchange Format | .dif |
| GNU Oleo | .oleo |
| HTML | .html / .htm |
| Linear and Integer Program | none / .mps |
| Lotus 1-2-3 | .wk1 / .wks |
| Microsoft Excel Old Binary | .xls |
| Microsoft Excel New Binary | .xls |
| Microsoft Excel 2003 XML | .xls |
| Microsoft Excel Office Open XML | .xlsx |
| OpenOffice.Org / StarOffice (OASIS ODF/IS26300) | .ods / .odt |
| OpenOffice.Org / StarOffice Old Format | .sxc / .stc |
| Plan Perfect | .pln |
| Quattro Pro | .wb1 / .wb2 / .wb3 |
| SC/XSpread | none / .sc |
| Multiplan (SYLK) | .sylk / .slk |
| Tab Separated Values | .tsv / .tab |
| Text Formats | .txt / .text |
| Xbase | .dbf |