Ask Your Question

Convert from CSV to XLSX from console with specific delimiter [closed]

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

Exporter gravatar image

updated 2020-08-04 18:03:49 +0100

Alex Kemp gravatar image

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 reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-04 18:04:00.691342

1 Answer

Sort by » oldest newest most voted

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

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 +0100 )edit

Question Tools

1 follower


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

Seen: 5,818 times

Last updated: Jun 23 '17