Simple and free online TSV column replacer. Just paste a Tab-Separated Values table into the form below, enter the replacement column in the options, and the tool will overwrite the selected column with the new fields. You can replace a column by position or header name, put one or several new columns in its place, choose how missing replacement fields are filled, and skip comment or empty rows. Created by programmers from team Browserling.
Simple and free online TSV column replacer. Just paste a Tab-Separated Values table into the form below, enter the replacement column in the options, and the tool will overwrite the selected column with the new fields. You can replace a column by position or header name, put one or several new columns in its place, choose how missing replacement fields are filled, and skip comment or empty rows. Created by programmers from team Browserling.
This online tool replaces columns in Tab Separated Values (TSV) files. It finds the TSV column that needs to be replaced and rewrites each field in that column, from the header cell to the final value in the last row. All other columns remain unchanged, so you can update one part of the table without rebuilding the entire TSV file. Column replacement is useful when one table column is outdated, imported under the wrong header, or stored in the wrong unit of measurement. To replace it, enter a new column of the same height in the options, using one value per line. You can also place several new columns where the original column used to be by entering tab-separated replacement values in the options. The column to replace can be selected by position. For example, 1 replaces the first column, 2 replaces the second column, and -1 replaces the last column. If the TSV has a header row, you can select the replacement column by header text, such as "name" or "status". When the same header appears more than once, the tool can replace only the first matching column, or it can replace every matching header in the TSV. If the height of the replacement column does not match the number of rows in the input TSV, the tool can automatically fill missing fields with either empty values or a custom string that you specify in the options. The tool can also clean the TSV before replacement by skipping rows that begin with a comment symbol and removing empty rows that contain no data. Tsv-abulous!
This online tool replaces columns in Tab Separated Values (TSV) files. It finds the TSV column that needs to be replaced and rewrites each field in that column, from the header cell to the final value in the last row. All other columns remain unchanged, so you can update one part of the table without rebuilding the entire TSV file. Column replacement is useful when one table column is outdated, imported under the wrong header, or stored in the wrong unit of measurement. To replace it, enter a new column of the same height in the options, using one value per line. You can also place several new columns where the original column used to be by entering tab-separated replacement values in the options. The column to replace can be selected by position. For example, 1 replaces the first column, 2 replaces the second column, and -1 replaces the last column. If the TSV has a header row, you can select the replacement column by header text, such as "name" or "status". When the same header appears more than once, the tool can replace only the first matching column, or it can replace every matching header in the TSV. If the height of the replacement column does not match the number of rows in the input TSV, the tool can automatically fill missing fields with either empty values or a custom string that you specify in the options. The tool can also clean the TSV before replacement by skipping rows that begin with a comment symbol and removing empty rows that contain no data. Tsv-abulous!
In this example, we update a TSV trail list by replacing the second column. The input stores trail lengths in kilometers, but we want the output to show the same distances in miles. We choose column number 2 and replace the "km" values with converted "mi" values.
In this example, we replace one TSV column with two new TSV columns. The original flight table has a single "gate_code" field that combines the terminal and gate. We select this column by its header name and replace it with separate "terminal" and "gate" fields. The replacement data in the options uses tabs between the two new fields on every row.
This example replaces the "lens" column in a TSV photo table with a new "lens_type" column. Before replacing it, we remove the blank rows and skip the "# test shots" comment row. The cleaned TSV has four photo rows, but the replacement data provides lens types for only three of them, so the final photo receives the custom fill value "unknown".
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!
