Creating multiple CSV sheets in Python

Question

Is there any way to create a CSV file with multiple sheets programmatically in Python?

skeevey · Accepted Answer · 2013-03-04T20:14:17.410

15

Multiple CSV files. One CSV file per sheet.

A comma seperated value file is a plain text format. It is only going to be able to represent flat data, such as a table (or a 'Sheet')

For storing multiple sheets, you should use separate CSV files. You can write each one separately and import/parse them individually into their destination.

edited Mar 04 '13 at 20:14

answered Mar 04 '13 at 20:09

skeevey

611
4
11

Thanks slackware, I understand now – ianlokejj Mar 04 '13 at 20:25

Christopher Nuccio · Answer 2 · 2018-10-25T16:22:24.600

6

The xlsxwriter library is what you're looking for. It can make a workbook with multiple sheets.
Look at the link for tutorials and code.

P.S I am answering this because this is the first result I got when searching on how to do this. Hopefully this helps others.

edited Oct 25 '18 at 16:22

answered Oct 24 '18 at 12:47

Christopher Nuccio

596
1
9
21

score 2 · Answer 3 · answered Mar 04 '13 at 20:18

Not sure what you are trying to do with Multiple Sheets of CSV's. Let me elaborate my thinking on this.

Maybe you want a folder with different CSV files in it.
If you "can" use XML then probably you may want to have XML sheet in a big XML "Workbook".

Haven't seen multiple sheets of csv yet.

score 1 · Answer 4 · edited May 20 '20 at 21:54

This worked for me as a conversion from excel to CSV while exporting individual sheet names.

    xls = pd.read_excel/csv('file name.xls/csv', sheet_name =['1','2','3','4','5','6','7','8','9','10'])

    #list out the sheets  you want to export in the bracket above separated by commas and ' '

    for sheet_name, df in xls.items():
     df['sheets'] = sheet_name    
     df[['sheets']].to_csv(f'{sheet_name}.csv', header=None)
    export_csv = df.to_csv (r'Location you want to export to on your machine',
                            index = None, header=True)

Creating multiple CSV sheets in Python

4 Answers4

Linked