CSV Splitter
Split a large CSV into several files of a set number of rows, with the header repeated in each, and download them one by one or all in a ZIP.
How to split a CSV file
Add your CSV
Paste the text or choose a file. Large files are read on your device.
Set the rows in each file
Say how many rows each part should hold, and whether the first row is a header to repeat.
Download the parts
Download each file, or all of them in one ZIP.
Worked example
This is what CSV Splitter gives for its own sample values. Open the tool above and change anything to try your own.
CSV text (or choose a file below)
id,name,city 1,Ann,Paris 2,Bob,Rome 3,Chloe,Lisbon 4,Deepak,Pune 5,Elena,Oslo
- Rows in each file
- 2
- Delimiter
- Detect automatically
- First row is the header, repeat it in every file
- Yes
- Name for the files
- part
Result
- Rows in the data
- 5
- Files
- 3
- Columns
- 3
About CSV Splitter
Cut a big CSV into smaller files, for tools that limit the file size or the number of rows. The header row is repeated in every file, quoted fields with commas or line breaks stay intact, and the parts are named in order.
FAQs
Is there a size limit?
No fixed limit. Very large files depend on your device's memory, so close other tabs for files of hundreds of megabytes.
Is the header repeated?
Yes, in every file, unless you untick the header option.
Can I join the parts again?
Yes. Use CSV Merge.