Convert XLSB files to csv in Linux on command line

Question

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?

Answer 1

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