Excel Split
Splits one Excel or CSV file into several smaller files. Three strategies: by sheet, by row count, or by column value.
What it does
Use this to turn a 10-tab Excel into 10 separate files, break a 100K-row report into 10K chunks, or separate a customer list into one file per city.
How to use
- Drag files into the list.
- Pick a Split Method.
- Set the row count or grouping column for that method.
- Pick the Sheet to Process (for Excel inputs).
- Click Run.
Output files follow the pattern {original}_{chunk}.xlsx.
Split methods
| Method | What it does |
|---|---|
| By Sheet | Each Excel sheet becomes its own file. 5 sheets = 5 files. |
| By Row Count | Splits the data into chunks of the size you set. 100K rows / 10K = 10 files. |
| By Column Value | One file per unique value in the column you pick. Split by city, category, customer. |
Examples
Break a multi-sheet Excel into files: Add the Excel, By Sheet, run. Each sheet is now its own .xlsx.
Chunk a large report: Add the 100K-row file, By Row Count, 10000 per file, run. You get 10 files.
Split customers by city: Add the customer list, By Column Value, Grouping Column city. One file per city.
Split emails by status: Add the Excel, By Column Value, Grouping Column status. Separate files for "Open", "Closed", "Pending".
Watch out
- Splitting by column value produces one file per unique value. 1000 unique values means 1000 files, be careful.
- The row chunk size can be between 1 and 1,000,000.
- In batch mode the grouping column list comes from the first file only.
- Output is always
.xlsx. Even if the input is CSV the output is Excel. - Encrypted Excel files are not handled.
License
Free tier has a monthly split cap. Office plan removes it.