CSV Column Extractor
Paste CSV and pick the columns you want by header name or position. Keep and reorder them, or drop the ones you do not need. Quoted fields with commas are parsed and re-quoted correctly.
How to extract CSV columns
- Paste your CSV and say whether the first row is a header.
- List the columns by name or 1-based number, in the order you want.
- Choose keep or drop, then copy the resulting CSV.
Examples
Keep and reorder by name
id,name,email\n1,Ada,a@x.io
name,id\r\nAda,1
Keep columns 1 and 3
a,b,c\n1,2,3
a,c\r\n1,3
Frequently asked questions
Can I select columns by name or only by number?
Both. When the first row is a header you can list column names, and you can always use 1-based positions. Mixing names and numbers in one list works too.
Will it keep the order I list the columns in?
Yes, in keep mode the output columns follow the exact order you provide, so you can reorder a CSV by listing the columns in the new order.
Does it handle commas and quotes inside fields?
Yes. The parser follows RFC 4180, so quoted fields containing commas, quotes or line breaks are read correctly and re-quoted in the output.
What does drop mode do?
Drop removes the columns you list and keeps the rest in their original order, which is handy for stripping a few sensitive or unused columns.
Is my CSV uploaded?
No. Parsing and column selection run entirely in your browser, so your data never leaves your device.
Related tools
CSV to JSON
Convert CSV to JSON online. Turn spreadsheet rows into clean JSON objects or arrays, with smart number and boolean typing. Free tier plus API.
JSON to CSV
Convert JSON to CSV online. Paste an array of objects and get clean, spreadsheet-ready CSV with the right headers. Runs in your browser.
List Comparison
Compare two lists online to find items only in A, only in B, in both, or the combined union. Optional case-insensitive matching. Free and private.
.env to JSON
Convert a .env file to JSON, or JSON back to .env. Parses KEY=value lines, comments, quotes and export. Runs entirely in your browser.
ASCII Table
Full ASCII table for all 128 codes with decimal, hex, octal and binary values, character names and descriptions. Search by code, hex or character.
Aspect Ratio Box Generator
Generate CSS for a responsive aspect-ratio container. Use the modern aspect-ratio property or the padding-top fallback, then copy the ready code.