I see continual questions such as “Will LO import Lotus 123 files?”. Import + export are done via Filters, and there are reported to be hundreds of them available. However, nowhere within the documentation has anybody thought to say what these filters are, nor which files they refer to, nor what programs they support. That makes life damn difficult for humble LO supporters trying to answer questions.
So, what filters are available for Calc files?
Thank you for asking that question, Alex.
filters-calc.odt (Writer version of filter.calc)
filters-calc.ods (Calc version of filter.calc) (added 2015-11-18)
(filter.calc is hand-extracted from calc.xcd)
:~$ /opt/libreoffice5.0/program/soffice.bin --version
LibreOffice 5.0.0.5 437e4abdf9e72fd0a6e6f8697a0e659bc77f9b10
:~$ cat filter.calc | wc -l
40
Obtained from /opt/libreoffice5.0/share/registry/calc.xcd; Debian 6.0:
:~$ cat filter.calc | sort
"Apple Numbers 2" application/x-iwork-numbers-sffnumbers Extensions:numbers
"BeagleWorks/WordPerfect Works v1 Spreadsheet" Extensions:-
"ClarisResolve Document" application/clarisworks Extensions:cwk
"ClarisWorks/AppleWorks Spreadsheet" application/clarisworks Extensions:cwk
"dBase" Extensions:dbf
"DIF (Data Interchange Format)" Extensions:dif
"GreatWorks Spreadsheet" Extensions:-
"HTML Table" text/html Extensions:xls
"HTML" text/html Extensions:html htm
"Lotus (Lotus 1-2-3)" application/vnd.lotus-1-2-3 Extensions:wk1 wks 123
"Microsoft Excel 2007-2013 XML" application/vnd.openxmlformats-officedocument.spreadsheetml.sheet Extensions:xlsx xlsm
"Microsoft Excel 2007-2013 XML Template" application/vnd.openxmlformats-officedocument.spreadsheetml.template Extensions:xltm xltx
"Microsoft Excel 2007 Binary" Extensions:xlsb
"Microsoft Works Document" Extensions:wks wdb
"Microsoft Works for Mac Spreadsheet (v1 - v4)" application/vnd.ms-works Extensions:wps
"MS Excel 4.0" application/vnd.ms-excel Extensions:xls xlw xlc xlm
"MS Excel 4.0 Vorlage/Template" application/vnd.ms-excel Extensions:xlt
"MS Excel 5.0/95" application/vnd.ms-excel Extensions:xls xlc xlm xlw
"MS Excel 5.0/95 Vorlage/Template" application/vnd.ms-excel Extensions:xlt
"MS Excel 95" application/vnd.ms-excel Extensions:xls xlc xlm xlw
"MS Excel 95 Vorlage/Template" application/vnd.ms-excel Extensions:xlt
"MS Excel 97" application/vnd.ms-excel Extensions:xls xlc xlm xlw xlk
"MS Excel 97 Vorlage/Template" application/vnd.ms-excel Extensions:xlt
"ODF Spreadsheet (Calc 8)" application/vnd.oasis.opendocument.spreadsheet Extensions:ods
"ODF Spreadsheet Template (Calc 8 Template)" application/vnd.oasis.opendocument.spreadsheet-template Extensions:ots
"Office Open XML Spreadsheet" application/vnd.openxmlformats-officedocument.spreadsheetml.sheet Extensions:xlsx xlsm
"Office Open XML Spreadsheet Template" application/vnd.openxmlformats-officedocument.spreadsheetml.template Extensions:xltx xltm
"OpenDocument Spreadsheet Flat XML" Extensions:fods ods xml
"OpenOffice.org 1.0 Spreadsheet Template" Extensions:
"PDF - Portable Document Format" application/pdf Extensions:pdf
"Quattro Pro 6.0" Extensions:wb2
"QuattroPro Document" Extensions:wq1 wq2
"Rich Text Format" application/rtf Extensions:rtf
"StarOffice XML (OpenOffice.org 1.0 Spreadsheet) (Calc 6.0)" application/vnd.sun.xml.calc Extensions:sxc
"StarOffice XML Template (OpenOffice.org 1.0 Spreadsheet Template) (Calc 6.0 Template)" application/vnd.sun.xml.calc.template Extensions:stc
"SYLK" text/spreadsheet Extensions:slk sylk
"Text CSV (StarCalc)" Extensions:csv
"Text" text/plain Extensions:csv tsv tab txt
"Wingz for Mac Document" Extensions:-
"WPS Lotus Document" Extensions:wk1 wk3
If this helps then please show you like it with an uptick (∧)