convert excel file with multiple sheets into csv python code example

Example: 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)