Convert multiple CSV files into single Excel fille separate sheets using Pandas and xlsxwriter

Convert multiple CSV files into single Excel fille separate sheets using Pandas and xlsxwriter

Open folder containing multiple csv files and export them to single excel file in individual worksheets.

00:53 Demonstration of converting CSVs to Excel
00:43 Explaining the GUI implementation using python tkinter
08:19 Explaining functions save_to_excel
08:57 Explaining functions open_directory
09:17 Explaining functions convert_to_excel

pip command from required packages
pip install pandas
pip install xlsxwriter
pip install tkinter