Remove CSV Columns
Take unwanted columns out of a CSV by naming them. Use headers, letters, numbers or ranges, and keep everything else exactly as it was, all in your browser.
- Free, no sign-up
- Files stay on your device
- Names, letters or ranges
- Separator preserved
- Runs on your device. Files are never uploaded.
- Free and unlimited. No sign-up, no watermark.
Remove CSV columns in three steps
No account, no email, no waiting for an upload.
- STEP 01
Add your CSV
Drop your delimited text file here.
- STEP 02
List the columns to delete
Type header names, letters such as F, numbers such as 6, or ranges such as B-D, separated by commas.
- STEP 03
Download the slimmer file
You will see how many columns were removed. All other data is untouched.
What Remove CSV columns does, and what it doesn't
We'd rather tell you up front than surprise you after the download.
What you get
- Flexible referencesUse the header text when you have one. Without headers, use letters or numbers.
- RangesB-E removes four neighbouring columns in one go.
- Guarded against mistakesIf you try to remove every column, or name one that does not exist, you get a clear message listing the real columns.
- Format keptSeparator, quoting style, BOM and line endings stay the same.
- Private by designNothing is uploaded.
Good to know
- CSV files onlyFor Excel workbooks use Extract selected Excel columns, which keeps the columns you list.
- Case-insensitive names, exact spellingHeader names must match fully. A typo gives an error rather than a guess.
- Not for hiding dataRemoving columns here is permanent in the new file. Keep your original for reference.
Your spreadsheets never leave your device
The tool runs inside your browser instead of on our servers, so there is nothing to upload, store or delete afterwards.
Typical online tool upload
Your file travels over the internet, sits on someone else's computer for a while, and you wait for the upload and the download.
Mediaextractr no upload
The tool loads into your browser once, then works on your file locally. Nothing is sent, so nothing can leak.
When people use Remove CSV columns
Share a safer copy
Take out phone numbers, salaries or notes before sending.
Match an import template
Drop the extra columns a system does not accept.
Shrink a big export
Fewer columns mean a smaller, faster file.
Focus an analysis
Remove the noise before opening in a spreadsheet.
Mediaextractr vs typical upload tools
| MediaextractrPrivate | Typical upload tools | |
|---|---|---|
| Your file is uploaded | Never | Yes |
| Sign-up needed | No | Often, after a few files |
| Daily file limit | None | Often 1–2 free files |
| Watermark | Never | Sometimes |
| Wait for upload & download | No | Yes |
| Speed on very large files | Depends on your device | Depends on their servers |
Writing the column list
Separate items with commas. If a header itself contains a comma, wrap it in double quotes, like "Total, EUR". Headers are tried first, so a column actually titled B is found by its title before being treated as column B.
Remove or keep
This page is set to remove the columns you list. If you would rather list the few you want to keep, the Excel tool works the same way in the other direction and also accepts CSV files, so Extract selected Excel columns can do that job.
To clear completely empty columns without naming them, use Delete empty columns. To fix the names of the columns that remain, try Rename spreadsheet columns.
A privacy habit
Before sharing exported data, remove columns that identify people or hold internal notes. Because the tool runs locally, the original never travels anywhere while you do it.
Questions, answered
How do I delete a column from a CSV file?
Add the file, type the column name, letter or number, and download the result.
Is my CSV uploaded when columns are removed?
No. The edit is done in your browser, and the original never travels anywhere.
Can I remove several columns at once?
Yes, separate them with commas or use a range like B-D.
What if the header has a comma in it?
Put the name in double quotes.
Will it change my separator?
No. The separator, quotes and line endings are preserved.
Does it work on iPhone, Android and desktop?
Yes, in any modern browser. Small and medium CSVs are fine on a phone.