UtilityPilot.Find a tool

Data & Tables

Split CSV file

Split a CSV into smaller record batches for an import. Repeat the header in each part and download the numbered files individually.

Processed in your browserPrivacy details ↗

5 MiB per input · 50,000 records · 200 columns

Adjust your options

Spreadsheet-safe export can change formula-like cells by adding an apostrophe. Turning it off preserves raw values; use raw exports only in a trusted importer.

No sign-up. No upload.

A QUICK WALKTHROUGH

How to use this tool

  1. Load a CSV with the correct delimiter and header setting.
  2. Choose data records per part and whether to repeat the header.
  3. Split and download each part; the manifest lists each file’s record count.

How it works

Splitting happens after parsing, so quoted multiline fields stay together. The final file contains the remaining records, even when that is fewer than the selected batch size. Part names are sequential. The 100-part limit prevents accidental generation of thousands of downloads.

A practical example

Start with

Three data records; two records per part

What to expect

part-001.csv contains two data records; part-002.csv contains one. Repeated headers do not count toward the batch size.

Important considerations

A row-count limit is not a byte-size limit. Records can vary greatly in length. Inspect the resulting file sizes if an import has a strict megabyte cap.

5 MiB per input · 50,000 records · 200 columns. Input remains in page memory until you reset or leave. Copy and download actions are initiated by you. No tool input is sent to a processing service.

One more useful detail

Will a field with a line break be split?

No. A quoted newline remains inside its original CSV record.