CSV Column Extractor
Extract selected CSV columns.
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
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?
Is the column name case sensitive?
What if I leave the field blank?
What does an error mean?
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 YouTubeReduce 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.