import pandas as pd # Read the Excel file with all sheets excel_file = 'your_excel_file.xlsx' xls = pd.ExcelFile(excel_file) # Iterate through each sheet and export as CSV for sheet_name in xls.sheet_names: df = pd.read_excel(excel_file, sheet_name=sheet_name) df.to_csv(f'{sheet_name}.csv', index=False)