Excel to CSV

xls2csv.py

import xlrd
import csv
import sys

def csv_from_excel(fn):
    wb = xlrd.open_workbook(fn)
    sh = wb.sheet_by_index(0)
    your_csv_file = open(fn.replace('xls', 'csv'), 'wb')
    wr = csv.writer(your_csv_file, quoting=csv.QUOTE_ALL)
    for rownum in xrange(sh.nrows):
        row = sh.row_values(rownum)
        print row
        for i in range(len(row)):
            if isinstance(row[i], basestring):
                row[i] = row[i].encode('utf-8')
        wr.writerow(row)
    your_csv_file.close()

for f in sys.argv[1:]:
    csv_from_excel(f)