About the TSV Column Remover
This tool takes columns out of a tab-separated table and leaves the rest as they were. Name the columns to delete by number, by a range like 2-3 or by the heading in the first row. After the removal it reports how many columns went and how many are left. Because the tab is the only separator it looks for, commas and quotation marks inside cells are not mistaken for column breaks. It is useful before you share a table, before an import that rejects unknown fields and whenever a spreadsheet is more than you want. It works in your browser and uploads nothing.
Updated October 2026
How to use the TSV Column Remover
- 1Paste your TSV into the left box.
- 2Type the columns to delete: numbers, ranges or headings.
- 3Keep the header option ticked if the first row names the columns.
- 4Check the note for how many columns were removed and how many remain.
- 5Copy the new table or download it.
Share less, import cleaner
Removing columns is the simplest privacy step: if a column holds emails, phone numbers or internal notes that your reader does not need, take it out before sending. It also helps imports, because many systems reject files with columns they do not know.
A smaller table loads faster and is easier to check by eye.
Number or heading
Headings are safer for files that you process repeatedly, since the instruction still works if the export reorders its columns. Numbers are simpler when there is no heading row. Use a number if two columns share a heading.
- By number: 3
- By range: 2-4
- By heading: notes
Check before sharing
After deleting, read the remaining headings and a few rows. If you removed a column to protect privacy, scan the others for personal data hidden in free-text notes.
Examples
From a table with the headings id, name, email and city, removing email leaves id, name and city. Removing 1, 4 leaves name and email. Removing the range 2-3 leaves id and city. The note under the result confirms how many columns went and how many are left.
If you mistype a heading, the tool names the heading it could not find instead of silently returning the whole table.
Phone and computer
On a phone, paste into the box, adjust the columns to delete, and tap Copy to carry the result into another app. On a computer you can also download it as a file. The two boxes sit side by side on a wide screen and one above the other on a narrow one, so you can compare input and result without zooming. Nothing you paste is uploaded or stored.
Good to know
If the same heading appears twice, the first matching column is the one removed; use column numbers to delete the other. Rows of different lengths are padded to the same width before the columns are cut, so the result is always a tidy rectangle. For comma-separated files, CSV Column Remover does the same job. TSV Column Extractor keeps only the column you want, and TSV to CSV Converter changes the format afterwards.
Features
- Delete by number, range or heading
- The remaining columns keep their order
- Tab separator is fixed
- Reports removed and remaining columns
- Refuses to delete every column
- Private: nothing is uploaded
Frequently asked questions
How do I delete a column from a TSV file?
Paste the table and type the number or heading of the column. The result shows the same table without it.
Can I delete several columns at once?
Yes. Separate them with commas and use a dash for a range, for example 1, 3-4, notes.
Does the order of the other columns change?
No. They stay in their original order.
Why won't it delete all the columns?
A table needs at least one column, so the tool asks you to leave at least one.
Why use this instead of deleting in a spreadsheet?
For large files it is quicker, and the cells you keep are not reformatted, so long numbers and leading zeros stay as they were.
Is the table uploaded?
No. Columns are removed in your browser and the data stays on your device.