Split CSV

Split a big CSV into smaller files.

Loading tool…
Try next →CSV to ExcelCSV into an .xlsx spreadsheet.

About Split CSV

Split CSV breaks one large CSV file into several smaller ones. You choose how many rows each smaller file should hold, and it divides your data in order into evenly sized files, then hands them back together as a zip. It's useful when an import tool, spreadsheet, or upload form rejects a file that has too many rows.

The file is read in your browser with a JavaScript library, so your CSV stays on your own device and is never uploaded to a server. It's free, with no account, no sign-up, and nothing to install.

Frequently asked questions

Is Split CSV free to use?
Yes. It's completely free with no account and no sign-up. There's no cap on the file size or on the number of smaller files you create.
Is my CSV uploaded to a server?
No. The file is read and split locally in your browser, so your data stays on your own device. Nothing about the file is uploaded anywhere.
How do I split a CSV file?
Load your CSV, then enter how many rows you want in each output file. The tool divides the file into that many chunks and downloads all the smaller files together in one zip.
How many files will I get?
That depends on the row count you choose. If your file has 10,000 rows and you ask for 2,000 rows each, you'll get five files, and the last one simply holds whatever rows are left over.
Can it split by a column value instead of by rows?
No. It only splits by row count, cutting the file every set number of rows in their existing order. It doesn't group or sort rows by the values in a column.