Simple and free online TSV column deleter. Just paste a TSV table and choose which columns to remove. You can specify a single column, multiple columns, or an entire range of columns by number, or enter the text headers of the columns you want to remove. You can also clean the TSV by skipping empty rows and commented rows. Created by programmers from team Browserling.
Simple and free online TSV column deleter. Just paste a TSV table and choose which columns to remove. You can specify a single column, multiple columns, or an entire range of columns by number, or enter the text headers of the columns you want to remove. You can also clean the TSV by skipping empty rows and commented rows. Created by programmers from team Browserling.
This online tool removes unwanted columns from Tab Separated Values (TSV) files. When a column is deleted, the tool removes all values in that column, starting from the header cell (if the table has headers) and continuing through all rows below it. You can delete a single column by entering its number, such as "3", or remove several columns by entering multiple numbers, such as "1, 4, 6". You can also delete a full range of columns with a value such as "2-5", which removes columns 2 and 5, and all columns between them, or you can combine individual columns and ranges, such as "1, 3-5, 8". Negative numbers are supported too, so "-1" means the last column in a TSV, "-2" means the second column from the end, and so on. If your TSV file has a header row, you can switch to header matching and enter one or more header names, each on a separate line. For example, you can enter "name", "age", or "city" to delete columns with these titles. When the same header appears in multiple columns, the tool can delete only the first matching column or remove every column with that header. By default, deleted columns are removed from the table completely, so the remaining columns move left and the output TSV becomes narrower. If you prefer to preserve the original table width, you can keep empty column slots instead, so the deleted values become blank fields. The tool can also clean the input while deleting columns: it can skip empty rows and remove comment rows that begin with a marker such as "#" or "//". Tsv-abulous!
This online tool removes unwanted columns from Tab Separated Values (TSV) files. When a column is deleted, the tool removes all values in that column, starting from the header cell (if the table has headers) and continuing through all rows below it. You can delete a single column by entering its number, such as "3", or remove several columns by entering multiple numbers, such as "1, 4, 6". You can also delete a full range of columns with a value such as "2-5", which removes columns 2 and 5, and all columns between them, or you can combine individual columns and ranges, such as "1, 3-5, 8". Negative numbers are supported too, so "-1" means the last column in a TSV, "-2" means the second column from the end, and so on. If your TSV file has a header row, you can switch to header matching and enter one or more header names, each on a separate line. For example, you can enter "name", "age", or "city" to delete columns with these titles. When the same header appears in multiple columns, the tool can delete only the first matching column or remove every column with that header. By default, deleted columns are removed from the table completely, so the remaining columns move left and the output TSV becomes narrower. If you prefer to preserve the original table width, you can keep empty column slots instead, so the deleted values become blank fields. The tool can also clean the input while deleting columns: it can skip empty rows and remove comment rows that begin with a marker such as "#" or "//". Tsv-abulous!
In this example, we remove the third column from a TSV asset table. This column stores internal asset IDs, so the tool deletes it across the whole table, including the header and all values below it. The remaining TSV keeps only the device name, owner, and status fields.
In this example, a TSV task list has two columns with the same "note" header. We switch to header matching and enter "note" as the column name to delete. Since the "Remove Every Header Match" option is enabled, both note columns are selected. We also preserve the TSV layout, so the removed note values are replaced with empty fields instead of shifting the remaining columns left.
This example deletes the first and last columns from a TSV menu table by using the position list "1, -1". This leaves each data row with just two fields: the item name and the price. The tool also cleans the TSV by skipping the "# seasonal menu draft" comment row and removing the empty row.
You can pass input to this tool via ?input query argument and it will automatically compute output. Here's how to type it in your browser's address bar. Click to try!
Find the complexity of a TSV file.
Create an abstract drawing that shows the structure of a TSV.
Show a TSV file in a neat editor and allow easy editing.
Convert a TSV file to a double-TSV file.
Convert a double-TSV file to a regular TSV file.
Convert a Tab Separated Values file to an HTML table.
Convert an HTML table to a Tab Separated Values file.
Convert a TSV file to a Markdown table.
Convert a Markdown table to a TSV file.
Convert a Tab Separated Values file to a PDF document.
Convert a PDF document to a Tab Separated Values file.
Draw Tab Separated Values as a table and output it as an image.
Extract data in an image and format it as a TSV file.
Convert a Tab Separated Values file to an Excel spreadsheet.
Convert an Excel file to a Tab Separated Values file.
Convert a TSV file to LaTeX code that generates a table.
Convert a Tab Separated Values file to a neat ASCII table.
Convert an ASCII table to a Tab Separated Values file.
Convert a Tab Separated Values file to an SQL query.
Convert a Tab Separated Values file to an SQLite database.
Export tables from an SQLite database as TSV files.
Convert a TSV file to a PSV (Pipe Separated Values) file.
Convert a PSV (Pipe Separated Values) file to a TSV file.
Convert a TSV file to a HSV (Hash Separated Values) file.
Convert a HSV (Hash Separated Values) file to a TSV file.
Convert a TSV file to a SSV (Semicolon Separated Values) file.
Convert a SSV (Semicolon Separated Values) file to a TSV file.
Convert a TSV file to a 0SV (Null Separated Values) file.
Convert a 0SV (Null Separated Values) file to a TSV file.
Create multiple TSV files from the given TSV file.
Merge together two Tab Separated Values files.
Remove columns that have no values in a TSV file.
Remove rows that have no values in a TSV file.
Remove lines in a TSV file that are blank.
Delete TSV lines that are comments.
Filter rows and columns that match a pattern.
Find certain values in TSV cells.
Extract repeated rows in a TSV file.
Combine duplicate rows in a TSV file.
Remove repeated rows from a TSV file.
Delete duplicate rows from a TSV file.
Minify a TSV file and remove extra spaces and indentation.
Diff two TSV files and visually display the differences.
Rotate TSV columns to the left or right.
Rotate TSV rows up or down.
Cut a fragment from a TSV file.
Extract a slice (rows/columns/cells) of a TSV file.
Shuffle all data values in a TSV file.
Shuffle the order of TSV columns.
Shuffle the order of TSV rows.
Sort values in a TSV rows.
Find how many columns there are in the given TSV data.
Find how many rows there are in the given TSV data.
Find how many total entries there are in a TSV file.
Add colors to TSV data for easy visual overview of the file.
Create random errors in a TSV file for fuzz testing.
Generate a custom TSV with n rows and m columns.
Open a TSV file directly in your browser.
Subscribe to our updates. We'll let you know when we release new tools and features, and when we organize online workshops.
Enter your email here
We're Browserling — a friendly and fun cross-browser testing company powered by alien technology. At Browserling, we love to make developers' lives easier, so we created this collection of online TSV tools. Our tools have the simplest user interface that doesn't require advanced computer skills and they are used by millions of people every month. Behind the scenes, all our TSV tools are actually powered by our programming tools that we created over the last couple of years. Check them out!
