CSV Column Extractor
Pick the columns you want out of a CSV and get them back as clean CSV or a plain one-per-line list.
Drop a .csv or .tsv file here, or click to browse
How it works
Paste your CSV — or drop a .csv/.tsv file — and every column in the
header row becomes a checkbox. Tick the columns you want to keep and the extracted data
appears instantly, in the original column order. The parser follows RFC 4180, so quoted
fields containing commas, line breaks and escaped "" quotes survive intact, and
the input delimiter (comma, semicolon, tab or pipe) is auto-detected. Values that need
quoting are re-quoted on the way out, so the result is valid CSV you can open in Excel,
Numbers or Google Sheets.
Choose “Plain list” to flatten the selected columns into one value per line — handy for pulling a single column of emails or IDs out of an export. If your file has no header row, untick “First row is a header” and the columns are listed as Column 1, Column 2, and so on. Everything runs in your browser with JavaScript: the file is never uploaded, stored or logged, so it is safe for exports containing customer data.
Frequently asked questions
How do I extract specific columns from a CSV file?
Paste your CSV or drop the file in — every column in the header row turns into a checkbox. Tick the columns you want to keep and the extracted data appears instantly in the original column order, ready to copy or download as a .csv file. Unticking columns is the same thing as deleting them, so the tool doubles as a column remover.
Can I pull a single column out as a plain list?
Yes. Select just that one column and switch the output format to "Plain list (one value per line)". You get every value on its own line with no header and no delimiters — ideal for pasting a column of emails, IDs or SKUs into another app. If you select several columns in list mode, their values are flattened row by row.
Does it handle semicolons, tabs and quoted fields with commas?
It does. The input delimiter is auto-detected (comma, semicolon, tab or pipe) and you can override it, and the parser follows RFC 4180, so quoted fields containing commas, line breaks or escaped double quotes stay intact. Values that need quoting are re-quoted on output, and you can choose a different delimiter for the result. If your file has no header row, untick "First row is a header" and the columns are listed as Column 1, Column 2, and so on.