excel2csv

NAME

SYNOPSIS

excel2csv file.xlsx

excel2csv [ -t separator ] [ -s sheets ] [ -o outputdir ] file.xlsx

AVAILABILITY

DESCRIPTION

The CSV file is saved as UTF-8 and newlines in multi line fields are retained.

The exported worksheets CSV files are named worksheetname.csv and are saved to the current working directory (if the '-o outputdir' option is not used), whereas already existing files are overwritten.

OPTIONS

-h

usage message.

-V

print program version.

-t separator

field separator of CSV output data.

The default output separator is a comma (,).

-s sheets

case-sensitive comma- or semicolon-separated (example: servers,routers,pricelist) list of worksheet names to export to CSV files.

Default is to export all worksheets whose names contain a dot (.), for example: myschema.mytable.

To export all worksheets, specify: -s ALL

If the worksheet with the name ALL shall be exported, specify: -s ALL, or -s ALL;

-o outputdir

output directory to write the exported CSV files to.

file.xlsx

Excel™ workbook to export the worksheets from.

EXIT STATUS

0

no error.

1

error.

4

usage displayed.

5

version message displayed.

FILES

EXAMPLES

SEE ALSO

NOTES

BUGS

excel2csv cannot be started thru SSH.

VERSION

AUTHOR

COPYRIGHT

This is free software; see https://www.gnu.org/licenses/gpl-2.0.html for copying conditions. There is ABSOLUTELY NO WARRANTY; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.