Column Picker
Extract a specific column from tab-separated or comma-separated rows. Enter column index or name — useful for pulling a single field from TSV exports or pasted spreadsheet data.
How to use the column picker
Paste delimited rows, pick the delimiter and column index (0-based). Toggle 'has header' to skip the first row.
Formula & explanation
Splits each line by the chosen delimiter. Missing cells emit empty strings.
Examples
Tab-separated rows of name/age/city → pick column 1 to extract just ages.
Frequently asked questions
- Why are columns numbered from 0?
- Column indexing starts at 0 (zero-based), so the first column is 0, the second is 1, and so on — consistent with most programming languages.
- How do I extract a column from a CSV file?
- Paste your CSV text, set the delimiter to Comma, enter the column number, and enable 'First row is header' if your CSV has a header row.
- What happens if a row has fewer columns than the one I selected?
- Rows with missing cells output an empty string for that position, so every input row still produces one output line.
- Can I extract from tab-separated (TSV) files?
- Yes — select Tab as the delimiter. TSV is common in spreadsheet exports and database dumps.
Related list tools tools
- Comma to Lines ConverterConvert between comma-separated values and one-item-per-line format. Handles quoted fields, trims whitespace, and removes duplicates. Paste CSV data, get a clean list — and back.
- List StatsGet statistics on any list: total count, unique count, min and max line length, average length, and the longest and shortest items. Useful for auditing data before further processing.
- List Set OperationsPerform set operations on two lists: union, intersection, difference, A-only, B-only, and symmetric difference. Paste two lists and choose the operation — results update instantly.
- List FilterKeep or remove lines matching a plain-text substring or regular expression. Useful for filtering log output, cleaning data, or extracting matching lines from large lists.
- List to JSON ArrayConvert a one-item-per-line list into a JSON array of strings and back again. Handles quoting and escaping automatically — useful for turning clipboard lists into API payloads.
- Prefix / Suffix WrapperWrap every line with a custom prefix and suffix. Useful for building SQL IN clauses ('value'), quoting shell arguments, wrapping HTML tags, or generating code from a list.