CSV Splitter

How this reads your output

The file is parsed, then the data rows are cut into parts of a hundred with the header row repeated at the top of each. Repeating the header is the detail that matters and the one manual splitting always misses: without it, the first data row of each part gets treated as column names by whatever imports it, and one record silently disappears per part.

What the results mean

Parts

How many chunks the data divides into. Each is a complete, valid CSV rather than a fragment.

Last part

The remainder, which is usually shorter. Worth checking it is not a single stray row caused by a trailing blank line.

Problems found

Issues in the source file such as ragged rows. Splitting a malformed file produces several malformed files, so fix these first.

Common problems and fixes

An import tool rejects one of the parts

Check whether the part contains a row split across lines. A quoted field may legitimately contain newlines, and this splitter counts parsed rows rather than text lines, so that case is handled here. A naive split by line count is where that problem usually comes from.

I need a different number of rows per part

This one is fixed at a hundred, which suits most import limits and paste windows. For a different size, split with a spreadsheet by filtering on row number, or use a command-line tool, which handles arbitrary sizes and very large files far better than a browser can.

Frequently asked questions

More in Data

• CSV DeduplicatorRemove exact duplicate rows and flag the conflicting ones.
• CSV ViewerView a CSV as a table — and find the rows that do not line up.
• CSV to HTML TableConvert a CSV into accessible, escaped HTML table markup.