About the CSV Column Remover
Exports from shops, CRMs and surveys usually carry columns you do not want to share or import, such as internal IDs, email addresses or notes. This tool removes the columns you list and leaves the rest of the file as it was. Name the columns by number, by a range like 2-3 or by header names like email, id. After the removal it tells you how many columns were deleted and how many are left. The separator is detected for you, quoted values stay intact, and the file is processed in your browser, so nothing is uploaded.
Updated October 2026
How to use the CSV Column Remover
- 1Paste your CSV into the box.
- 2Type the columns to delete: numbers, ranges or header names.
- 3Keep the header option ticked if the first row holds column names.
- 4Check the note that shows how many columns were removed and how many remain.
- 5Copy the new CSV or download it.
When to remove columns
Before you send a file to someone else, remove what they do not need. Before an import, remove columns the target system does not know, because many importers reject unknown fields. Before analysis, remove free-text notes that make a table hard to read. Dropping columns is also the quickest way to shrink a very large export.
Because the tool edits plain text, other cells are not reformatted, so long numbers, leading zeros and dates look exactly as before.
Name or number
Numbers are simple when the file has no header, but they break when the export changes its column order next month. Header names are safer for files you process again and again, because the same instruction keeps working. Use a number if two columns share the same header.
You can mix both styles and ranges in one list.
- By number: 2
- By range: 3-5
- By name: email, phone
Check before you share
Look at the output and the counts. If you removed an email column to protect privacy, scan the remaining columns for other personal data such as phone numbers or addresses in free-text notes. Removing a column is a clean way to share less, but only if you remove the right ones.
Common uses
A support team removes the notes column before sending a ticket list to a client. A shop removes the cost price column before sharing a product list with a supplier. A researcher removes the name column to anonymise survey answers before analysis.
In all of these, the aim is to share less. The remover works on the text of the file, so what you delete is gone from the output, and the original file on your device is not modified. After removing columns, reorder what is left with the CSV Column Swapper, or see all options in CSV Tools.
Features
- Delete by number, range or header name
- Remaining columns keep their order
- Quoted values with commas stay intact
- Comma, semicolon, tab and pipe separators
- Counts removed and remaining columns
- Private: nothing is uploaded
Frequently asked questions
How do I delete a column from a CSV file?
Paste the CSV, type the column number or header name in the box, and copy the result. For example, entering email removes the column whose header is email.
Can I remove several columns at once?
Yes. Separate them with commas, and use a dash for a range. Typing 1, 3-4, notes deletes the first column, the third and fourth columns and the column called notes.
Will the other columns keep their order?
Yes. The columns that are left stay in their original order. If you also want to reorder them, use the CSV Column Extractor, which follows the order you type.
What if the column name is not found?
The tool stops with a message that names the column it could not find, rather than silently returning the whole file. Check the spelling or use the column number.
Can I remove every column?
No. A CSV needs at least one column, so the tool reports an error if your list would leave nothing.
Is my data safe?
The columns are removed by code that runs in your browser tab. The file is not uploaded, so exports with personal details stay on your device.