CSV Row Splitter

Split CSV data rows into bounded files, repeating the original header in every part.

Your CSV stays in this browser. No input is uploaded.

Comma-separated CSV: up to 200,000 characters, 200 unique nonempty headers and 10,000 data rows.

Every part includes the header. Split by parsed record count, not bytes; at most 100 files and two million combined output characters.

Preserve mode keeps cell strings. Protection adds apostrophes before formula-like cells, including negative numbers, and changes their values. Quoting and line endings are normalized.

Split a large CSV into smaller record batches

Paste a comma-separated CSV with a header row, enter Data rows per file, and choose Split rows. Each file contains at most that many data records plus a copy of the original header. Records retain their original order. Quoted line breaks inside a cell do not count as extra records.

Example: five records in batches of two

Load the example containing Ada, Lin, Kim, Sam and Jo. Leave the batch size at 2. The tool creates three files: part-001.csv has Ada and Lin, part-002.csv has Kim and Sam, and part-003.csv has Jo. All three begin with the same name/score header. Use Preview part to inspect a file, then download the individual part using its named link. Copy current preview copies only the selected part, not the entire set.

Rows are parsed, not counted by newline

CSV can quote cells containing commas, quotes and line breaks. The splitter uses parsed records to avoid breaking a multiline value into separate files. It does not split by byte size, a column value, date range or estimated spreadsheet row limit. If a destination imposes a byte limit, verify the downloaded file sizes separately.

Input must have unique nonempty headers and consistent row widths. Limits are 200,000 characters, 200 columns and 10,000 data rows. The batch size must be an integer from 1 to 10,000. At most 100 files and two million output characters combined are allowed. Repeated headers can increase total output size; choose larger batches if the limit is exceeded. A header-only input is rejected because there are no records to split.

Export behavior

Preserve mode retains cell strings, with normalized CSV quoting and line endings. Optional spreadsheet protection adds apostrophes before formula-like values, including negative numeric strings. That changes values, so use it deliberately. Downloads are created locally in this browser and do not change your source file. Editing input, batch size or export mode clears all previous part links.

Use CSV Row Filter before splitting to reduce the dataset. CSV Merger can combine compatible parts again. For a smaller selection spread across the source rather than contiguous batches, use CSV Random Sampler.