Convert XLSX to CSV correctly using python [closed]
I am looking for a python library or any help to convert .XLSX files to .CSV files.
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()