CSV Column Extractor
Keep only the columns you want, by name or number, in the order you want, and drop the rest.
Processed on your device. Files are not uploaded
How to pick columns from a CSV file
Paste your CSV
Paste or type it into the box, or press Try an example.
List the columns
Use names or numbers, such as name, 3, 5-7.
Copy or download
Save the smaller CSV.
Worked example
This is what CSV Column Extractor gives for its own sample values. Open the tool above and change anything to try your own.
CSV
name,team,city,age Ada,Platform,London,36 Linus,Kernel,Helsinki,54 Grace,Compilers,New York,85 Ada,Platform,London,36 Alan,Research,London,41
- Delimiter
- Detect automatically
- Columns to keep
- name, city
CSV with the chosen columns
name,city Ada,London Linus,Helsinki Grace,New York Ada,London Alan,London
About CSV Column Extractor
Keep only the columns you need, in the order you want. Columns can be named, numbered or given as a range, and the same column can be repeated.
FAQs
Are names case-sensitive?
No.
What if a name is wrong?
The error lists the columns the file really has.
Can I filter rows too?
Use CSV Filter.