Convert Excel spreadsheets into TSV, CSV, Json or Yaml format.
Excelsior is a tool to convert Excel spreadsheets into TSV, CSV, Json or Yaml. Reads all sheets of the spreasheets.
$ pip install excelsior
Excelsior by default outputs into standard output, and separate sheets are then separated by a form feed <https://en.wikipedia.org/wiki/Page_break#Form_feed> and new line characters (^L^N), followed by a header line of the form # Sheet name #.
When writing onto files with the -w option, no such characters or headers are written.
$ excelsior -f tsv excel.xlsx
Convert into TSV and write to files:
$ excelsior -w -f tsv excel.xlsx another-excel.xls
This will save the output into <filename>.tsv, if the spreasheet has only one sheet, or <filename>-<sheet>.tsv if it has multiple sheets.
You can also pipe in the filenames (separated by newlines):
$ echo "excel.xlsx\nanother-excel.xls" | excelsior -w -f tsv
$ excelsior -h