Column Extractor guide
Extract one numbered field from comma-, tab-, semicolon-, pipe-, or custom-delimited text.
What this tool does
The Column Extractor parses rows with a selected one-character delimiter and returns the requested one-based column. It supports quoted fields, delimiter characters inside quotes, doubled quotation marks, Windows or Unix line endings, and quoted fields that contain line breaks. Optional controls treat the first row as a header, trim surrounding whitespace, and skip empty extracted values.
When a row has fewer fields than the requested column, the tool excludes that row and reports it as missing. An empty field is different from a missing field: it can remain as a blank output line unless the skip-empty option is selected.
This is a practical delimited-text parser, not a complete spreadsheet importer. It accepts a single literal delimiter and double-quote escaping. It does not detect file encodings, repair malformed quoting, choose a delimiter automatically, interpret formulas, preserve cell styles, or evaluate spreadsheet data types. An unclosed quoted field produces an explicit error instead of a partial result.
How to use it
- Paste CSV, TSV, or another delimited text block.
- Choose the delimiter or enter one custom character.
- Enter the column number, starting with 1 for the first column.
- Choose header, trimming, and empty-value behavior.
- Select Extract column, review missing-row information, and copy or download the values.
For sensitive or important datasets, compare the first and last several results with the source. Different systems can use regional delimiters or unconventional escaping rules. For unstructured text where values sit between paired literal markers rather than numbered columns, use Extract Text Between Delimiters.
Benefits
- Supports five common delimiter choices
- Handles quoted delimiter characters and line breaks
- Distinguishes missing fields from empty values
- Can identify the selected header name
- Produces a simple one-value-per-line export
- Parses the data locally in the browser
Data safety and spreadsheet formulas
The exported values are plain text. If you later paste them into spreadsheet software, values beginning with =, +, -, or @ may be interpreted as formulas by that software. Review untrusted data and use the spreadsheet application's safe-import controls rather than opening it blindly.