Split an Excel File by Column Value
For ops analysts who distribute weekly per-region or per-client cuts: drop your master workbook, pick a column to split on, and get a ZIP with one file per unique value — North.xlsx, South.xlsx, East.xlsx… Three split modes (sheet, row count, or column value), all client-side, no VBA, no install.
Manage Projects Like a Pro in Excel 📊
Get our premium Excel Gantt Chart Template with automated dependencies.
Your file never leaves your browser — guaranteed.
Splitting happens locally in JavaScript. No filenames, no row contents, nothing about your spreadsheet is transmitted to any server. You can disconnect from the internet and the tool still works.
Drop your Excel file here, or click to choose
Accepts .xlsx and .xlsm.
How it works
When do I use each mode?
- By sheet — your master file has multiple sheets and you need each as its own file (e.g. one tab per branch).
- By row count — you have one giant sheet and need fixed-size chunks (e.g. 1,000 rows per file for batch upload limits).
- By column value — you have one sheet and want one file per unique value in a column (e.g. one file per region).
Why is there a 200-file cap?
Splitting on a high-cardinality column (like customer_id) can produce thousands of tiny files. The cap protects you from accidentally generating an unmanageable ZIP. Pick a less granular column or use row-count splitting instead.
What about formulas and formatting?
Cell values are preserved. Formulas evaluate to their last cached values; rich-text formatting and styles are dropped. Each output file is a clean data sheet.
More Productivity Tools
Explore our other privacy-focused tools designed to boost your productivity
Excel Password Remover
Remove password protection from Excel files safely in your browser
Excel Books Comparer
Spot differences between two Excel workbooks instantly — no uploads
Excel Keyword Formatter
Bold, colour, and italicise keywords inside Excel cells — 100% private