᠎᠎᠎          
51K

Tsv column replacer

World's simplest tsv tool

World's simplest online Tab Separated Values column replacer. Just paste your existing TSV in the form below, choose columns to replace and they will instantly get substituted. Free, quick and very powerful. Paste TSV, replace columns. Created by programmers from team Browserling.
we wrote the curl cookbook!
Super exciting news – we just wrote the Curl Cookbook full of organic, nutritious, and completely irresistible curl recipes. Check it out!
New TSV Column
Enter your new TSV column(s)
Select TSV Column
Which column to replace?
Selection
Replace all occurences of a column
Tsv column replacer tool What is a tsv column replacer?
This tool replaces columns in a TSV (Tab Separated Values) file. It allows you to substitute one or more columns at a time. The configuration options allow you to select the column to replace by column position or column title. The replace all option allows you to replace multiple columns at once.
Tsv column replacer examples Click to use
Replace a single TSV column
In this example we replace a column of colors in TSV formt with another column.
red yellow green blue orange white
red yellow black blue orange gray
Required options
These options will be used automatically if you select this example.
Enter your new TSV column(s)
Which column to replace?
Replace duplicate TSV columns
In this example we replace all TSV columns that have the same column title.
element amount element amount oxygen 5 sodium 10
element amount element amount oxygen 5 sodium 10
Required options
These options will be used automatically if you select this example.
Enter your new TSV column(s)
Which column to replace?
Replace all occurences of a column
Pro tips Master online tsv tools
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!
https://onlinetsvtools.com/replace-tsv-columns?input=red%09yellow%09green%0Ablue%09orange%09white&replace-column=black%0Agray&replace-which-column=3
All tsv tools
Didn't find the tool you were looking for? Let us know what tool we are missing and we'll build it!
Quickly change the TSV delimiter to a different symbol.
Quickly generate random TSV data.
Quickly extract columns from a TSV file.
Quickly delete columns in a TSV file.
Quickly add quotes around TSV columns.
Quickly remove quotes that surround TSV columns.
Quickly swap columns in a TSV file.
Quickly convert a TSV file to a JSON data structure.
Quickly convert a JSON data structure to TSV format.
Quickly convert a TSV file to XML markup.
Quickly convert XML markup to a TSV file.
Quickly convert a TSV file to YAML markup.
Quickly convert YAML data to a TSV file.
Quickly convert TSV data to CSV data.
Quickly convert CSV data to TSV data.
Quickly convert TSV data to nicely aligned text columns.
Quickly convert text columns to TSV columns.
Quickly convert TSV data to base64 encoding.
Quickly convert base64-encoded TSV data to TSV data.
Quickly convert a TSV file to URL-encoding.
Quickly convert a URL-encoded TSV file back to TSV.
Quickly prepend new columns at the start of a TSV file.
Quickly append new columns at the end of a TSV file.
Quickly insert new columns anywhere in a TSV file.
Quickly replace columns in a TSV file.
Quickly remove extra spaces around TSV columns.
Quickly truncate the contents of TSV cells to any length.
Quickly exchange TSV columns with rows.
Quickly exchange TSV rows with columns.
Quickly transpose a TSV file.
Coming soon These tsv tools are on the way
Display TSV Statistics
Print information about a TSV file.
Show TSV Structure
Create an abstract painting that shows the structure of a TSV.
View and Edit TSV
Show a TSV file in the browser and allow easy editing.
Convert TSV to HTML Table
Convert a Tab Separated Values file to an HTML table.
Convert HTML Table to TSV
Convert an HTML table to a Tab Separated Values file.
Convert TSV to PDF
Convert a Tab Separated Values file to a PDF document.
Convert PDF to TSV
Convert a PDF document to a Tab Separated Values file.
Convert TSV to Image
Draw Tab Separated Values as a table and output it as an image.
Convert Image to TSV
Extract data in an image and format it as a TSV file.
Convert TSV to Excel
Convert a Tab Separated Values file to an Excel spreadsheet.
Convert Excel to TSV
Convert an Excel file to a Tab Separated Values file.
Convert TSV to LaTeX
Convert a TSV file to LaTeX code that generates a table.
Convert TSV to ASCII Table
Convert a Tab Separated Values file to a neat ASCII table.
Convert ASCII Table to TSV
Convert an ASCII table to a Tab Separated Values file.
Convert TSV to SQL
Convert a Tab Separated Values file to an SQL query.
Convert TSV to PSV
Convert a TSV file to a PSV (Pipe Separated Values) file.
Convert PSV to TSV
Convert a PSV (Pipe Separated Values) file to a TSV file.
Convert TSV to HSV
Convert a TSV file to a HSV (Hash Separated Values) file.
Convert HSV to TSV
Convert a HSV (Hash Separated Values) file to a TSV file.
Merge TSV Files
Merge together two Tab Separated Values files.
Delete Empty TSV Columns
Delete columns that have no values in a TSV file.
Delete Empty TSV Rows
Delete rows that have no values in a TSV file.
Filter TSV Data
Filter rows and columns that match a pattern.
Find Values in TSV
Find certain values in TSV cells.
Compress TSV
Minify a TSV file and remove extra spaces and indentation.
Compare Two TSV Files
Diff two TSV files and visually display the differences.
Rotate TSV Columns
Rotate TSV columns to the left or right.
Rotate TSV Rows
Rotate TSV rows up or down.
Slice a TSV File
Extract a slice (rows/columns/cells) of a TSV.
Randomize TSV Columns
Shuffle the order of TSV columns.
Randomize TSV Rows
Shuffle the order of TSV rows.
Sort TSV Columns
Sort values in a TSV column.
Sort TSV Rows
Sort values in a TSV rows.
Count TSV Columns
Find how many columns there are in the given TSV data.
Count TSV Rows
Find how many rows there are in the given TSV data.
Count TSV Entries
Find how many total entries there are in a TSV file.
Color a TSV File
Add colors to TSV data for easy visual overview of the file.
Open a TSV
Open a TSV file in your browser.