Display TSV Statistics

Display TSV statistics instantly. Paste or upload TSV data and get row counts, unique values, and numeric summaries per column in real time.

Paste your input above or import a file below.
No file chosen
Supported file types: .tsv, .txt
Total rows: 0
Options
Trim each cell
Maximize output

How to Use:

  • Paste your TSV data into the Input TSV box or upload a .tsv or .txt file using Choose File.
  • Enable Trim each cell to remove extra whitespace from all fields before analysis.
  • Toggle Maximize Output if you need more space to view the statistics.
  • Click Analyze to generate the column-by-column statistics.
  • Use Copy Output to copy the results or Export to File to download the report as a .txt file.
  • Click Clear All to reset the tool, including all fields and toggles.

What Display TSV Statistics can do:

Display TSV Statistics gives you a quick overview of the contents of a tab-separated dataset. It shows you how many rows and columns are present and analyzes each column for uniqueness and numeric values. You’ll see the minimum, maximum, and average for each numeric field, and the number of unique values for all columns. It’s great for getting a feel for the shape of your data without needing a spreadsheet or script.

Example:

Input:

id	name	age	income
1	Alice	30	60000
2	Bob	25	52000
3	Alice	30	60000
4	Dana	40	70000

Output:

Total rows (excluding header): 4
Total columns: 4

Column "id":
  Unique values: 4
  Min: 1
  Max: 4
  Avg: 2.50

Column "name":
  Unique values: 3
  Min: N/A
  Max: N/A
  Avg: N/A

Column "age":
  Unique values: 3
  Min: 25
  Max: 40
  Avg: 31.25

Column "income":
  Unique values: 3
  Min: 52000
  Max: 70000
  Avg: 60666.67

Common Use Cases:

Use Display TSV Statistics when you’re inspecting logs, user data, exports, or survey results. It helps you quickly understand structure, spot duplicates, and catch outliers. Whether you’re cleaning data or preparing for import, this tool offers fast, browser-based insight.

Useful Tools & Suggestions:

After checking things out with Display TSV Statistics, Count TSV Rows gives you a quick number check across the file. And if something seems off, Filter TSV Data lets you zoom in on just the parts that matter.

Related Tools