Split a big CSV into smaller files by rows

Excel stops at 1,048,576 rows and many systems cap each import at a few thousand. Drop the CSV, set rows per file (header not counted), keep “Repeat the header in every file”, and get the pieces zipped. Encoding is detected automatically (UTF-8, GBK and others) and the output is UTF-8 with a BOM, so Excel opens it without garbled text. It splits by row, never through the middle of a row — unlike splitting by file size.

Runs in your browser · no upload · no sign-up

怎麼用

  1. 1 Drop a CSV or TSV file
  2. 2 Set rows per file and whether to repeat the header
  3. 3 Download all parts as a ZIP

能做

  • Splits by rows, never mid-row
  • Header repeated in every file
  • Detects UTF-8, GBK and other encodings
  • Outputs UTF-8 with BOM — opens cleanly in Excel

不能做

  • Does not split by file size (MB)
  • Does not group by a column value (use Split Excel)
  • Output is always comma-separated, not the original semicolon / tab

常見問題

My CSV is too big for Excel

Excel holds at most 1,048,576 rows per sheet. Split into parts under a million rows and each one opens.

Will non-English text be garbled?

No. Encodings like GBK are detected on read, and the output is UTF-8 with a BOM that Excel and WPS open correctly.

Can it split by file size?

No, by rows only. Splitting by bytes cuts rows in half and breaks imports.

What are the files called?

“name-01.csv, name-02.csv…” (zero-padded so they sort), in one ZIP.

How large a CSV can it handle?

We set no limit; it depends on your device’s memory. Files of a few hundred MB are usually fine on a computer, harder on phones.

Is the file uploaded?

No, it all happens in your browser.