convert all excel files in folder to csv python
import pandas as pd
import os
import glob
source="D:\\source\\"
dest='D:\\dest\\'
os.chdir(source)
for file in glob.glob("*.xls"):
df = pd.read_excel(file)
df.to_csv(dest+file+'.csv', index=False)
os.remove(file)
for file in glob.glob("*.xlsx"):
df = pd.read_excel(file)
df.to_csv(dest+file+'.csv', index=False)
os.remove(file)