Free · no signup · browser-local

Split CSV by Row Count and Repeat the Header

Split a local CSV into smaller files by data record count, keeping the header in each part and respecting quoted fields.

Browse all tools →

Split a CSV file

Processed locally. Each UTF-8 file can contain up to 2 MiB, 10,000 records and 100 columns.

Output files

Choose files or try the example to preview the output.

Getting started

Choose a UTF-8 CSV, select its delimiter, enter the number of data records per part and split. Check the part counts before downloading.

Before you use the result

One file up to 2 MiB, 10,000 data rows and 100 uniquely named columns. Maximum 250 parts and 8 Mi UTF-16 code units of output. Formula-like values are preserved for import.

Try an example

Split five orders into batches of two to get three files with 2, 2 and 1 orders. Each file starts with the order columns.

How it works

Quoted line breaks stay inside the record. The header is repeated before each batch, and input order and text values are preserved in comma-separated output.

Frequently asked questions

Make import batches with a fixed number of records and the original header in every CSV. Download one part or all parts as a ZIP.

How do I use Split CSV by Row Count?

Choose a UTF-8 CSV, select its delimiter, enter the number of data records per part and split. Check the part counts before downloading.

Does this tool upload my data?

Inputs and files are processed in your browser. Page-view analytics do not contain your tool input.

What should I check before using the result?

One file up to 2 MiB, 10,000 data rows and 100 uniquely named columns. Maximum 250 parts and 8 Mi UTF-16 code units of output. Formula-like values are preserved for import.