Simple and free online TSV column sorter. Just paste a TSV table and choose the column that should control the table values order. You can select the column by position or header text and sort its values as text, as numbers, by length, or by complexity. You can also keep the first row fixed as a header, handle rows with missing fields, and skip comments or empty rows before sorting. Created by programmers from team Browserling.
Simple and free online TSV column sorter. Just paste a TSV table and choose the column that should control the table values order. You can select the column by position or header text and sort its values as text, as numbers, by length, or by complexity. You can also keep the first row fixed as a header, handle rows with missing fields, and skip comments or empty rows before sorting. Created by programmers from team Browserling.
This online tool sorts Tab Separated Values (TSV) data by reading the values in a selected column and rearranging the table rows in the specified order. Sorting a TSV table does not mean sorting a single column. The tool uses the selected column only to decide the order, then moves complete rows into that order so the table records stay intact. The primary sort column can be selected by position (e.g., 1, 2, or -1 for the last column) or by matching the header text in the first row. When primary values repeat, secondary sort columns can be used to decide how those matching rows should be arranged. For example, you can sort a product list by category first and then by price, or sort a contact list by city first and then by name. The first TSV row can stay fixed as a header, or it can be sorted together with the other rows when it contains regular data. The tool can compare values as text (alphabetically), as numbers, by length (number of characters), or by complexity. The output can be arranged in ascending or descending order, and case-sensitive sorting can treat values such as "Apple" and "apple" as different text. If some TSV rows have missing fields, the tool can keep those short rows unchanged, add blank fields, or insert custom fill text into the missing positions. Before the sort runs, empty rows and rows marked as comments can be removed to prevent notes from being mixed into the sorted table. Tsv-abulous!
This online tool sorts Tab Separated Values (TSV) data by reading the values in a selected column and rearranging the table rows in the specified order. Sorting a TSV table does not mean sorting a single column. The tool uses the selected column only to decide the order, then moves complete rows into that order so the table records stay intact. The primary sort column can be selected by position (e.g., 1, 2, or -1 for the last column) or by matching the header text in the first row. When primary values repeat, secondary sort columns can be used to decide how those matching rows should be arranged. For example, you can sort a product list by category first and then by price, or sort a contact list by city first and then by name. The first TSV row can stay fixed as a header, or it can be sorted together with the other rows when it contains regular data. The tool can compare values as text (alphabetically), as numbers, by length (number of characters), or by complexity. The output can be arranged in ascending or descending order, and case-sensitive sorting can treat values such as "Apple" and "apple" as different text. If some TSV rows have missing fields, the tool can keep those short rows unchanged, add blank fields, or insert custom fill text into the missing positions. Before the sort runs, empty rows and rows marked as comments can be removed to prevent notes from being mixed into the sorted table. Tsv-abulous!
In this example, we sort a simple two-column TSV recipe list. The first column contains ingredient names and the second column contains their amounts in grams. We sort by column 2, so the ingredients are ordered from the smallest gram amount to the largest.
In this example, we sort a TSV gym class schedule by the length of each class name. The table has two columns: class and room. We sort the table by the first column, keeping the first row as the header. We choose the length-based sort method and use ascending order, so shorter class names appear first and longer class names appear later. The input TSV has a missing room value for the stretching class, so we pad the data table with the custom value "unassigned". This creates a complete two-column TSV structure in the output.
In this example, we clean and sort a small TSV contact list. Each contact has three short fields: name, city, and phone. We use header-based sorting, so the primary sort header is "city" and the secondary sort header is "name". This is useful for a contact sheet where people should first be grouped by city, and then listed alphabetically inside each city. The first row stays fixed, and the values are sorted as text in ascending order. Before sorting, the cleanup options remove rows that start with the "#" comment prefix and also remove blank rows.
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!
