Split Excel by Column Value — One File Per 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.
What is Excel file splitting?
Excel file splitting is the act of dividing a single .xlsx or .xlsm workbook into multiple smaller workbooks based on a chosen rule. The three common shapes: by sheet (each sheet in the original becomes its own file — useful when one workbook accumulated multiple distinct datasets), by row count (every N rows becomes a separate file — useful for chunking before an upstream import that has a row limit), and by column value (every unique value in a chosen column produces its own file — useful for distributing per-region, per-client, or per-store cuts of a master report).
SimpleTool's Excel splitter runs entirely in your browser using SheetJS. Source files never leave your device. The output is a ZIP archive containing one .xlsx per split target — named after the value that produced it (North.xlsx, South.xlsx) or numerically (chunk-001.xlsx, chunk-002.xlsx). Each output preserves the original column headers and formatting on the split sheet.
When do you need to split an Excel file?
Concrete distribution and chunking workflows where splitting locally beats writing a VBA macro or uploading to a cloud splitter.
Per-region weekly distribution
A weekly master report has columns including Region (North/South/East/West/EMEA/APAC). Each regional manager only needs their own slice. Splitting by the Region column produces one file per region named with the region value, ready to attach to per-region emails.
Per-client confidential cuts
A multi-client report accidentally includes data from every client in one workbook. Splitting by Client column produces one file per client containing only their rows — solves the "this report has competitor data on the next sheet" privacy problem in one pass.
Per-store inventory or sales reports
Retail head office maintains a master inventory or sales workbook with one row per SKU-store combination. Each store manager wants only their store. Splitting by Store_ID produces per-store files for distribution.
Per-rep CRM exports
A CRM export contains every rep's pipeline in one file. Sales leadership wants each rep to receive only their own pipeline for the weekly 1-on-1. Splitting by Owner column gives each rep a per-rep file.
Chunking for upstream row-count limits
You're importing to a system that caps imports at 10,000 rows per file (or 1,048,576 — Excel's sheet row limit). Splitting by row count into chunks of 10,000 produces the right-sized files for the import target.
Per-month splits from an annual file
A year's sales / expense / activity log lives in one workbook with a Month column. Splitting by Month produces 12 per-month files for archiving or board distribution by reporting period.
Per-sheet extraction from a multi-tab workbook
A workbook accumulated 30 tabs over the year, each a distinct dataset. Splitting by sheet produces 30 standalone .xlsx files, each carrying just one of the original tabs — usable as separate inputs to downstream tools.
Per-supplier or per-vendor splits
Procurement maintains a master purchase order or AP master file. Splitting by Vendor produces per-vendor files for shipping to each vendor for their own reconciliation. Each vendor sees only their own line items, not their competitors'.
Excel Split Methods Compared: SimpleTool vs Power Query vs VBA vs Cloud Splitters
Four ways to slice a workbook. Different setup cost, different data-exposure trade-offs.
| Feature | SimpleTool | Power Query | VBA Macro | Cloud Splitters |
|---|---|---|---|---|
| Cost | Free | Bundled with Excel | Bundled with Excel | Free with limits |
| Files stay private (no upload) | Yes | Yes (desktop) | Yes | No — uploaded |
| Setup time | 30 seconds | 30-60 min to write | 20-60 min to write | 2 min per split |
| Split by sheet | Yes | Yes (M code) | Yes (loop) | Yes |
| Split by row count | Yes | Yes (M code) | Yes (loop) | Often paid |
| Split by column value | Yes | Yes (M code) | Yes (loop) | Often paid |
| Output as ZIP archive | Yes | Manual export | Coded | Yes |
| Output file naming from values | Yes (automatic) | M code | Coded | Variable |
| Works without Excel installed | Yes (browser) | No | No | Yes (browser) |
| Account required | No | Microsoft account | No | Usually yes |
The Power Query route is great for a recurring split that runs the same way every week — invest 30 minutes once, re-run forever. SimpleTool wins when the split rule shifts (this week by region, next week by client), when the source file template changes, when you don't have Excel install permission, or when the data is sensitive enough that you don't want a cloud splitter or a Microsoft cache touching it.
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