CSV Column Extractor
Extract one or more CSV columns by header or index and export them as text lines, JSON, code arrays, or SQL values.
Extract spreadsheet columns into lists, arrays, or SQL values
Column extraction reads the header row when present and allows one or more fields to be selected. Multiple selected columns can be joined with tabs, commas, spaces, or pipes.
The extracted rows can be cleaned, deduplicated, sorted, and serialized without repeatedly copying data between separate tools.
CSV Column Extractor FAQ
Can I select a column when the CSV has no header?
Yes. Disable the header option and columns are labeled by their one-based positions.
Can multiple columns be extracted together?
Yes. Select multiple column checkboxes and choose the separator used between values from the same row.
Which output formats are available?
Text lines, JSON, JavaScript, Python, PHP, and SQL values are supported.
Continue working with your data
Convert CSV or TSV to JSON and JSON arrays to CSV using quoted-field parsing, header controls, type detection, table preview, and downloads.
Compare ListsCompare two lists and find values only in A, only in B, shared values, union, or symmetric difference with configurable matching rules.
Delimiter ConverterConvert lists between newline, comma, tab, pipe, semicolon, space, and custom delimiters with trimming, quotes, and deduplication.
SQL IN Clause GeneratorConvert pasted IDs, strings, numbers, or UUIDs into SQL IN or NOT IN clauses, escaped literals, or parameterized placeholders.