How to write CSV files into XLSX using Python Pandas?

Question

I have several .csv files and I want to write them into one .xlsx file as spreadsheets.

I've loaded these .csv files into Pandas.DataFrame using following code:

df1 = pandas.read_csv('my_file1.csv')
df2 = pandas.read_csv('my_file2.csv')
......
df5 = pandas.read_csv('my_file5.csv')

But I couldn't find any functions in Pandas that can write these DataFrames into one .xlsx file as separated spreadsheets.

Can anyone help me with this?

Could you add some specifics about how you're trying to write them? On separate sheets? Merged somehow? See DataFrame.to_excel() and if it can help you. — Ilja Everilä
– Ilja Everilä, Commented Aug 23, 2016 at 10:49
@IljaEverilä Hi, there. Yes, I want to write them into separate sheets. — ChangeMyName
– ChangeMyName, Commented Aug 23, 2016 at 10:50

Ilja Everilä · Accepted Answer · 2016-08-23 11:00:32Z

7

With recent enough pandas use DataFrame.to_excel() with an existing ExcelWriter object and pass sheet names:

from pandas.io.excel import ExcelWriter
import pandas

csv_files = ['my_file1.csv', 'my_file2.csv', ..., 'my_file5.csv']

with ExcelWriter('my_excel.xlsx') as ew:
    for csv_file in csv_files:
        pandas.read_csv(csv_file).to_excel(ew, sheet_name=csv_file)

answered Aug 23, 2016 at 11:00

Ilja Everilä

53.4k9 gold badges138 silver badges142 bronze badges

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

Collectives™ on Stack Overflow

How to write CSV files into XLSX using Python Pandas?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related