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
Github link for the full python source code - https://raw.githubusercontent.com/sub...
pip command from required packages
pip install pandas
pip install xlsxwriter
pip install tkinter
