Excel files can be converted to CSV using:
$ libreoffice --convert-to csv --headless --outdir dir file.xlsx
Everything appears to work just fine. The encoding, though, is set to something wonky. Instead of a UTF-8 mdash (—) that I get if I do a "save as" manually from LibreOffice Calc, it gives me a \227 (�). Using file on the CSV gives me "Non-ISO extended-ASCII text, with very long lines". So, two questions:
- What on earth is happening here?
- How do I tell libreoffice to convert to UTF-8?
The specific file that I'm trying to convert is here.