Skip to content

Instantly share code, notes, and snippets.

@datacustodian

datacustodian/Convert_Excel_to_CSV.md

Created January 10, 2019 03:29
Show Gist options
  • Save datacustodian/4dc3a9a9ec63240e11f590f122483850 to your computer and use it in GitHub Desktop.
Save datacustodian/4dc3a9a9ec63240e11f590f122483850 to your computer and use it in GitHub Desktop.
Download ZIP
Convert Excel to CSV
Raw
Convert_Excel_to_CSV.md

Convert Excel to CSV

https://wiki.openoffice.org/wiki/Documentation/DevGuide/Spreadsheets/Filter_Options

Note: Use --outdir option of soffice to specify a custom output directory.

TSV (9) UTF-8 (76)

find "`pwd`" -type f -iname "*.xls*" -exec soffice --headless --convert-to csv:"Text - txt - csv (StarCalc)":9,34,76,1,,0,false,true,true "{}" \;

CSV (44) UTF-8 (76)

find "`pwd`" -type f -iname "*.xls*" -exec soffice --headless --convert-to csv:"Text - txt - csv (StarCalc)":44,34,76,1,,0,false,true,true "{}" \;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment