Free tool
Extract a column from CSV
Extract a column from CSV (or tab-separated) text by its number. Values in quotes that contain commas stay in one piece.
The example is loaded. Paste your own list to replace it.
→ 2 lines
Columns are separated by
Column number
Drop the first row (headings)
Your text
Result
What it does
Keep one column of CSV or tab-separated rows.
Settings you can change
- Columns are separated by: Comma ,, Tab, Semicolon ;, Pipe |, Other (type it)
- Other separator
- Column number
- Drop the first row (headings)
When to use it
You downloaded a CSV with ten columns and only need the email column for another tool.
Example: extract column from CSV
Settings used: Column number: 2; Drop the first row (headings): on.
Input
Result
Tips
- Column 1 is the first one on the left.
- To keep several columns, use Reorder or remove columns.
Often used with
Keep the columns you list, in that order (for example 3, 1, 2).
Turn CSV into tab-separated text (for pasting into a spreadsheet), or the other way round.
Turn rows into JSON objects, using the first row as the names.
Your text stays on this computer
Got your list from a web page?
HeyScraper turns the page you’re on into a spreadsheet, so you can skip the copying and pasting. Free: 500 pages a month.
Get HeyScraper