Ask Your Question

What are the 5.x Calc Import/Export Filters? [closed]

asked 2015-10-08 12:05:36 +0200

Alex Kemp gravatar image

updated 2020-10-19 01:54:48 +0200

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?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-11-20 23:32:39.035658


Alex Kemp gravatar imageAlex Kemp ( 2015-11-18 19:13:23 +0200 )edit
Alex Kemp gravatar imageAlex Kemp ( 2020-09-05 22:09:28 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2015-10-08 12:13:02 +0200

Alex Kemp gravatar image

updated 2015-11-19 11:11:18 +0200

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 437e4abdf9e72fd0a6e6f8697a0e659bc77f9b10
:~$ cat filter.calc | wc -l

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/ Extensions:wps
"MS Excel 4.0" application/ Extensions:xls xlw xlc xlm
"MS Excel 4.0 Vorlage/Template" application/ Extensions:xlt
"MS Excel 5.0/95" application/ Extensions:xls xlc xlm xlw
"MS Excel 5.0/95 Vorlage/Template" application/ Extensions:xlt
"MS Excel 95" application/ Extensions:xls xlc xlm xlw
"MS Excel 95 Vorlage/Template" application/ Extensions:xlt
"MS Excel 97" application/ Extensions:xls xlc xlm xlw xlk
"MS Excel 97 Vorlage/Template" application/ 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
" 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 ( 1.0 Spreadsheet) (Calc 6.0)" application/vnd.sun.xml.calc Extensions:sxc
"StarOffice XML Template ( 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 ()

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2015-10-08 12:05:36 +0200

Seen: 2,616 times

Last updated: Nov 19 '15