Convert XLSX to CSV correctly using python [closed]

Question

Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.

Questions asking us to recommend or find a tool, library or favorite off-site resource are off-topic for Stack Overflow as they tend to attract opinionated answers and spam. Instead, describe the problem and what has been done so far to solve it.

Closed 12 years ago.

The community reviewed whether to reopen this question last year and left it closed:

Original close reason(s) were not resolved

Improve this question

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

Another option is using pandas: df = pd.read_excel("./data.xlsx") and then df.to_csv("./data.csv", sep=",") — Ferus
– Ferus, Commented May 9, 2019 at 17:01

Julian · Accepted Answer · 2017-09-16 18:20:10Z

84

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()

edited Sep 16, 2017 at 18:20

Julian

1,0521 gold badge14 silver badges23 bronze badges

answered Nov 20, 2013 at 19:35

Hemant

1,36320 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Joran Beasley Over a year ago

at least use xlsx in your example(sort of yours at least it looks like it came from elsewhere :P) since thats what was asked :P

Hemant Over a year ago

@JoranBeasley this is not my answer. It came from the stackoverflow only. I tried to paste the hyperlink but somehow it was not coming in my comment. if for some reason I've violated any rule or policy of forum I'm really sorry for that.

Prasaz Over a year ago

Sometimes if the excel contains unicode characters you may need to specify the encoding, when creating/openning the destination file.

Jeroen Over a year ago

this solution no longer works. xlrd cannot handle xlsx anymore.

agfe2 Over a year ago

[pandas library] (geeksforgeeks.org/convert-excel-to-csv-in-python) can convert xlsx to csv

|

Collectives™ on Stack Overflow

Convert XLSX to CSV correctly using python [closed]

1 Answer 1

6 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Linked

Related