Skip to content
NMSnabbit.

CSV Column Extractor

Extract one column from CSV by name or number, quotes handled.

Developer Tools Runs in your browser

What is a CSV extractor?

Name a header (case doesn’t matter) or give a 1-based column number and this pulls that single column out of your CSV, one value per line. Quoted fields parse properly, so “Smith, John” stays whole and doubled quotes unescape. A delimiter switch covers semicolon-separated European exports and tab-separated dumps without any reformatting on your side.

How to use the CSV Extractor

  1. 1 Paste the CSV, TSV or semicolon-separated data.
  2. 2 Identify the column by header name or 1-based position.
  3. 3 Switch the delimiter control if the data is not comma-separated.
  4. 4 Copy the single-column output.

What you can use it for

  • Pulling the email column out of a contacts export.
  • Extracting one field from a large CSV for a quick list.
  • Turning a spreadsheet column into newline-separated text.
  • Isolating IDs from a data dump for a lookup.

Frequently asked questions

How do I pick the column I want?
Type its header text, matched case-insensitively against the first row, or a 1-based number. With a header match, the header cell itself is left out of the output.
Will commas inside quoted values break the parsing?
No. “Smith, John” is treated as one field, and a doubled quote inside quotes is read as a literal quote character, per standard CSV rules.
My file uses semicolons. Can it cope?
Yes. Set the delimiter control to semicolon, or to tab for TSV exports, and the same column extraction applies without editing the data first.

Related tools

JSON Data Extractor Extract values from JSON by dot/bracket path, or list all leaves. Number Extractor Extract all numbers from text — integers, decimals and thousands. Sort Lines Sort lines alphabetically or by length, ascending or descending, with optional de-duplication.

More Developer Tools

More tools like this:

All Developer Tools