Runs locally in your browser

Extract a Column from Delimited Text

Select a 1-based column from tab-, comma-, pipe-, semicolon-, space-, or custom-delimited rows and output it as a list.

Input → Result

Pull one field from every pasted row without a spreadsheet formula.

Delimited rows0 lines

Options

Input delimiter Custom delimiter Column number (starts at 1) Trim surrounding spaces Remove empty lines

Extracted column0 items

About this tool

Extract a Column from Delimited Text

Sometimes only one field is needed from a pasted table, log excerpt, or simple export. Column extraction avoids opening a spreadsheet or writing a temporary formula.

Rows are separated by new lines and fields are split with the selected literal delimiter. The first field is column 1.

FAQ

Frequently asked questions

Does it support quoted CSV fields?+

No. It splits on every literal delimiter. Use a real CSV parser when fields can contain quoted commas or new lines.

What happens when a row has fewer columns?+

That row produces an empty value, which is removed when Remove empty lines is enabled.

Related tools

Popular list tools

Browse all tools →

Merge Two Lists Online Combine two lists with append, interleave, union, or overlap modes. Split Text into a List Turn delimited text into a clean line-by-line list. Convert List to Comma-Separated Text Join list lines using commas or another delimiter. Comma-Separated Text to List Turn comma-separated values into one item per line.