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.

1
Pick a column

→ 2 lines

Columns are separated by

Column number

Drop the first row (headings)

Your text

3 lines

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.

All free tools

Your text stays on this computer
The list editor works on your computer. The text you paste or open is not uploaded or stored by HeyScraper, and closing the page clears it. Saved recipes are kept in this browser only.

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