Split Excel Data into Multiple Files by Column Values using Python (fast & easy)

This tutorial will show you how to separate Excel Data into Workbooks by Column Values. Instead of VBA, we will be using Python and the Pandas Library. The Python code from this tutorial can be a huge time saver. You can apply the code from this tutorial also any other Excel – you just need to tweak it slightly.

Video Tutorial

Changes after releasing the video

• [Enhance] Use pathlib to handle file path locations & to create output directory
• [Bug Fix] Use fullmatch instead of contains (To prevent partial match, e.g. 'romania' and 'oman')

More Solutions

Explore my tools and templates for Excel, automation, and more.

View all solutions

Connect with Me

• YouTube: CodingIsFun
• Website: PythonAndVBA
• LinkedIn: Sven Bosau
• Contact: Get in Touch

Support

If you find this project helpful, consider buying me a coffee.