Split CSV
Cut a big CSV into pieces that Excel, a database import or an email attachment can handle.
About Split CSV
Load a CSV and choose how to cut it: a fixed number of rows per file, a largest file size, a number of equal parts, or one file per value in a column such as country or status. The header row is copied into every piece. Rows with line breaks inside quotes are kept whole, because the file is read record by record and not line by line. Pieces come as single downloads or one ZIP.
- Opening a file that is too long for a spreadsheet.
- Staying under an upload limit that caps rows or megabytes.
- Giving each team or region its own file.
- Running an import in smaller batches.
How to use Split CSV
Step 1
Choose the CSV file. The page shows its rows, columns and delimiter.
Step 2
Pick a way to split and set the number, size or column.
Step 3
Press the split button, then download single files or the ZIP.
Good to know
- Splitting by column value makes one file per distinct value, up to 1,000 files. A column with thousands of different values will be refused.
- Rows are never cut in the middle, so a file can end up a little over a size limit if one row is large.
- The text is read as UTF-8 and written back unchanged. Files up to 150 MB are accepted, but very large files need enough free memory in your browser.
Common questions
Does it keep quoted line breaks and commas?
Yes. A field wrapped in quotes can contain commas and new lines, and the whole row stays in one piece.
Is the header repeated?
By default every file starts with the header row. Untick the option if your file has no header.
Is my file uploaded?
No. Splitting happens in your browser and nothing is sent to our server.