top of page

Improving Excel with Python (Day 2 of 5)

My starter scripts in January 2021:

Split Excel file into separate files

As an extension on yesterday’s problem (combining multiple Excel sheets into a single Excel Sheet), today I am showing how to split a single Excel Sheet into multiple Excel files, which can be handy for managing the access to a dataset that splits easily into parts.

Here is a snippet showing how to read the first sheet from an Excel file, split the data by the first column, and save each part into separate Excel files, which are named after the value in the first column.

This is a continuation of my journey learning Python while applying it to problems that I see working with Excel; tomorrow I look at a script to manage file attributes (like title, description and subject) for version control, or author credit.

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