Split a CSV file
Open a CSV file, choose a row count or a column, and download a zip of smaller CSV files. Each file keeps the header row, the separator and the quoting of the original. No sign-up.
Your file is never uploaded. Everything runs in your browser; this page makes no network requests while converting.
Drop a CSV file here or click to choose
.csv, .tsv or .txt; comma, semicolon, tab or pipe separated; large files are read in pieces
Need to put files back together? Use Merge & clean CSV files.
FAQ
Is my file uploaded?
No. The file is read and split by JavaScript in this tab. You can check this in your browser's developer tools: the Network tab shows no requests when you split.
Is the header kept?
Yes. The first row is treated as the header and is repeated at the top of every output file.
What happens to quotes, commas and line breaks inside cells?
Each row is copied exactly as it appears in your file, so quoted cells that contain commas, quotes or line breaks stay as they were. The separator (comma, semicolon, tab or pipe) and a UTF-8 BOM at the start of the file are kept too.
How does splitting by column work?
Pick a column and each different value in it gets its own file, for example one file per account or per month. Rows with an empty value go to a file whose name ends in (empty), for example orders-(empty).csv. A value made only of spaces gets its own file, separate from the one for empty values. Up to 1000 files can be made in one run.
How big a file can I split?
Files with a million rows or more can work, because the file is read in pieces. The limit depends on your device's memory, since the zip is built in the tab before download.
Are blank lines kept?
Empty lines and lines with only spaces or tabs are skipped and counted in the summary. In a tab-separated (TSV) file, a line of only tabs is kept as a row of empty cells. Every other row is kept, and the summary shows rows in and rows out so you can check the totals.
Should I check the result?
Yes. Look at the counts in the summary and open a few of the files before relying on them.