Creating multiple CSV sheets in Python
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.
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.