writer = pd.ExcelWriter("sample.xlsx") df1.to_excel(writer, shet_name = "sheet1") df2.to_excel(writer, sheet_name = 'sheet2') writer.save()