March 2010

How to convert xls files to csv in Linux

Install xls2csv

yum -y install xls2csv

To convert your xls file to csv, just type this command:

convertxls2csv -x filename.xls -c filename.csv

This script is very useful if you have a lot of excel files to convert. This will help you save a lot of time than converting it one by one.

#!/bin/bash
for files in *.xls
do
convertxls2csv -x "$files" -c "${files%.*}.csv"
done