Free CSV Column Extractor
Pull out just the columns you need from a CSV, in the order you list them — instantly, entirely in your browser.
How to extract columns from a CSV
-
1
Paste your CSV
Paste CSV data into the input box, with a header row if you have one.
-
2
Check which column is which
Click "Load columns" to see each column's number and name before deciding what to keep.
-
3
List the columns and extract
Type the column numbers you want, in order, then click "Extract →" to build the new CSV.
Example use cases
Building a mailing list
Pull just the name and email columns out of a larger customer export.
Reordering columns for an import
Rearrange a CSV's columns to match the order another system expects for import.
Trimming a wide export
Cut an export down to the handful of columns actually needed for a report.
Frequently asked questions
What does "Load columns" do?
It parses the pasted CSV and lists the detected column names (or "Column 1", "Column 2", etc. when there's no header) below the input, so you can confirm which numbers to type into the columns box.
Can I reorder columns, not just remove some?
Yes. The output columns appear in the exact order you list them, so "3,1" puts the original third column first and the first column second.
Can I repeat a column?
Yes, listing the same column number twice includes it twice in the output.
Is my data uploaded anywhere?
No. Everything happens locally in your browser using JavaScript — nothing you paste is sent to a server.