49
votes

I am looking for a python library or any help to convert .XLSX files to .CSV files.

1
Another option is using pandas: df = pd.read_excel("./data.xlsx") and then df.to_csv("./data.csv", sep=",") - Ferus
Pandas actually uses xlrd under the hood. - flow2k

1 Answers

79
votes

Read your excel using the xlrd module and then you can use the csv module to create your own csv.

Install the xlrd module in your command line:

pip install xlrd

Python script:

import xlrd
import csv

def csv_from_excel():
    wb = xlrd.open_workbook('excel.xlsx')
    sh = wb.sheet_by_name('Sheet1')
    your_csv_file = open('your_csv_file.csv', 'w')
    wr = csv.writer(your_csv_file, quoting=csv.QUOTE_ALL)

    for rownum in range(sh.nrows):
        wr.writerow(sh.row_values(rownum))

    your_csv_file.close()

# runs the csv_from_excel function:
csv_from_excel()