Every N rows, or one file per value of a column. Each part keeps the header, and they come back as a single zip. Nothing is uploaded.
Why the parts arrive as a zip. Browsers stop a page after the first couple of downloads, so a tool that saves twenty files one by one quietly loses most of them. This page builds the zip itself, in the page, with no library and no server — you get one file and all the parts are in it.
| Header row | Repeated at the top of every part, so each file opens correctly on its own. |
|---|---|
| Delimiter | Comma, semicolon and tab are detected, and the parts are written with the same one. |
| BOM & line endings | Taken from the original and written back, so Excel opens the parts with accented and Turkish characters intact. |
| File names | By rows: name-part-01.csv. By column: name-<value>.csv, with characters that are illegal in file names replaced. |
| Grouping | When splitting by a column, values that differ only in case or spacing land in the same file. |
| Size | Held in memory. Comfortable up to a few tens of thousands of rows. |
Does every part keep the header row? Yes. The header is repeated at the top of every part, so each file opens correctly on its own in Excel or any other tool.
How do I get the parts out? All parts are packed into a single zip file that you download in one click. Browsers block a page from starting many downloads in a row, so a zip is the reliable way.
Can I split one file per customer or per region? Yes. Choose split by column and pick the column. One file is produced for each distinct value, named after that value. Values that differ only in case or spacing are grouped together.
Does the file leave my computer? No. There is no server behind this page. The file is read with the browser's File API and the zip is built in the page. Once loaded, it keeps working with the network off.
Sheet Insights reads the whole thing at once and gives you the summary, the trends, the statistics and the data-quality report without cutting it up first. Same rule as this page: everything runs in your browser, with no server behind it.
See what Sheet Insights does