Free tool
Extract a column from delimited text
Paste a CSV or any text with separated fields and keep just the column you need. No need to open a spreadsheet.
Characters: 0 · Lines: 0
Characters: 0 · Lines: 0
Everything is processed in your browser. What you type is not sent to any server or stored.
How it works and what it does with your text
It's a small, straightforward utility: you paste, choose options and copy the result.
It runs in your browser
The text is transformed by this page's code, on your device. No sign-up or installation needed.
We don't store what you type
We don't send your text to any server or store it. You can check this in the Network tab of your browser's developer tools.
Free and unlimited
Use it as often as you like. It works the same on mobile and on desktop.
Tips to get the most out of it
Data exported from a website or a CRM
If you have a CSV with lots of columns and only need the emails or the URLs, paste the content and pull out that column without opening Excel.
Fields with commas inside
With “Respect quoted fields” an address like "12 High Street, Flat 5" counts as a single field, just as a spreadsheet treats it.
Last column
Use the number -1 for the last column when the rows have a variable number of fields.
Open it in your spreadsheet afterwards
Copy the result and paste it into a column of your spreadsheet, or chain it with the sort and remove duplicates tools.
Frequently asked questions
How do I extract a column from a CSV?
Paste the CSV, choose the delimiter (comma, semicolon...) and type the column number. The result has one line per row.
Which delimiter should I use for a CSV saved from Excel?
CSV files saved from Excel with Spanish or other European regional settings usually use a semicolon as the separator, not a comma. If the result looks wrong, try the other one.
Does it work with text copied straight from a spreadsheet?
Yes. When you copy cells from Excel or Google Sheets the separator is a tab: choose “Tab”.
What if a row has fewer columns?
That row doesn't have the field. By default it gives an empty line; tick “Skip” to leave it out. The summary tells you how many rows were missing it.
Related tools
Merge text line by line
Combine several lists row by row: line 1 with line 1, line 2 with line 2, and so on.
Remove and add line breaks
Join the lines of a text, or split a text into lines by characters, words or sentences.
Remove duplicate lines
Remove the repeated lines from a list, or keep only the repeated or the unique ones.
All free tools
Passwords, texts, lists, codes and more.
Do you manage lists, texts or keywords at scale?
We help with SEO strategy and with custom tools that save you hours of manual work. Tell us what you do today.