-
Notifications
You must be signed in to change notification settings - Fork 2
Spreadsheet File Formats
Asbjørn Skødt edited this page Aug 1, 2022
·
22 revisions
- Office Open XML (Excel) file formats: .xlam, .xlsb, .xlsm, .xlsx, .xltm, .xltx
- --> .xlam - Office Open XML Macro-Enabled Add-In
- --> .xlsb - Office Open XML Binary Spreadsheet
- --> .xlsm - Office Open XML Macro-Enabled Spreadsheet
- --> .xlsx - Office Open XML Spreadsheet (Transitional and Strict conformance)
- --> .xltm - Office Open XML Macro-Enabled Spreadsheet Template
- --> .xltx - Office Open XML Spreadsheet Template
- Legacy Excel file formats: .xla, .xls, .xlt
- --> .xla - Legacy Microsoft Excel Spreadsheet Add-In
- --> .xls - Legacy Microsoft Excel Spreadsheet
- --> .xlt - Legacy Microsoft Excel Spreadsheet Template
- OpenDocument file formats: .fods, .ods, .ots
- --> .fods - OpenDocument Flat XML Spreadsheet
- --> .ods - OpenDocument Spreadsheet
- --> .ots - OpenDocument Spreadsheet Template
- Google Sheets: .gsheet
- Apple Numbers: .numbers
- Delimiter separated file format: .csv
- Markup language file formats: .xml
| Method | Input file formats | Output file formats |
|---|---|---|
| Count | .fods, .ods, .ots, .xla, .xlam, .xls, .xlsb, .xlsm, .xlsx (Transitional and Strict), .xlt, .xltm, .xltx | |
| Convert | .fods, .ods, .ots, .xls, .xlsb, .xlsm, .xlsx (Transitional and Strict), .xlt, .xltm, .xltx | .xlsx (Transitional |
| Compare | Identical to Convert | |
| Archive | Identical to Convert | .xlsx (Transtional), .ods |