Text Column Splitter

Split each line of text by whitespace, comma, tab, semicolon, pipe, colon or your own delimiter, keep chosen columns and output TSV, CSV, JSON arrays or an aligned table.

Use the tool

Why this tool exists

Command output, logs and copied tables are full of columns that line up for the eye but not for tools. Pulling out the third and fifth field normally needs awk or cut, and quoting rules make CSV exports awkward to get right by hand.

Paste the text and pick how it is separated. Whitespace mode treats any run of spaces or tabs as one separator, which suits aligned command output. Choose the columns to keep, by number or range such as 1,3 or 2-4, and the output format. The padded table is easy to read, TSV pastes into a spreadsheet, CSV quotes values with commas and JSON arrays suit scripts. The split is simple: quoted fields containing the delimiter are not recognised.

How to use it

  1. Paste your lines of text.
  2. Choose the delimiter, or enter a custom one, and the columns to keep.
  3. Choose the output format and copy the result.

Frequently asked questions

How do I choose columns?

Enter numbers starting from 1, separated by commas, and ranges with a hyphen, for example 1,3,5-7. Leave the box empty to keep all columns. Missing columns come out empty.

Does it understand quoted CSV fields?

No. It splits on every delimiter, even inside quotes. For real CSV with quoted commas, use a CSV tool that follows the quoting rules.

What does whitespace mode do?

Any run of spaces or tabs counts as one separator, and leading and trailing spaces are ignored. It works well for aligned output from commands such as ls or ps.

How is the CSV output quoted?

A value is wrapped in double quotes when it contains a comma, a quote or a line break, and inner quotes are doubled.