CSV Column Remover
Remove unwanted columns from a CSV by name, position or range and keep everything else exactly as it is.
Processed locally in your browser/ Your data stays in your browser.
What is CSV Column Remover?
Sometimes it is easier to say what to throw away than what to keep: internal IDs, notes, tokens, personal data. This tool deletes the columns you list and leaves every other column and row untouched, in the original order.
Columns are identified by header name (case-insensitive), by 1-based position, or by ranges such as 2-4, in any combination. Removing every column is refused, and unknown names produce a clear error rather than a silent no-op.
How does it work?
- Paste the CSV or open a file.
- List the columns to delete, for example email,5 or 2-4.
- Check the preview table and the note that says how many columns were removed.
- Copy the result or download it as a new CSV.
Common use cases
- Stripping personal data such as emails or phone numbers before sharing a dataset.
- Removing helper or audit columns before importing into another system.
- Dropping empty trailing columns produced by a spreadsheet export.
- Making a public sample from an internal file.
Examples
Try this input in the tool above:
id,name,email,city,age 1,Alice Martin,alice@example.com,Paris,34 2,Bob Durand,bob@example.com,"Lyon, France",28 3,Chloé Petit,chloe@example.com,Nice,41 4,David Roux,david@example.com,Paris,19
id,name,city 1,Alice Martin,Paris 2,Bob Durand,"Lyon, France" 3,Chloé Petit,Nice 4,David Roux,Paris
Privacy
CSV Column Remover runs entirely in your browser. The text or files you provide are processed on your device and are not uploaded, logged or stored on our servers.
Limitations
Removing columns is done on the text you provided; the original file is not modified. If you list the same column twice it is removed once.
Frequently asked questions
Can I remove a range of columns?
Yes. Write 2-4 to remove the second to fourth columns, or 3- to remove everything from the third column onward.
What if the file has no header row?
Untick "First row is a header" and refer to columns by number only.
Is the data sent anywhere?
No. Parsing and removal happen entirely in your browser, which makes the tool suitable for files with sensitive fields.
Related tools
CSV Column Extractor
Keep only the columns you need from a CSV, chosen by header name, position or range, in the order you list them.
JSON & Data
CSV Filter
Keep only the CSV rows that match a condition on one column, or on any column at once.
JSON & Data
CSV Deduplicator
Find and remove duplicate rows in a CSV, comparing whole rows or only the columns you choose.
JSON & Data
CSV Viewer
Paste CSV text or open a .csv file and inspect it as a table, with row and column counts and the detected delimiter.
JSON & Data
CSV Formatter
Re-serialize messy CSV into a consistent file: same quoting rules, trimmed cells, one delimiter and one line-ending style.
JSON & Data
CSV Sorter
Order the rows of a CSV by one column, comparing values as text, natural text, numbers or dates.
JSON & Data
CSV Merger
Combine two CSV texts into one, either by stacking their rows or by placing them next to each other.
JSON & Data