Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

How to convert specific sheet to CSV via command line?

Looking at this question and answers (http://ask.libreoffice.org/en/question/21916/cli-convert-ods-to-csv-with-semicolon-as-delimiter/), plus checking some other resources, I found out that you can batch convert spreadsheet files to CSV. This is command you can use:

soffice --headless --convert-to csv:"Text - txt - csv (StarCalc)":"59,ANSI,1" test.ods

Only problem I have is, I don't want to convert first/default sheet. I want to convert specific sheet (defined by order number or name). Does anyone know how to convert specific sheet with this command? My guess is that opening spreadsheet file in specific sheet and then converting would work also, but not sure how to do that via command line.