I had a need to regular convert excel to csv file for processing instead of every time opening them in excel and save as CSV, below Python script using Pandas library converts all excel files in the given directory to CSV files.
import pandas as pd
import os
path = '/Users/shravan/Documents/files/'
csv_dir_path = os.path.join(path, 'csvs')
files = os.listdir(path)…