Split Excel File
Break a large workbook into manageable pieces.
Split by sheet, by the value in a column, or by a fixed number of rows. Each piece keeps the header row and the original formatting, and everything downloads as a single zip with predictable file names.
- Rating
- 4.9(2.7K)
- Monthly uses
- 358K
- Price
- Free
or drag it here
.xlsx, .xls, .csv · processed locally, never uploaded
Files stay on your device
What it does well
- Split by column value — one file per region, department or client
- Header row repeated in every output file
- Naming templates using the split value, index and original file name
How to use Split Excel File
- 1
Upload the workbook you want to split.
- 2
Choose the split mode: per sheet, per column value, or every N rows.
- 3
Set the file naming pattern.
- 4
Download the zip containing every part.
Watch a walkthrough
Common problems and fixes
Hundreds of tiny files were produced.
The split column has high cardinality. Pick a coarser column, or use the row-count mode with a larger chunk size.
The zip is missing some groups.
Groups with a blank key are skipped by default. Enable “Include blank group” to get them as a file named _blank.
Frequently asked questions
What people say
Our IT team blocked every other online tool because they upload files. This one does not, so split excel file finally got approved for use on real data.
Exactly what I needed. Split Excel File used to be a twenty-minute job with a macro I did not trust; now it takes one drag and one click.
Small thing, but the error messages actually tell you what to fix. Split Excel File flagged a hidden character that had been breaking my lookups for weeks.
More merge & split tools
Combine dozens of workbooks into a single file, or break a large workbook into per-sheet, per-value or fixed-size chunks in seconds.
Browse Merge & Split