Ask Your Question

Convert from CSV to XLSX from console with specific delimiter

asked 2017-06-23 10:40:31 +0200

Exporter gravatar image

updated 2017-06-23 10:52:34 +0200

Hey everyone,

I can already convert from CSV to XLSX via command line on Windows 7 thanks to this post, but it only uses a comma (,) as delimiter.

My current command looks like this:
start /wait soffice --headless --convert-to xlsx:"Calc MS Excel 2007 XML" file_to_convert.csv

I already tried it with specific filter options, but they only seem to work when any format is convertet to CSV
start /wait soffice --convert-to xlsx:"Calc MS Excel 2007 XML":59/9,34,0,1,1 "file_to_convert.csv"

Do you have any advice how to use tabs and/or semicolon(;) as a delimiter during this conversion?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-06-23 10:52:08 +0200

You need to use --infilter command line option with CSV filter options, like shown e.g. here.

edit flag offensive delete link more


Thank you for the fast response, it works great

Exporter gravatar imageExporter ( 2017-06-23 11:02:22 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-06-23 10:40:31 +0200

Seen: 3,182 times

Last updated: Jun 23 '17