Input
1,Alice,London 2,Bob,Paris
Extract & convert
Extract a Column from Text
Select one column from line-based delimited data. Choose a comma, tab, pipe, semicolon, or custom delimiter and enter a one-based column number. Rows without that column can be skipped or returned empty.
Focused workspace
Extract Column
0 characters · 0 words
0 characters · 0 words
Before and after
Extract Column Example
Output
Alice Bob
Three steps
How to use this tool
- Paste the delimited rows.
- Choose the delimiter and one-based column number.
- Extract and copy the selected values.
Useful workflows
Common use cases
- Pull a field from simple CSV and TSV exports.
- Extract hostnames, IDs, or labels from logs.
- Prepare one column for deduplication or sorting.
How it works
Fast text processing without an upload
The selected operations are applied in order by JavaScript running on this page. The input is not sent to the Go server and is not written to SQLite. The server provides the page, SEO content, and blog system; the browser performs the text transformation.
Questions
Extract Column FAQ
Does this fully parse quoted CSV?
It handles simple delimited text. Complex quoted CSV should use a dedicated CSV parser.
Is the first column number 0 or 1?
Column numbering starts at 1.
Can I use a multi-character delimiter?
Yes. Select Custom and enter it.