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

  1. Paste your CSV

    Paste or type it into the box, or press Try an example.

  2. List the columns

    Use names or numbers, such as name, 3, 5-7.

  3. 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.

Related tools