Split CSV

Split a CSV file into smaller files by row count.

When to use it

Use it when a CSV is too large for a program's import limit, or to send a long list in smaller parts.

How it works

  1. Choose your files, or drop them onto the box above. You can add several at once.
  2. Add a CSV, choose how many rows each file gets and whether the first row is a header to repeat in every file. The preview lists the files before you split.
  3. Press the Split CSV button.
  4. Download the result, or add a next step without downloading.

Supported formats

Input
CSV, TSV, TXT
Output
CSV
Files
One or several; each file is processed on its own

Several results can be downloaded one by one or together as a ZIP.

Where your file goes

This tool runs in your browser: the file is processed on your device and is not uploaded. The Network tab of your browser's developer tools shows this.

What is kept, and what is not

Every value is copied exactly, in the same order, with the same separator, line endings and byte-order mark. Quoted fields with commas or line breaks stay whole.

Limits

  • At most 500 files per split and a 50 MB file. The whole file is read in your browser, so a larger CSV has to be divided first.
  • Files up to 512 MB each.
  • The work happens in your device's memory, so a phone may fail on a file that a computer handles.

If something goes wrong

The split stops with a quote error

A quote opens a field that is never closed, so the rest of the file would become one cell. Fix the quote in the source file and try again.

The page becomes slow with a very large file

Close other tabs, or use a computer instead of a phone.

My file is not accepted

Check the formats listed above. A damaged file, or one with the wrong extension, is refused with a message saying why.

Questions

Is the header row repeated?

Yes, when “First row is a header” is ticked: every file starts with it, and it is not counted as a data row.

Can a row break apart between two files?

No. The file is read record by record, so a quoted address with a line break in it always stays one row.

Continue with the result

The result can go straight into another tool on this page, without downloading it and uploading it again:

Related tools