CSV Splitter
Split a large CSV into smaller files by row count. Choose the rows per file, remove the header if you need to, and download every file. Free, no sign-up.
When to split a CSV
Many systems limit how many rows they accept at once, and very large files can be slow or impossible to open in a spreadsheet. Splitting a CSV into smaller files lets you import or review the data in manageable batches.
Finance teams run into this often. Xero, for example, limits a batch payment to 200 payments, which is why this tool starts at 200 rows per file.
How to use the CSV splitter
- Upload your CSV, or drag it onto the upload box.
- Enter the number of rows you want in each file. The default is 200.
- Leave Remove CSV header on to drop the first row, or turn it off to keep that row at the top of every file.
- Click Process CSV.
- Click the download button to save every file at once, or download individual files from the list.
Example: splitting 2,000 rows
A CSV with 2,000 rows of data, split at 200 rows per file, produces 10 files of 200 rows each. If the data doesn't divide evenly, the last file holds the remainder: 2,050 rows gives 10 files of 200 and one file of 50.
Files are numbered in their original order, such as payments-part-01-of-10.csv, so they sort correctly in a folder.
CSV splitter questions
Is this CSV splitter free?
Yes. There's no sign-up and no limit on how many files you split.
Is my CSV uploaded to a server?
No. The file is read and split entirely in your browser, so your data never leaves your device.
What does Remove CSV header do?
When it's on, the first row of your CSV is left out of every output file. When it's off, the first row is added to the top of every file and doesn't count towards the rows per file.
Why did my browser ask about downloading multiple files?
Browsers ask for permission when a website saves several files in a row. Choose Allow to receive them all, or download the files one at a time from the list.
Will it break rows that have commas or line breaks inside them?
No. Text inside double quotes stays together, so a quoted field containing a comma or line break remains part of the same row.
Are blank rows included?
No. Completely blank lines are left out and don't count towards the rows per file.