TextArray
100% local

Extract column

Pull the columns you need out of CSV, TSV or any delimited text.

Input
Output
Related tools
Change CSV delimiterDeveloper toolsCSV ⇄ JSON converterDeveloper toolsSplit textText manipulationList to CSV converterLists & combinations
Extract column
Paste a CSV, TSV or any delimited text and pull out just the columns you need. Give the tool a column number and it returns that field from every row, one value per line. Use it to lift the email column out of a CRM export, pull order IDs from a report, turn a wide spreadsheet paste into a plain list, or cut a twenty-column file down to the two columns that matter.
Columns are numbered from 1, and you can ask for several at once. Type 3 for a single column, 1,3,5 for a selection, or 2-4 for a range. The order you type is the order you get, so 3,1 swaps two columns and repeating a number repeats the value. Pick the delimiter your data uses — comma, tab, semicolon, space or pipe — or type your own, where \t stands for a tab.
Quoted CSV fields are read properly: a field wrapped in double quotes may contain the delimiter, escaped quotes written as "", and even line breaks, and it still counts as one column. Switch that off to split strictly on the delimiter instead. Leave the output delimiter empty to reuse the input one, or set it to a tab to paste the result straight back into a spreadsheet. Trimming drops the spaces around each value, and rows shorter than the column you asked for either give an empty value or drop out entirely.
Everything runs in your browser, so the file you paste is never uploaded and customer exports or internal reports stay on your own machine. The tally under the output counts the rows in and out and flags any row that was missing a column.
FAQ
Are columns numbered from 0 or from 1?
From 1. The first column is 1, so for a file like name,email,city you would type 2 to get the email column.
Can I extract more than one column at a time?
Yes. Type 1,3,5 for a selection or 2-4 for a range, and combine them as 1,3-5. The result keeps the order you typed, so 3,1 puts column 3 before column 1.
What happens to rows that are shorter than the column I asked for?
By default the missing value comes out empty, keeping one output line per input row. Turn on "Skip rows without the column" to drop those rows instead. Either way the tally shows how many rows were incomplete.
Does it understand quoted fields that contain commas?
Yes. With "Read quoted CSV fields" on, a field in double quotes keeps its commas, its doubled "" quotes and any line breaks inside it, and still counts as a single column. Turn the option off if your data uses quotes as ordinary characters.
Is my text uploaded anywhere?
No. The extraction runs entirely in your browser and your text never leaves your device.