How to Extract a Column from a CSV

Pull one or more columns out of a CSV in any order, and download a clean file with just those columns. No upload, no sign-up, free.

Updated 4 min read By CodingEagles
Free tool Extract Columns from CSV Pick and reorder the columns you want out of a CSV. Open tool

A wide export often carries far more than you need. You want the email column for a mailing list, or just the name and total from a report with twenty fields. Deleting the other columns in a spreadsheet works, but it is fiddly and easy to remove the wrong one. Extracting the columns you want is cleaner.

The short version: paste a CSV or drop a file, tick the columns to keep, arrange them, and download. The extract column tool runs on your device, so nothing is uploaded.

Keeping columns beats deleting them

When you only need a few columns out of many, it is tempting to delete the rest. The problem is that deleting is destructive and error-prone: one stray removal and a column you needed is gone, and you have to start over from the original.

Choosing what to keep flips that around. You start from nothing and add only the columns you want, so the output contains exactly those and nothing else. The source file is never touched, so there is no way to lose data you meant to keep.

Reordering comes free

Extraction is not only about removing columns. Because you build the output column by column, you also decide their order. If a downstream tool expects the ID first and your file has it third, put it first as you pick it. The same step that trims the file also arranges it.

How to extract columns

Step 1: Add the CSV

Paste CSV text into the tool or drop in a .csv file. If the first row holds column names, the columns are listed by name; otherwise they are listed by position.

Step 2: Pick and order the columns

Tick the columns you want. Use the controls to move them up or down into the order you need in the result. The preview updates as you go.

Step 3: Copy or download

Copy the trimmed CSV to paste elsewhere, or download it as a file with only your chosen columns.

If you need fewer rows rather than fewer columns, splitting the CSV breaks it into smaller files, by row count or by a column value. And if the whole table is in the wrong orientation, transposing it swaps rows and columns so the data reads the other way.

Frequently asked questions

Can I reorder columns, not just remove them?
Yes. You choose both which columns to keep and the order they appear in the output, so you can move an email column to the front or keep only a name and a total, without editing the source file.
What if my CSV has no header row?
Columns are then referred to by their position, so you can still pick the first, third and fourth by their slot. With a header row present, columns are listed by name, which is easier to recognise.
Does extracting columns change the row order?
No. Extracting only changes which columns appear and in what order. Every row stays where it was, so the output lines up one-to-one with the input.
Is my file uploaded?
No. The CSV is read and trimmed on your own device. Nothing is uploaded, nothing is stored, and the data never leaves your browser.

Ready to try it?

Pick and reorder the columns you want out of a CSV. Free, in-browser, and 100% private — your data never leaves your device.

Open the Extract Columns from CSV