Our Network


Coming Soon


Coming Later

TSV Column Appender

World's Simplest TSV Tool

Simple and free online TSV column appender. Just paste Tab Separated Values into the form below, add the trailing column data in the options, and the tool will add those fields to the end of each row. You can attach a single column or multiple tab-separated columns, skip blank and commented rows, and fill missing appended fields with empty or custom values. Created by programmers from team Browserling.

TSV Column Appender

World's Simplest TSV Tool

Simple and free online TSV column appender. Just paste Tab Separated Values into the form below, add the trailing column data in the options, and the tool will add those fields to the end of each row. You can attach a single column or multiple tab-separated columns, skip blank and commented rows, and fill missing appended fields with empty or custom values. Created by programmers from team Browserling.

Tool Options

Append TSV Columns

Enter TSV fields that should appear after the current last column.
To append one column, enter one value per line. To append several columns, use tabs between values.
For example: Status ⇥ Owner Ready ⇥ Crew A Review ⇥ Crew B

Missing Appended Fields

Choose how to handle rows when appended values are missing or uneven.
Enter the value to append when a row has missing append data.

Cleanup Before Append

Skip input rows that begin with this marker before appending columns.
Skip empty input rows before appending columns.

What Is a TSV Column Appender?

This online tool expands a Tab Separated Values (TSV) table by adding extra columns after the last existing field in each row. It is useful when you already have a TSV table and want to attach new row data, such as statuses, owners, categories, notes, IDs, or other trailing fields, without changing the original columns. To append one column, enter one value for each input row in the append options. To append several columns, enter tab-separated values on each line. The tool joins each input row with the matching append row, so the added fields appear on the right side of the TSV. When the appended data has fewer rows than the input TSV, some input rows do not receive new fields on the right. In this case, the tool can keep those rows as they are, skip incomplete rows, add empty fields, or insert a custom fill value. You can also clean the input before appending by removing blank rows and skipping comment rows with a selected marker. If the new fields should go at the beginning instead of the end, try Prepend TSV Columns. If they should appear in the middle of the table, use Insert TSV Columns. Tsv-abulous!

What Is a TSV Column Appender?

This online tool expands a Tab Separated Values (TSV) table by adding extra columns after the last existing field in each row. It is useful when you already have a TSV table and want to attach new row data, such as statuses, owners, categories, notes, IDs, or other trailing fields, without changing the original columns. To append one column, enter one value for each input row in the append options. To append several columns, enter tab-separated values on each line. The tool joins each input row with the matching append row, so the added fields appear on the right side of the TSV. When the appended data has fewer rows than the input TSV, some input rows do not receive new fields on the right. In this case, the tool can keep those rows as they are, skip incomplete rows, add empty fields, or insert a custom fill value. You can also clean the input before appending by removing blank rows and skipping comment rows with a selected marker. If the new fields should go at the beginning instead of the end, try Prepend TSV Columns. If they should appear in the middle of the table, use Insert TSV Columns. Tsv-abulous!


TSV Column Appender Examples

Click to try!
click me

Append Train Seat Preferences

In this example, we append one new column to a TSV train ticket list. The input table already has "ticket", "car", "class", and "seat" columns. In the options, we enter the "window" column, and the tool adds it after the last column.

ticket car class seat T-104 3 first 12A T-118 5 second 24C T-127 2 first 08B
ticket car class seat window T-104 3 first 12A yes T-118 5 second 24C no T-127 2 first 08B yes
Required options
These options will be used automatically if you select this example.
Enter TSV fields that should appear after the current last column.
Choose how to handle rows when appended values are missing or uneven.
Enter the value to append when a row has missing append data.
Skip input rows that begin with this marker before appending columns.
Skip empty input rows before appending columns.
click me

Append Scores to a Puzzle TSV

In this example, we append two new columns to a TSV puzzle table. The input has puzzle names and difficulty modes, but it also contains blank rows and a "# bonus round" comment line. The cleanup options skip these non-data rows first. Then the tool appends the "score" and "rank" columns to the right side of each remaining puzzle row.

puzzle mode maze easy # bonus round cube hard riddle medium logic easy
puzzle mode score rank maze easy 82 B cube hard 95 A riddle medium 74 C logic easy 88 B
Required options
These options will be used automatically if you select this example.
Enter TSV fields that should appear after the current last column.
Choose how to handle rows when appended values are missing or uneven.
Enter the value to append when a row has missing append data.
Skip input rows that begin with this marker before appending columns.
Skip empty input rows before appending columns.
click me

Append a Bakery Status Column

This example adds a status column to the end of a TSV bakery order list. The input contains four bakery orders, but the appended data includes statuses for only the first three orders. Because the final order does not receive a status from the appended column, the tool uses the custom fill value "check-order" for that last cell.

order item B-104 bread B-118 muffin B-127 pie B-132 cookies
order item status B-104 bread ready B-118 muffin baking B-127 pie packed B-132 cookies check-order
Required options
These options will be used automatically if you select this example.
Enter TSV fields that should appear after the current last column.
Choose how to handle rows when appended values are missing or uneven.
Enter the value to append when a row has missing append data.
Skip input rows that begin with this marker before appending columns.
Skip empty input rows before appending columns.

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://onlinetools.com/tsv/append-tsv-columns?input=ticket%09car%09class%09seat%0AT-104%093%09first%0912A%0AT-118%095%09second%0924C%0AT-127%092%09first%0908B&insert-column=window%250Ayes%250Ano%250Ayes&incomplete-format=leave-incomplete&custom-value=N%252FA&remove-comments=false&comment-character=%2523&remove-empty-lines=false

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 selected columns from a TSV file.
Quickly delete selected columns in a TSV file.
Quickly remove tabs that go between TSV columns and merge all data.
Quickly add quotes around TSV columns.
Quickly remove quotes that surround TSV columns.
Quickly swap columns in a TSV file.
Quickly sort TSV data by selected column values.
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 add one or more columns before the first TSV column.
Quickly append new columns at the end of a TSV file.
Quickly insert new columns anywhere in a TSV file.
Quickly replace selected 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.
Quickly inspect the structure and contents of a TSV file.
Quickly check a TSV file for errors and report them.
Quickly test tab-separated data for row and field problems.
Quickly locate missing and blank cells in TSV data.
Quickly fill missing and blank cells in TSV data.

Coming Soon

These TSV tools are on the way!
Calculate TSV Entropy

Find the complexity of a TSV file.

Show TSV Structure

Create an abstract drawing that shows the structure of a TSV.

View and Edit TSV

Show a TSV file in a neat editor and allow easy editing.

Convert TSV to Double-TSV

Convert a TSV file to a double-TSV file.

Convert Double-TSV to TSV

Convert a double-TSV file to a regular TSV file.

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 Markdown

Convert a TSV file to a Markdown table.

Convert Markdown to TSV

Convert a Markdown table to a TSV 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 SQLite

Convert a Tab Separated Values file to an SQLite database.

Convert SQLite to TSV

Export tables from an SQLite database as TSV files.

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.

Convert TSV to SSV

Convert a TSV file to a SSV (Semicolon Separated Values) file.

Convert SSV to TSV

Convert a SSV (Semicolon Separated Values) file to a TSV file.

Convert TSV to 0SV

Convert a TSV file to a 0SV (Null Separated Values) file.

Convert 0SV to TSV

Convert a 0SV (Null Separated Values) file to a TSV file.

Split a TSV File

Create multiple TSV files from the given TSV file.

Merge TSV Files

Merge together two Tab Separated Values files.

Delete Empty TSV Columns

Remove columns that have no values in a TSV file.

Delete Empty TSV Rows

Remove rows that have no values in a TSV file.

Delete Empty TSV Lines

Remove lines in a TSV file that are blank.

Delete TSV Comments

Delete TSV lines that are comments.

Filter TSV Data

Filter rows and columns that match a pattern.

Find Values in TSV

Find certain values in TSV cells.

Find Duplicate TSV Rows

Extract repeated rows in a TSV file.

Merge Duplicate TSV Rows

Combine duplicate rows in a TSV file.

Deduplicate TSV Rows

Remove repeated rows from a TSV file.

Delete Duplicate TSV Rows

Delete duplicate rows from a TSV file.

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.

Cut a TSV File

Cut a fragment from a TSV file.

Slice a TSV File

Extract a slice (rows/columns/cells) of a TSV file.

Randomize TSV Values

Shuffle all data values in a TSV file.

Randomize TSV Columns

Shuffle the order of TSV columns.

Randomize TSV Rows

Shuffle the order of TSV rows.

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.

Add Errors to TSV

Create random errors in a TSV file for fuzz testing.

Create a Custom TSV

Generate a custom TSV with n rows and m columns.

Open a TSV File

Open a TSV file directly in your browser.


Subscribe!

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


Feedback. We'd love to hear from you! 👋

Created with love by

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!

49K
@browserling

Didn't find the tool you were looking for? Let us know what tool we are missing and we'll build it!