Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to convert .csv to .xls

I have a simple .csv file.

Is it possible to convert it to .xls using the command line tool ssconvert?

I would also need to specify the name of the sheet.

like image 855
RockScience Avatar asked Oct 19 '25 08:10

RockScience


1 Answers

ln -s input.csv MySheetName
ssconvert MySheetName output.xls

The OP asked how to convert csv to xls while controlling the sheet name in the output.

The generated .xls file will use the name of the input CSV file as the sheet name, so you can symlink the .csv to anything you want (or rename the input file) to produce the desired result.

The previous answer implies that --list-exporters leads to a solution, but it merely lists exporter names with no information about their options, and no options are documented in the man page for xls-exporters. Experimentally, none of the exporters which can create .xls accept options (they fail with "The file saver does not take options" if you use -O).

like image 122
jimav Avatar answered Oct 22 '25 03:10

jimav