CODEWITHSUNDEEP
linuxexcelcommand-line
Chicoscience
Chicoscience

Reputation: 1065

Convert XLSB files to csv in Linux on command line

I have thousands of XLSBs files (binary excel files). I'm on Ubuntu and need to convert them all to CSVs. Each files has lots of macros and tabs, however, all this content can be ignored as for each file I only need the data from the first tab.

Is there a way to do it via command line?

Upvotes: 8

Views: 5816

Answers (1)

Chicoscience
Chicoscience

Reputation: 1065

Found it! If Libreoffice is installed we can do it via the command:

soffice --headless --convert-to csv file.xlsb

The --headless command prevents the GUI from opening

Upvotes: 11

Related Questions