One lead list, a file per town and per rep
A sheet of five leads with town and rep columns. Splitting By a column's values on town gives four files, sorted by name. The slash in Bath/Bristol is not allowed in a file name, so it becomes an underscore.
Splitting the same sheet on the rep column gives three files, and the lead with no rep goes into a file called (blank), so nothing is dropped. Every file keeps the header row.
business,town,rep Kiln & Co Pottery,Frome,Asha Marlow Print Works,Bath,Ben Oak Lane Joinery,Frome,Asha Pip & Parsnip Deli,Wells, Tanner's Yard Cafe,Bath/Bristol,Ben
By town: leads-Bath.xlsx 1 row leads-Bath_Bristol.xlsx 1 row leads-Frome.xlsx 2 rows leads-Wells.xlsx 1 row By rep (CSV): leads-(blank).csv 1 row leads-Asha.csv 2 rows leads-Ben.csv 2 rows
Splitting a workbook
Choose how to split
One file per sheet, Every N rows or By a column's values. A single-sheet file switches to every N rows automatically.
Open the file
XLSX, XLSM, XLS, XLSB, ODS and CSV are accepted.
Set the details
Pick the sheet to split, then the Rows per file (1,000 by default) or the Column whose values decide the files.
Choose the format
Save as Excel or CSV. CSV files include a byte order mark so Excel reads accented characters correctly.
Check and download
The figures show the number of files, sheets in the book, rows in the sheet and the largest part. A list shows each file name and its row count. Press Download as ZIP.
Handing out territories and batches
Splitting by column is the quick way to share a prospect list fairly: one file per rep or per area means nobody sees, or calls, another person's leads. Check the column first for spelling variations, because Frome and frome become two files and a trailing space makes another. A column with hundreds of different values triggers a warning so you do not download hundreds of tiny files by mistake.
Splitting by rows suits import limits and campaign waves. Splitting by sheet is handy when a client sends one workbook with a tab per region and you need them as separate attachments.
- Values are exported as they display; formulas become their results.
- Formatting, charts and pictures are not carried into the new files.
- File names come from the workbook name plus the sheet, chunk or value, up to 60 characters.
Questions people ask
How do I split an Excel sheet into multiple files by a column?
Open the workbook, choose By a column's values, pick the sheet and the column, such as town or account manager, and download the ZIP. Each different value in that column gets its own file with the header row and every matching row. Blank cells are grouped into a file called (blank).
Can I split each worksheet into its own file?
Yes. Choose One file per sheet and every sheet in the workbook becomes a separate Excel or CSV file, named after the workbook and the sheet. That is useful when a workbook has a tab per region, client or month and each needs sending separately.
How do I split a large spreadsheet into smaller ones?
Choose Every N rows, set Rows per file to the size you need, and download. Each part has the header row plus up to that many data rows. Use this to fit a CRM or email platform import limit, or to plan outreach in equal batches.
Are formulas kept when splitting?
No. The split files contain each cell's displayed value, so a formula's result is kept but the formula itself is not. That keeps each part self-contained, because a formula that referred to another sheet would break once the sheets are in different files.
Where your data goes
The workbook is read with an open-source spreadsheet library inside your browser, and each part is written on your device. No sheet or row is uploaded.
Checked against the tool on