📊 Excel Filter Tool v11.0
Split & Filter Excel Files by Column Values — In Seconds!
Built with ❤️ by HARSH KHATRI https://github.com/HarshKhatri-2000?tab=repositories
Got a massive Excel file with hundreds of employees under different managers?*
Need separate files for each manager? This tool does it in ONE click.*
Imagine you have an Excel file like this:
| Name | Department | Manager | Salary |
|---|---|---|---|
| Alice | Sales | John | 50000 |
| Bob | IT | Sarah | 60000 |
| Charlie | Sales | John | 55000 |
| Diana | IT | Sarah | 62000 |
| Eve | HR | Mike | 48000 |
This tool splits it into separate files:
📁 Output Folder/
├── John.xlsx → Contains Alice & Charlie's data
├── Sarah.xlsx → Contains Bob & Diana's data
└── Mike.xlsx → Contains Eve's data
That's it. Simple. Fast. No formulas broken.
| Feature | Description |
|---|---|
| 🎯 Smart Filtering | Filter by ANY column — managers, departments, cities, whatever |
| 📑 Multi-Sheet Support | Process all sheets or pick specific ones |
| 🧮 Formula Handling | Smart/Keep All/Values Only — you choose |
| 🎨 Formatting Preserved | Column widths, fonts, colors — all kept intact |
| 🔍 Search & Select | Search through values, select all/none/invert |
| 📊 Summary Report | Auto-generate a summary of what was created |
| ⚡ Threaded Processing | UI stays responsive even with huge files |
| 📝 Activity Log | Real-time log with export option |
| 🚫 Cancel Anytime | Stop processing mid-way if needed |
Option 1: Run from Source (Recommended)
Step 1: Make sure you have Python 3.7+ installed
👉 Download Python (check "Add to PATH" during install!)
Step 2: Clone this repo
git clone https://github.com/HarshKhatri-2000/Excel-Filter-Tool_Multi-Sheet.git
cd "Your Path"Step 3: Install dependencies
pip install -r requirements.txt
OR
py -m pip install -r requirements.txt
Step 4: Run the GUI Python File
python excel_filter_tool.py
Go to https://github.com/HarshKhatri-2000/Excel-Filter-Tool_Multi-Sheet/releases and download the latest .exe file. "No Python needed!"
Run Below Command
py -m pip install .
This will make all the necessary Files
If this tool saved you time, give it a ⭐ — it helps others find it too!