Data & CSV

Split a CSV column

Separate a cell into several columns using a literal separator.

Split a CSV column
Esc to restore

Your inputs

UTF-8 CSV/TSV stays on this device. First row contains unique headings; maximum 25 MB, 50,000 rows and 200 columns. Fully empty rows are ignored.

Up to 25 MB per file, 50,000 data rows, 200 columns and 2 million data cells. Fully blank rows and columns are ignored before row, column and cell limits are checked. Individual tools may have smaller result or chart limits.

Results update as you type. Larger files run when you press Update result.

Processed on your device

Your result

LOCAL & PRIVATE

Your result will appear here.

Your inputs stay in this browser. Nothing is uploaded or saved.

A clear answer. Here’s how.

Splits exact literal text, without regular expressions. Creates heading.1, heading.2 and so on. If there are more parts than requested, the final column contains the unsplit remainder; fewer parts are padded with empty cells. Generated headings must be unique and output cannot exceed 200 columns.

See a worked example

Worked example

A fixed demonstration, separate from the values you enter above.

Your CSV data
Name,Location
Ada,London|UK
Sam,Paris|France
Column separator
Comma
Column to split
Location
Literal separator inside each cell
|
Number of output parts
2
Original column
Replace original

Example result

Example result
NameLocation.1Location.2
AdaLondonUK
SamParisFrance

Keep going.

CSV dataset diffCSV rule validatorCSV calculated columnCSV rank and percentile