How to use
- Drop an
.xlsx,.csvor.tsvfile, or paste cells copied from Excel. This page opens with a Split into files step already added. - Choose Split by: N rows per file, column value, or N equal parts.
- Choose Save as: ZIP (several xlsx files), ZIP (several csv files) or one xlsx file (several sheets).
- Check each file’s (or sheet’s) name and row count in the split results list under the preview.
- Download to get
original_split.zip. The sheet mode produces a singleoriginal_cleaned.xlsx.
Ways to split
| Mode | Setting | Result |
|---|---|---|
| N rows | Rows per file | Cuts N rows at a time from the top and puts the leftover rows in the last file. Names are filename_01, filename_02… (sales.xlsx gives sales_01) |
| Column value | Column to split by | One file per value, in order of first appearance, named after the value (sanitized) |
| N equal parts | Number of files | Divides the rows by N and the first files take one extra row each. If there are fewer rows than files, you get one file per row |
The header is repeated in every file. With a 10-row table (not counting the header):
- 4 rows per file → three files of 4, 4 and 2 rows (
Split into 3 files (2–4 rows each)) - 3 equal parts → 4, 3 and 3 rows (the one leftover row goes to the first file)
- 100 equal parts → only 10 rows exist, so you get 10 files of 1 row
File naming rules
When you split by column value, the value becomes the file name. Characters that cannot be used in file names | \ / : * ? " < > | and control characters | turn into _, surrounding spaces and trailing dots are removed, and only 80 characters are kept. So a/b becomes a_b, and an empty value (including a cell with only spaces) becomes a (blank) file. If sanitizing makes two names equal (a/b and a_b, or names differing only in case) they get (2), (3). Spaces around a value are ignored for grouping, but the cells themselves are not edited.
Choosing a format
- ZIP (xlsx): one single-sheet xlsx per file, each with a bold header, fitted column widths and the text-column settings.
- ZIP (csv): the delimiter, encoding (UTF-8 BOM by default, CP949 optional) and line ending from the export settings below apply to every file, and characters CP949 cannot represent become
?with the count reported. - One xlsx file (several sheets): the pieces become sheets. Sheet names follow the 31-character limit and the
[]:*?/\rule.
Good to know
- Results are capped at 500. If a column has 501 or more distinct values, or the rows-per-file setting would make more than 500 files, you get an error; raise the number and try again.
- An Excel sheet holds at most 1,048,576 rows, so a larger CSV is easier to open in Excel once split by N rows.
- With splitting as the last step, export becomes a ZIP; adding another step after it drops the split and continues with the original table. Put sort, filter and dedupe steps before the split.
- The original table is not changed, and nothing is converted to numbers when reading, so leading zeros survive.
Related tools
- Combine files into one: Merge Excel & CSV Files
- Cut any file into byte-sized pieces: File Splitter & Joiner
- Zip files together: ZIP Creator
- Sort or filter before splitting: Sort & Filter Spreadsheet
Your file is processed only in your browser and is never sent to a server.