Split CSV
Loading tool…
About Split CSV
Upload or paste a CSV. Split by is Max rows per file (default) or Number of files. The size field defaults to 1000. Each part repeats the header. Quoted newlines inside fields do not split a row. Output is UTF-8 with Windows newlines and no BOM.
Open Download, then choose Just this file for the selected part ({stem}-part-01.csv) or Zip with all files ({stem}.zip). The button reads Zipping while the archive builds. If Number of files is larger than the data row count, you get fewer files, not empty ones. A header with no data rows is an error.
How to use Split CSV
- 1Drop or paste the CSV. A header row is required so it can repeat on every part.
- 2Choose Split by. Max rows per file, or Number of files. Default size is 1000.
- 3Open Download. Just this file is the selected part. Zip with all files packs every part.
- 4Open one part. Confirm the header is on row 1.
Split modes
Max rows per file chunks the body (header excluded from the count) into files of that many rows. Number of files splits the body as evenly as possible. The list shows part-01.csv. Downloads use {stem}-part-01.csv inside the zip.
Limits and privacy
Splitting runs in your browser. The CSV is not uploaded. Upload is 15MB max. Paste is not size-capped. No account.
FAQs
- Do quoted line breaks split a row?
- No. The CSV parser keeps a quoted newline inside the cell.
- What if I ask for more files than rows?
- You get fewer files, not empty ones.
- Is there a BOM on the parts?
- No. UTF-8 without BOM. Newlines are Windows-style.
- Can I download only one part?
- Yes. Select a part in the list, then Just this file. Zip with all files still has every part if you need them all.
- How large can the source CSV be?
- 15MB for an uploaded source file. Paste is not capped the same way.