top of page

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

Improving Excel with Python (May 2022)

Revisited starter script from January 2021: Split Excel file into separate files Excel is essential, and Python is the future - forcing ourselves to practice the latter by automating some of the commo


Message us or

Call us on +44 (0)20 3287 8283

Mon to Fri: 8am-8pm

Weekends: 10am-6pm

bottom of page