CSV Column Extractor
File
A focused cut from a wide CSV without opening a spreadsheet. Parses RFC 4180–style CSV (quoted fields with embedded delimiters and escaped quotes), with selectable tab/semicolon/pipe delimiters. Pick columns by header name or index, optionally dedupe and sort, and emit them in the format that matches the next step — newline-per-row for piping into another tool, or a `(...)` IN-clause to drop into a SQL editor.
ana@x.com bae@y.com cai@z.com
Parsing is RFC 4180 — quoted fields can contain delimiters and newlines, doubled quotes decode to a single quote.
How to use
- Paste your CSV/TSV and confirm the header toggle matches your data.
- Click the column chips to choose which to keep — order in the output follows the column order.
- Pick the output format (plain, CSV, quoted list, SQL IN) and copy.
Frequently asked questions
- Does it handle quoted fields and escaped quotes?
- Yes. Fields wrapped in double quotes are unquoted, embedded delimiters and newlines are preserved, and `""` is treated as a literal double quote per RFC 4180.
- Why is there a SQL IN-clause option?
- When you've got a list of IDs in a CSV and you need to write `WHERE id IN (...)`, this saves you the manual quoting. The format escapes single quotes too.
Related tools
Image → PDF Converter
Combine multiple JPG / PNG images into a single PDF with adjustable page size, orientation, and fit.
ZIP Inspector
Drop a ZIP and see every file inside — sizes, contents, and per-file download — without unpacking it locally.
File Splitter
Split a large file into smaller chunks to bypass attachment or upload size limits.
Text Encoding Converter
Open text files in legacy encodings (EUC-KR, Shift_JIS, Windows-1252…) as readable UTF-8.
File Hash (Checksum)
Compute SHA-1, SHA-256, and SHA-512 checksums of any file.
CSV ↔ JSON Converter
Convert CSV to JSON and JSON back to CSV, with a delimiter option.