Extract a column from CSV

How it works

Parse comma-separated CSV with quoted fields, select a 1-based column index and omit the first header row from the JSON values.

Input definitions

CSV including a header row: Plain text; maximum 200,000 characters.
Column number (1 = first): Enter the value in the labeled unit.

A worked example

CSV including a header row: name,city Ada,London Lin,Paris
Column number (1 = first): 2

[ "London", "Paris" ]

Assumptions & limits

Comma-delimited CSV, one header row, uniform row width and 1-based column number. Up to 2,000 data rows. Formula escaping may prefix spreadsheet-dangerous values in the CSV download.

Sources & review

Maintained by AnsRio. Methods and examples use automated checks; this does not imply independent professional certification.

https://www.papaparse.com/docs ↗

Method updated 2026-10-17. Content checked against the stated method and examples. Our verification approach.

Common questions

Does this tool execute the code or data I paste?

Inputs are treated as data under the stated parser or transformation. Output is displayed as text. Parsing or formatting does not establish that the content is safe to execute elsewhere.

How does the Extract a column from CSV tool work?

Parse comma-separated CSV with quoted fields, select a 1-based column index and omit the first header row from the JSON values.

What are the assumptions and limits of Extract a column from CSV?

Comma-delimited CSV, one header row, uniform row width and 1-based column number. Up to 2,000 data rows. Formula escaping may prefix spreadsheet-dangerous values in the CSV download.