Simple and free online TSV analyzer. Just paste Tab Separated Values (TSV) into the form below, and this tool will inspect the table structure, cell contents, and selected columns. You can check row and column counts, find empty or missing cells, detect common value types, measure cell lengths, and analyze individual columns in detail. Created by programmers from team Browserling.
Simple and free online TSV analyzer. Just paste Tab Separated Values (TSV) into the form below, and this tool will inspect the table structure, cell contents, and selected columns. You can check row and column counts, find empty or missing cells, detect common value types, measure cell lengths, and analyze individual columns in detail. Created by programmers from team Browserling.
This online tool analyzes Tab Separated Values (TSV) data. It checks the structure of a TSV file, identifies the kinds of values stored in its cells, and can also run detailed analysis for specific columns. This is useful when you receive a TSV export and want to quickly check whether it is safe to import into a spreadsheet, or when a script does not parse a TSV file as expected, and you need to find missing fields, blank values, or inconsistent columns. The input should be TSV data with tab characters between cells. Before the analysis runs, the tool can clean up the input by skipping comment rows and blank rows. Comment rows are identified by a marker that you choose, such as "#". Any row that starts with this marker can be excluded from the statistics. The first row can be treated as a header row. When this option is enabled, the top row is used as column labels and stays available for selecting columns by name. At the same time, it is not counted as data, so its cells are excluded from value totals, type detection, and length measurements. When the option is disabled, the first row is treated as a regular data row and included in the analysis. The options let you choose which information blocks to show in the report. The TSV structure block shows the overall shape of the table, including row count, column count, expected cell count, actual cell count, and the locations of empty, whitespace-only, and missing cells. The value type block shows what kinds of data appear in the table, such as strings, integers, decimals, booleans, dates, times, date-time values, email addresses, and URLs. The value length block finds the shortest and longest filled TSV cells and shows their exact locations in the table. You can also print detailed information about selected columns. Columns can be selected by position, by ranges such as 2-4, by negative positions such as -1 for the last column, or by header text. If a header appears in multiple columns, you can keep only the first match or include every matching column. Each column section shows the first column value, existing, empty, whitespace-only, and missing counts, the dominant value type, numeric minimum, maximum, and average when numbers are present, plus the shortest and longest value in that column. Tsv-abulous!
This online tool analyzes Tab Separated Values (TSV) data. It checks the structure of a TSV file, identifies the kinds of values stored in its cells, and can also run detailed analysis for specific columns. This is useful when you receive a TSV export and want to quickly check whether it is safe to import into a spreadsheet, or when a script does not parse a TSV file as expected, and you need to find missing fields, blank values, or inconsistent columns. The input should be TSV data with tab characters between cells. Before the analysis runs, the tool can clean up the input by skipping comment rows and blank rows. Comment rows are identified by a marker that you choose, such as "#". Any row that starts with this marker can be excluded from the statistics. The first row can be treated as a header row. When this option is enabled, the top row is used as column labels and stays available for selecting columns by name. At the same time, it is not counted as data, so its cells are excluded from value totals, type detection, and length measurements. When the option is disabled, the first row is treated as a regular data row and included in the analysis. The options let you choose which information blocks to show in the report. The TSV structure block shows the overall shape of the table, including row count, column count, expected cell count, actual cell count, and the locations of empty, whitespace-only, and missing cells. The value type block shows what kinds of data appear in the table, such as strings, integers, decimals, booleans, dates, times, date-time values, email addresses, and URLs. The value length block finds the shortest and longest filled TSV cells and shows their exact locations in the table. You can also print detailed information about selected columns. Columns can be selected by position, by ranges such as 2-4, by negative positions such as -1 for the last column, or by header text. If a header appears in multiple columns, you can keep only the first match or include every matching column. Each column section shows the first column value, existing, empty, whitespace-only, and missing counts, the dominant value type, numeric minimum, maximum, and average when numbers are present, plus the shortest and longest value in that column. Tsv-abulous!
In this example, we inspect a small TSV sheet for origami models. The table has one header row and three complete data rows with fold names, step counts, and difficulty levels. The first row is used only as headers, so its cells are not included in row counts, cell totals, empty checks, or missing-value checks. The report describes the data area below the header: 3 rows, 3 TSV columns, and 9 filled data cells.
In this example, we analyze a compact amateur radio contact TSV. The table has four columns: call, time, confirmed, and ref. Since the header row is included in the analysis, the header values are counted together with the contact records and appear in the value length results. The analyzer skips the comment row, finds one missing ref value in the last contact, and detects a mix of TSV value types: strings, times, booleans, emails, and one URL. It also reports the shortest and longest filled cells with their exact row and column positions.
In this example, we review every column in a TSV cue sheet for a shadow theater show. Column analysis is enabled for positions 1-4, so each column gets its own detailed report. The "cue" column contains short string IDs, the "scene" column contains text labels with different lengths, the "level" column contains integers with a minimum, maximum, and average value, and the "ready" column contains boolean true/false values. The report also confirms that every column is complete, with no empty, whitespace-only, or missing values.
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!
