CSV column selector
This tool pulls the columns you need out of a CSV file, or drops the ones you do not. It is useful for trimming exports before sharing them or for loading only certain fields into another system.
- Runs in your browser
- Free, no account needed
- Copy or download the result
Result
Example
name,email,role Ada,[email protected],Editor Lin,[email protected],Analyst
name,email Ada,[email protected] Lin,[email protected]
How to use the csv column selector
- Paste CSV with a header row into the CSV with a header box.
- Set Input separator, then list names in Column names, comma-separated.
- Under Action, choose Keep in this order or Remove these columns.
- Press Run, then Copy result or Download.
How it works
Keep in this order outputs only the listed columns, in the order you typed them, so it can also reorder columns.
Remove these columns drops the listed columns and keeps the rest in their original order.
Names must match the header exactly, including case. Quote a name that contains a comma.
At least one column must remain. An empty list, an unknown name or a repeated name stops with an error.
Every row is kept, and the output uses the same separator as the input.
Everything runs in your browser. Your input is not uploaded or stored.
Questions and answers
How do I delete a column from a CSV file?
Type the column name in Column names, set Action to Remove these columns, and press Run. Separate several names with commas.
Can I reorder CSV columns?
Yes. Choose Keep in this order and list every column you want in the new order.
What if a column name has a comma?
Wrap that name in double quotes in the list, for example name,"City, State".
Is my file uploaded?
No. Columns are selected right in the browser tab, and your file is not sent anywhere.