CSV Column Extractor
Paste CSV with a header row, toggle which columns to keep, set their order, and get a new CSV with only those columns. Everything runs in your browser.
About the CSV Column Extractor
The CSV Column Extractor reads CSV with a header row, shows each detected column as a toggle, and builds a new CSV containing only the columns you keep, in the order you set. It is useful for trimming exports down to the fields you need, reordering columns before an import, or removing sensitive fields before sharing a file. Everything runs in your browser, so your data is never uploaded or logged.
How it works
- Paste your CSV into the input area. The first row is treated as the header, and each column shows up as a toggle.
- Click a column to keep or drop it, and use the up and down arrows on a kept column to set its position in the output.
- Pick the delimiter that matches your file (comma, semicolon, tab, or pipe) if it is not a comma.
- Review the output, then click Copy or Download .csv to save the result.
Features
- Auto-detects columns from the header row and lists them as toggles.
- Choose which columns to keep and reorder them with up and down controls.
- Delimiter select for comma, semicolon, tab, and pipe files.
- Correct handling of quoted fields, escaped quotes, and values that contain the delimiter or line breaks.
- Copy to clipboard or download the filtered CSV with one click.
Frequently asked questions
Is my data uploaded anywhere?
No. The CSV is parsed and rebuilt entirely in your browser. Nothing is sent to a server or logged.
Does it need a header row?
Yes. The first row is used as the column names shown in the toggles. If a header cell is empty, it is labeled Column 1, Column 2, and so on.
Can I change the column order in the output?
Yes. Each column you keep shows a position number and up and down arrows. The output follows the order you set, not the original file order.
How are quotes and commas inside a field handled?
Quoted fields are parsed correctly, including escaped quotes written as two double quotes and delimiters or line breaks inside quotes. On output, any value that contains the delimiter, a quote, or a line break is re-quoted so the CSV stays valid.
Does the delimiter setting affect both input and output?
Yes. The selected delimiter is used to read the input and to write the output, so the result uses the same separator you chose.