CSV Column Extractor and Reorder
Open a CSV, untick the columns you do not want, move the rest up or down and give any of them a new name. Download the narrower table.
Drag a file here or choose one
Worked examples
Keep two columns in a new order
ID,Name,City,Spend 1,Ann,Leeds,120 2,Bob,York,80
Name,ID Ann,1 Bob,2
Only Name and ID were kept, with Name moved above ID.
Rename a column
ID,Spend 1,120
Customer number,Spend 1,120
ID was given the new name Customer number. The values did not change.
About CSV Column Extractor and Reorder
Exports from accounting, booking and customer systems often hold dozens of columns when you need a handful. This tool lists every column of your file with a tick to keep it, a box for a new name and buttons to move it up or down. The preview changes as you work, so you can see the narrower table take shape.
It is useful before importing into another system that wants specific columns in a set order with exact names. Renaming and reordering never change the rows, so the result has the same number of rows as the original. Columns are tracked by position, which means files with repeated or blank column names are handled without trouble.
How to use CSV Column Extractor and Reorder
- Paste your CSV or open a file.
- Untick the columns you do not want, or choose Keep none and tick the few you need.
- Use Up and Down to put the columns in the order you want, and type a new name where needed.
- Download the result or copy it.
Common uses
- Cutting a wide export down to the columns an import needs
- Putting columns in the order a template expects
- Renaming columns to match another system's headings
- Removing columns with personal details before sharing a file
Frequently asked questions
Can I use the same column twice?
No. Each column appears once. If you need a copy of a column, use the column calculator to make a new one from it.
What if two columns have the same name?
They are listed in the order they appear and can be told apart by position. You can give each one a different new name.
Does it change any values?
No. Only the choice, order and names of the columns change. Every value is kept exactly as it was.
How do I get the original order back?
Press Reset the order and names. All columns are ticked again, in their original order, with no new names.
Can it handle a file with no header row?
Yes. Untick First row is the header and the columns are called Column 1, Column 2 and so on. The result is written without a header row.