Improving Excel with Python (Day 1 of 5)

My starter scripts in January 2021:

Combine multiple Excel files from a folder

I always advocate finding a problem early on when picking up a new programming language. It works for me, giving my learning structure and pulling me towards a goal.

With Python, I started with cheatsheets for basic familiarity and then picked up the O’Reilly Cookbook, always with the aim in mind - that I would start my Python journey writing scripts that solve problems I see in Excel.

The first problem is managing multiple Excel files - sometimes separate files are best (faster/share-able), other times I want all the data in a single Excel Sheet, for analysis; today I’m showing the latter.

So here’s a snippet that loops through each Excel file in a folder (including subfolders), collects the data in the first sheet, and adds a new column for reference back to the filename. The aggregated data is then output to a new Excel Workbook.

Any thoughts or questions, get in touch

Have a look at the code I used, here:

Recent Posts

See All

Frequently Asked Questions, by phone

I have a warning message When does it happen? Can you send a screenshot to us? Also, if you can, please email the PDF input document to us (or upload it using the 'File' menu within StatementReader) a