Friday, February 14, 2014

Excel to CSV in Linux servers - Best option is libreoffice so far

So far libreoffice looks like the best alternative to convert excel to csv in linux servers. Installation ( for ubuntu/debian )
$ sudo apt-get install libreoffice-calc
Here is how to convert a file and put the result in the /tmp directory
$ libreoffice --headless --convert-to csv /tmp/foo.xls --outdir /tmp/ 
convert /tmp/foo.xls -> /tmp/foo.csv using Text - txt - csv (StarCalc)
It works for XLS and XLSX as well.

No comments: