XLS to CSV Conversion


I think its hard or we don’t have any way to handle xls files form command line.

Some times we may forced ourselves to use command line options to handle xls files for quick solution.

Recently I fond xls2csv tool which will convert xls to csv file. I hope csv will give us lot of control while handling form command line.

How to install xls2csv:

xls2csv module is available in catdoc. Install catdoc with following command.

$ sudo apt-get install catdoc

We also can use catdoc to read MS-Word file and it puts content as plain text on standard output.

How to convert xls to csv:

Use following command to convert

$ xls2csv input.xls

The command will print text on standard output. You can redirect it to a csv file and use them for processing.





Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s