Text Column Splitter

The text column splitter pulls out the columns you need from delimited text and puts them in the order you want — like the Unix cut command, in your browser. Split on commas, tabs, pipes, spaces or a custom pattern, choose columns by number or range, and join them with any separator. Quoted CSV values are handled correctly. Paste text or drop files; nothing is uploaded.

Column selection

You enterKeeps
3,1Column 3, then column 1
2-4Columns 2, 3 and 4
2-Column 2 to the last
4-2Columns 4, 3, 2
(blank)All columns

When to use it

  1. Pull email addresses out of a CSV export.
  2. Reorder columns before pasting into a spreadsheet.
  3. Extract fields from log lines or command output.
  4. Turn a CSV into tab-separated text.

How to Use

  1. Paste delimited lines or drop files.
  2. Choose the delimiter.
  3. Enter the columns to keep, in order.
  4. Choose the output separator and copy the result.

Features

  1. Comma, tab, semicolon, pipe, space, whitespace or regex
  2. Quote-aware CSV splitting
  3. Column numbers and ranges in any order
  4. Skip header with numbered column names
  5. Trim values
  6. Ragged-line warning
  7. 100% client-side

FAQs

How do I extract one column from a CSV?

Choose Comma, enter the column number in 'Columns to keep' and copy the result.

How do I reorder columns?

List them in the new order, for example 3,1,2.

Does it handle commas inside quotes?

Yes. Comma, tab, semicolon and pipe are split like a spreadsheet would, respecting quotes.

Can I split on multiple spaces?

Yes. Choose 'Any whitespace', or use a custom regular expression.

Is my data uploaded?

No. It's processed in your browser.

Technical Details

Each line is split into fields on the chosen delimiter. Comma, tab, semicolon and pipe use a quote-aware CSV parser, so a quoted value such as "Smith, John" stays in one field and escaped quotes are handled. Single space splits on every space, 'any whitespace' treats runs of spaces and tabs as one separator (useful for command-line output), and a custom delimiter can be literal text or a regular expression. The columns to keep are given as 1-based numbers and ranges in the order you want them — '3,1' swaps and drops, '2-4' takes a range, '2-' runs to the last column, and '4-2' reverses. Leaving it blank keeps every column. Lines with fewer fields get empty values rather than shifting columns, and the tool says when lines are ragged. Values can be trimmed, the header line can be skipped (its names are shown as numbered chips to help you pick), and the output is joined with any separator, where \t means tab.

Text Utilities

Text Utilities

  • Hidden Character Detector
  • Remove Invisible Characters
  • Unicode Tools
  • HTML to Text
  • Data Extractor
  • PII Redactor
  • Arabic Script Formatter
  • Transliteration Tool