Remove or Reorder CSV Columns
Keep, drop or reorder CSV columns in your browser. Select by heading, position or range — and repeat a column if you need to.
Related tools
All Data tools →This tool runs entirely in your browser. Nothing you enter is sent to our servers, so there is nothing for us to store or see.
About the Remove or Reorder CSV Columns
Paste CSV and keep only the columns you want, drop the ones you do not, or put them in a different order. Everything runs inside this page on your own device, so a file containing personal data is never uploaded — which matters here in particular, because stripping columns is often exactly how a file gets made safe to share.
Columns can be named however is convenient: by heading, by position counting from 1, or as a range like 1-4. A descending range such as 4-1 reverses that block, which is the quickest way to flip a column order. You can also name the same column twice — 1,1,2 duplicates the first column — which sounds odd until you need a copy of an ID beside itself for a lookup.
In keep mode the output follows the order you typed, so this is a reordering tool as much as a filtering one. In drop mode the surviving columns stay in their original order, because the intent there is to remove something rather than to rearrange everything else. Row order is never touched in either mode, and the header row travels with its columns.
How to use the Remove or Reorder CSV Columns
-
Paste your CSV
Paste into the left pane, or drop a .csv file onto it — dropping reads the file locally and never uploads it.
-
Choose keep or drop
Keep follows the order you type, so it reorders as well as filters. Drop removes what you name and leaves the rest in their original order.
-
Name the columns
By heading, by position counting from 1, or as a range like 1-4. Mix them freely, and use a descending range to reverse a block.
-
Copy or download
The result appears on the right as you type, with the surviving columns named underneath. Copy it, or download it as a .csv file.
Frequently asked questions
Is my data uploaded anywhere?
No. The whole operation runs inside your browser and nothing is sent to a server. That matters more for this tool than most, because removing columns is often precisely how a file is made safe to share in the first place.
How do I reorder columns rather than remove them?
Use keep mode and name every column in the order you want them. The output follows the order you typed, so "3,1,2" keeps all three columns and rearranges them. A descending range like 4-1 reverses that whole block in one go.
Can I name columns by heading instead of by number?
Yes, and matching ignores case and surrounding spaces, so "Email" finds a column headed " email ". You can mix headings, positions and ranges in one selection — "id,3-5,notes" is valid.
Why does it let me name the same column twice?
Because it is occasionally what you want: "1,1,2" produces a copy of the first column beside itself, which is useful when a downstream lookup or pivot expects a key in two places. Silently removing the repeat would take away a capability rather than prevent a mistake.
What happens to rows that have fewer columns than the header?
A missing cell becomes an empty one, so every output row has the same width as the selection. Real exports are ragged because trailing empty fields get dropped, and padding is what keeps the result aligned with its header.