writer2 = pd.ExcelWriter('mult_sheets_2.xlsx') df_1.to_excel(writer2, sheet_name = 'df_1', index = False) df_2.to_excel(writer2, sheet_name = 'df_2', index = False) writer2.save()