Python convert excel file to csv

Question

Can someone share a python code to convert all excel files to a csv file?

Answer 1

Here you go:

import glob 
path_to_excel_files = glob.glob('path/to/excel/files/*.xlsx')
for excel in path_to_excel_files:
 out = excel.split('.')[0]+'.csv'
 df = pd.read_excel(excel)
 df.to_csv(out)