CSV Column Extractor

Extract selected CSV columns.

FreeNo accountOn your device

Runs in your browser. How to verify

Loading tool…

About this tool

Paste CSV with a header row, say which column you want by name or by number, and get its values one per line. Leave the field empty to get the first column. Nothing is uploaded.

How to use

1
Step 1
Paste your CSV, with the column names on the first row.
2
Step 2
Enter a column name such as email, or a position such as 2.
3
Step 3
Press Process and copy the values.

How it works

The CSV is parsed with Papa Parse using the first row as headers. The column is matched by exact header, then by header ignoring case, then, if you typed a number, by 1-based position. Empty cells are skipped. An unknown column gives an error that lists the available headers.

Worked example

Extract the email column

Input
id,name,email 1,Ada,a@x.com 2,Lin,l@x.com Column: email
Output
a@x.com l@x.com
Walkthrough
The email header is matched and its two values are printed one per line.

Limitations

  • The first row must be a header row.
  • Empty cells are dropped, so the output may have fewer lines than the CSV has rows.
  • Only one column at a time.

Questions

Can I pick a column by number?
Yes. Type 2 for the second column. A header named exactly 2 wins over position 2.
Is the column name case sensitive?
No, email and Email both match.
What if I leave the field blank?
The first column is returned.
What does an error mean?
The column was not found; the message lists the headers that exist.

Features

  • Name or number
  • Case-insensitive
  • Quoted fields handled
  • Runs in your browser

Related resources

Guides and videos from around the web—opens on YouTube or the publisher’s site.

  • PDF, What is it FOR?

    Computerphile

    File tools often sit next to document packet workflows.

    Watch on YouTube
  • Reduce image size with srcset

    Chrome for Developers

    Image files dominate many zip and convert jobs.

    Watch on YouTube
  • Blob

    MDN

    How browsers represent file bytes in local tools.

  • Compression Streams API

    MDN

    Modern browser compression primitives related to zip tools.