Manage Columns in TSV Files Online
Drop or select specific columns from TSV files directly in your browser. No upload required.
How to manage Columns in TSV files
- Drop your file onto the upload area. Every column is listed as a chip with its detected type, and all are selected to start with.
- Click a chip to deselect a column you want to drop. It turns grey with a line through it. Click again to bring it back.
- Use Deselect all and then click the few columns you need when you only want to keep a handful.
- Click Apply to preview the result, then Download to save it in the same format you uploaded.
Your file is processed locally in your browser and is never uploaded. The free limit is 50 MB per file; larger files work if your device has the memory for them.
Worked example
An HR analyst needs to send a headcount list to a facilities team, without salary or national ID numbers.
Input (TSV)
emp_id name dept salary national_id
2041 Maria Keane Finance 68000 KX 44 91 02 C
2042 Dev Patel Operations 54500 LM 20 17 88 A
2043 Sofia Brandt Finance 71200 PR 63 05 19 DSettings
- Deselected: salary, national_id
- Kept: emp_id, name, dept
Result
| emp_id | name | dept |
|---|---|---|
| 2041 | Maria Keane | Finance |
| 2042 | Dev Patel | Operations |
| 2043 | Sofia Brandt | Finance |
The two sensitive columns are removed entirely, not blanked, so they are absent from the downloaded file. The three kept columns stay in their original left-to-right order with their original types. Every row is kept, and no values change.
Frequently Asked Questions
Can I reorder columns with this tool?
No. Kept columns stay in their original left-to-right order. To change the order, use the SQL Query tool and list the columns in the order you want.
Does selecting columns change any values or types?
No. Kept columns are copied exactly, with the same types. Only the dropped columns are removed.
Can I drop every column?
No. At least one column must stay selected, and Apply is disabled until one is.
Related Tools
Rename Columns in CSV Files Online
Rename columns in CSV files instantly in your browser. No upload, no server — your data stays on your device.
Deduplicate CSV Files Online
Remove duplicate rows from CSV files instantly in your browser. No upload, no server — 100% private.
Hash & Anonymise Columns in CSV Files Online
Anonymise or pseudonymise columns in CSV files by replacing values with MD5, SHA-256, or DuckDB hashes — directly in your browser. Useful for GDPR compliance and sharing data without exposing PII — no upload required.
Manage Columns in CSV Files Online
Drop or select specific columns from CSV files directly in your browser. No upload required.
Manage Columns in Excel Files Online
Drop or select specific columns from Excel files directly in your browser. No upload required.
Manage Columns in Parquet Files Online
Drop or select specific columns from Parquet files directly in your browser. No upload required.
Manage Columns in JSON Files Online
Drop or select specific columns from JSON files directly in your browser. No upload required.
TSV Viewer Online
View and inspect TSV files directly in your browser. Browse rows, check column names and data types — no upload required, your data stays on your device.