Python convert extracted excel file to csv

Question

Need help in Python code. My requirement is to extract all the excel files from source folder, convert to csv, move these csv files to target folder and delete all excel files in source folder. I tried the following command but it just converts the excel files to csv. 

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) 

Answer 1

Try the following script:

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)

Answer 2

Some services require table data in CSV format. If you have information in Excel files, it is easy to export it to CSV format using this free online Excel converter. It produces converted copies similar to desktop Total Excel Converter, but does not require installation and license registration.

This is an excellent solution for one-time quick conversion, when there is no time to install software on the computer and no need to do that often. When you convert Excel to CSV online, you will not be offered to set any options, and this saves your time significantly.

Comments

Is there an API that I can use with Python?