Simple and free online TSV column prepender. Just paste a Tab Separated Values file into the form below, enter the columns to prepend in the options, and the tool will add those fields before the first column of each row. You can prepend one column or several tab-separated columns at once, remove blank and commented rows, and choose how missing TSV fields should be handled. Created by programmers from team Browserling.
Simple and free online TSV column prepender. Just paste a Tab Separated Values file into the form below, enter the columns to prepend in the options, and the tool will add those fields before the first column of each row. You can prepend one column or several tab-separated columns at once, remove blank and commented rows, and choose how missing TSV fields should be handled. Created by programmers from team Browserling.
This online tool prepends one or more columns to a Tab Separated Values (TSV) table. Prepending columns means adding new fields at the beginning of each row, before the current first column, while keeping the existing TSV data in the same row order. The original cells are not rewritten or reordered; they are shifted to the right to make room for the new leading columns. In the "Columns to Prepend" option, enter the values that should be added to the left side of the table. To prepend a single column, enter one value for each input row. To prepend multiple columns, enter one row of tab-separated values for each input row. If the original TSV and the columns being prepended do not have matching field counts, you can keep rows as they are, skip incomplete rows, use empty fields, or fill missing fields with a custom value. The cleanup options can remove blank TSV rows and skip comment rows that begin with a selected marker, such as "#" or "//". To add fields after the last column, use our Append TSV Columns tool, and to place fields at a specific position, use our Insert TSV Columns tool. Tsv-abulous!
This online tool prepends one or more columns to a Tab Separated Values (TSV) table. Prepending columns means adding new fields at the beginning of each row, before the current first column, while keeping the existing TSV data in the same row order. The original cells are not rewritten or reordered; they are shifted to the right to make room for the new leading columns. In the "Columns to Prepend" option, enter the values that should be added to the left side of the table. To prepend a single column, enter one value for each input row. To prepend multiple columns, enter one row of tab-separated values for each input row. If the original TSV and the columns being prepended do not have matching field counts, you can keep rows as they are, skip incomplete rows, use empty fields, or fill missing fields with a custom value. The cleanup options can remove blank TSV rows and skip comment rows that begin with a selected marker, such as "#" or "//". To add fields after the last column, use our Append TSV Columns tool, and to place fields at a specific position, use our Insert TSV Columns tool. Tsv-abulous!
In this example, we prepend one new column to a TSV library catalog. The original table has "genre", "shelf", and "books" columns. In the options, we enter one "branch" value for each row. The tool adds the "branch" column before the current first column and shifts the original TSV fields to the right.
In this example, we extend a TSV plant list by placing two new columns at the far left of the table. In the options, we enter "zone" and "sun" values for each plant row. As a result, the original "plant", "color", and "height" fields move to the right, and the new "zone" and "sun" fields appear before them.
In this example, we prepend one "day" column to a TSV workout list. Before adding the new column, the tool removes the empty row and skips the "// old plan" comment row. There are four workout rows left, but only three "day" values are provided in the options, so the missing day is filled with the custom value "no-day".
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!
