᠎᠎᠎          
51K

TSV Analyzer

World's simplest tsv tool
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.
Check out our main project! Browserling
We created Browserling – get a cloud browser in 5 seconds. Check it out!
A link to this tool, including input, options and all chained tools.
Import from file
Save as...
Copy to clipboard
Download
Export to Pastebin
Can't convert.
An error has occured.
Chain with...
Remove chain
Save as...
Copy to clipboard
Download
Export to Pastebin
Remove no tools?
This tool cannot be chained.
TSV Input Cleanup
Comment rows marked with this character are not included in statistics.
Blank rows are not included in statistics.
TSV Header Handling
Keep the first TSV row out of measured cell statistics.
You can still select columns by their TSV header text.
Report Blocks
Show row counts, column counts, blank values, and gaps.
Show strings, numbers, booleans, dates, emails, and URL cells.
Show the shortest and longest filled TSV cells.
Selected Column Analysis
Show statistics for the columns you choose.
Select columns to analyze by positions, such as "1, 5" or "2-4".
Select columns to analyze by headers, one header per line.
If a header repeats, inspect each matching TSV column.

What is a TSV Analyzer?

learn more about this tool
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!

TSV Analyzer examples

Click to use
Inspect an Origami Fold TSV
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.
fold steps level crane 18 hard boat 10 easy star 12 med
General Information: -------------------- Rows: 3 (excluding header row) Columns: 3 Expected values: 9 (3 rows × 3 columns) Total values: 9 (including empty and whitespace-only values) Empty values: 0 (zero-length values and whitespace-only values) Whitespace-only values: 0 Missing values: 0
Required options
These options will be used automatically if you select this example.
Comment rows marked with this character are not included in statistics.
Blank rows are not included in statistics.
Keep the first TSV row out of measured cell statistics.
Show row counts, column counts, blank values, and gaps.
Show strings, numbers, booleans, dates, emails, and URL cells.
Show the shortest and longest filled TSV cells.
Show statistics for the columns you choose.
Select columns to analyze by positions, such as "1, 5" or "2-4".
Select columns to analyze by headers, one header per line.
If a header repeats, inspect each matching TSV column.
Analyze Radio Contact TSV Values
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.
call time confirmed ref K7HAM 21:30 true k7@qsl.fm M0QSL 06:15 false https://mqs.radio JA1DX 11:24 true ja@qsl.jp LU5AR 23:05 false # duplicate contact
General Information: -------------------- Rows: 5 (including header row) Columns: 4 Expected values: 20 (5 rows × 4 columns) Total values: 19 (including empty and whitespace-only values) Empty values: 0 (zero-length values and whitespace-only values) Whitespace-only values: 0 Missing values: 1 • row 5, column 4 Value Types: ------------ String values: 15 Numeric values: 0 • Integer values: 0 • Decimal values: 0 Boolean values: 4 (values: true, false) Date values: 0 Time values: 4 (format: HH:MM) Date and time values: 0 Email values: 2 (format: *@*.*) URL values: 1 (format: https://*) Value Lengths: -------------- Shortest non-empty values: • "ref" — 3 characters, row 1, column 4 • "call" — 4 characters, row 1, column 1 • "time" — 4 characters, row 1, column 2 • "true" — 4 characters, row 2, column 3 • "true" — 4 characters, row 4, column 3 Longest non-empty values: • "https://mqs.radio" — 17 characters, row 3, column 4 • "confirmed" — 9 characters, row 1, column 3 • "k7@qsl.fm" — 9 characters, row 2, column 4 • "ja@qsl.jp" — 9 characters, row 4, column 4 • "K7HAM" — 5 characters, row 2, column 1
Required options
These options will be used automatically if you select this example.
Comment rows marked with this character are not included in statistics.
Blank rows are not included in statistics.
Keep the first TSV row out of measured cell statistics.
Show row counts, column counts, blank values, and gaps.
Show strings, numbers, booleans, dates, emails, and URL cells.
Show the shortest and longest filled TSV cells.
Show statistics for the columns you choose.
Select columns to analyze by positions, such as "1, 5" or "2-4".
Select columns to analyze by headers, one header per line.
If a header repeats, inspect each matching TSV column.
Review Shadow Theater Columns
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.
cue scene level ready C01 Gate 20 true C02 Lantern 35 true C03 Storm 55 false C04 Curtain 30 true
Column #1: ---------- First value: "cue" Total values: 4 Empty values: 0 Whitespace-only values: 0 Missing values: 0 Values type: string Shortest value: "C01" — 3 characters Longest value: "C01" — 3 characters Column #2: ---------- First value: "scene" Total values: 4 Empty values: 0 Whitespace-only values: 0 Missing values: 0 Values type: string Shortest value: "Gate" — 4 characters Longest value: "Lantern" — 7 characters Column #3: ---------- First value: "level" Total values: 4 Empty values: 0 Whitespace-only values: 0 Missing values: 0 Values type: integer Integer values: 4 Minimum number: 20 Maximum number: 55 Average number: 35 Shortest value: "20" — 2 characters Longest value: "20" — 2 characters Column #4: ---------- First value: "ready" Total values: 4 Empty values: 0 Whitespace-only values: 0 Missing values: 0 Values type: boolean Boolean values: 4 (values: true, false) Shortest value: "true" — 4 characters Longest value: "false" — 5 characters
Required options
These options will be used automatically if you select this example.
Comment rows marked with this character are not included in statistics.
Blank rows are not included in statistics.
Keep the first TSV row out of measured cell statistics.
Show row counts, column counts, blank values, and gaps.
Show strings, numbers, booleans, dates, emails, and URL cells.
Show the shortest and longest filled TSV cells.
Show statistics for the columns you choose.
Select columns to analyze by positions, such as "1, 5" or "2-4".
Select columns to analyze by headers, one header per line.
If a header repeats, inspect each matching TSV 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/analyze-tsv?input=fold%09steps%09level%0Acrane%0918%09hard%0Aboat%0910%09easy%0Astar%0912%09med&comment-char=%23&skip-empty-lines=true&skip-headers=true&print-general-info=true&print-value-types=false&print-value-lengths=false&print-column-analysis=false&use-column-number=true&column-number=1&use-column-name=false&column-name=status&insert-select-all=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!
Change TSV Delimiter
Quickly change the TSV delimiter to a different symbol.
Generate a Random TSV
Quickly generate random TSV data.
Extract a TSV Column
Quickly extract selected columns from a TSV file.
Delete a TSV Column
Quickly delete selected columns in a TSV file.
Delete TSV Tabs
Quickly remove tabs that go between TSV columns and merge all data.
Quote TSV Columns
Quickly add quotes around TSV columns.
Unquote TSV Columns
Quickly remove quotes that surround TSV columns.
Swap TSV Columns
Quickly swap columns in a TSV file.
Sort TSV Columns
Quickly sort TSV data by selected column values.
Convert TSV to JSON
Quickly convert a TSV file to a JSON data structure.
Convert JSON to TSV
Quickly convert a JSON data structure to TSV format.
Convert TSV to XML
Quickly convert a TSV file to XML markup.
Convert XML to TSV
Quickly convert XML markup to a TSV file.
Convert TSV to YAML
Quickly convert a TSV file to YAML markup.
Convert YAML to TSV
Quickly convert YAML data to a TSV file.
Convert TSV to CSV
Quickly convert TSV data to CSV data.
Convert CSV to TSV
Quickly convert CSV data to TSV data.
Convert TSV to Text Columns
Quickly convert TSV data to nicely aligned text columns.
Convert Text Columns to TSV
Quickly convert text columns to TSV columns.
Base64-encode TSV Data
Quickly convert TSV data to base64 encoding.
Base64-decode TSV Data
Quickly convert base64-encoded TSV data to TSV data.
URL-encode a TSV File
Quickly convert a TSV file to URL-encoding.
URL-decode a TSV File
Quickly convert a URL-encoded TSV file back to TSV.
Prepend TSV Columns
Quickly add one or more columns before the first TSV column.
Append TSV Columns
Quickly append new columns at the end of a TSV file.
Insert a TSV Column
Quickly insert new columns anywhere in a TSV file.
Replace a TSV Column
Quickly replace selected columns in a TSV file.
Trim TSV Columns
Quickly remove extra spaces around TSV columns.
Truncate TSV Columns
Quickly truncate the contents of TSV cells to any length.
Convert TSV Cols to Rows
Quickly exchange TSV columns with rows.
Convert TSV Rows to Cols
Quickly exchange TSV rows with columns.
Transpose TSV
Quickly transpose a TSV file.
Analyze TSV
Quickly inspect the structure and contents of a TSV file.
Validate TSV
Quickly check a TSV file for errors and report them.
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.
Created with love by
51K
@browserling
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. Unlike many other tools, we made our tools free, without ads, and with the simplest possible user interface. Our online TSV tools are actually powered by our programming tools that we created over the last couple of years. Check them out!
Secret message
If you love our tools, then we love you, too! Use coupon code TSVLING to get a discount at Browserling.
Privacy Policy we don't log data!
All conversions and calculations are done in your browser using JavaScript. We don't send a single bit about your input data to our servers. There is no server-side processing at all. We use Google Analytics and StatCounter for site usage analytics. Your IP address is saved on our web server, but it's not associated with any personally identifiable information. We don't use cookies and don't store session information in cookies. We use your browser's local storage to save tools' input. It stays on your computer.
Terms of Service the legal stuff
By using Online Tsv Tools you agree to our Terms of Service. TLDR: You don't need an account to use our tools. All tools are free of charge and you can use them as much as you want. You can't do illegal or shady things with our tools. We may block your access to tools, if we find out you're doing something bad. We're not liable for your actions and we offer no warranty. We may revise our terms at any time.