from openpyxl.workbook import Workbook wb = Workbook() ws1 = wb.create_sheet("Sheet1") ws1.title = "Title1" ws2 = wb.create_sheet("Sheet2") ws2.title = "Title2" wb.save(filename="filename.xlsx")