-
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 | PUID | Wikidata
- --> .xlsb | Office Open XML Binary Spreadsheet | PUID | Wikidata
- --> .xlsm | Office Open XML Macro-Enabled Spreadsheet | PUID | Wikidata
- --> .xlsx | Office Open XML Spreadsheet (Transitional and Strict conformance) | PUID | Wikidata
- --> .xltm | Office Open XML Macro-Enabled Spreadsheet Template | PUID | Wikidata
- --> .xltx | Office Open XML Spreadsheet Template | PUID | Wikidata
- OpenDocument file formats: .fods, .ods, .ots
- --> .fods | OpenDocument Flat XML Spreadsheet | PUID | Wikidata
- --> .ods | OpenDocument Spreadsheet | PUID | Wikidata
- --> .ots | OpenDocument Spreadsheet Template | PUID | Wikidata
- Google Sheets: .gsheet | PUID | Wikidata
- Apple Numbers: .numbers | PUID | Wikidata
- Delimiter separated file format: .csv, .tsv
- Markup language file formats: .xml
- Legacy Excel file formats: .xla, .xls, .xlt
- --> .xla | Legacy Microsoft Excel Spreadsheet Add-In | PUID | Wikidata
- --> .xls | Legacy Microsoft Excel Spreadsheet | PUID | Wikidata
- --> .xlt | Legacy Microsoft Excel Spreadsheet Template | PUID | Wikidata
- Other legacy file formats: .123, .wks, .wk1, .wk2, .wk3, .wk4, .dif, .sxc
- --> .123, .wks, .wk1, .wk2, .wk3, .wk4 | Lotus 1-2-3 | PUID | Wikidata
- --> .dif | VisiCalc data interchange format | PUID | Wikidata
- --> .sxc | OpenOffice 1.0 spreadsheet file (Sun XML Calc) | PUID | Wikidata
Method | Input file formats | Output file formats |
---|---|---|
Count | .gsheet, .fods, .numbers, .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 |
- .xla and .xlam are Microsoft Excel Add-in files and cannot contain worksheet cell information. Therefore, they are excluded from conversion but will be copied to the new archive directory, if archiving is selected.
- .gsheet is only a hyperlink to the file in cloud Google Sheets and cannot be processed. Instead, you receive an alert to manually handle the identified spreadsheet. They will not be copied, if archiving is selected.
- .numbers is an operating system-specific file format used in the Apple Numbers spreadsheet application. I have no experience with or care for the Apple ecosystem. I won't spend time on finding a solution at the moment. They will not be copied, if archiving is selected.
- .csv, .tsv and .xml may be used to keep data originated from or being used in a spreadsheet application, but they may also be used as datasets or tables in other contexts. Therefore, it is impractical to assume they are spreadsheets. They will not be copied, if archiving is selected.
- .123, .wks, .wk1, .wk2, .wk3, .wk4, .dif and .sxc were used by deprecated spreadsheet applications, and these applications have been deprecated for over a decade and in most cases for much longer. They are not even included in the counting and they will not be copied, if archiving is selected.
If you don't agree with the above assessments, create an issue.