Count Values in TSV Files Online
Group and count rows by any column in TSV files directly in your browser. Sort by frequency or value to find the most common entries — no upload required.
About this tool
Group and count rows in a TSV file by any column. See how many rows share each unique value — sorted by frequency. A fast way to understand the distribution of categorical data.
Frequently Asked Questions
What does the count-by tool do with a TSV file?
It groups rows by the unique values in a chosen column and counts how many rows fall into each group — equivalent to SELECT col, COUNT(*) FROM table GROUP BY col ORDER BY count DESC.
Can I count by multiple columns in a TSV file?
This tool counts by one column at a time. For multi-column grouping use the SQL Query tool or the Aggregate tool, which supports GROUP BY on multiple columns.
How are results sorted in the TSV count-by output?
Results are sorted by count descending by default, so the most frequent values appear first. You can re-sort the output using the Sort tool.
Is my data private?
Yes — completely. Your file is never uploaded to any server. Everything runs locally in your browser using WebAssembly — processing happens entirely inside your tab. Once you close the tab, nothing is retained.
What is the maximum file size?
The free limit is 50 MB. For larger files, performance depends on your device's available memory — most modern machines handle 500 MB to 1 GB comfortably.
Related Tools
Convert TSV to SQL Online
Convert TSV files to SQL INSERT statements directly in your browser. Copy or download the generated SQL — no upload required.
Convert TSV to Markdown Table Online
Convert TSV files to a Markdown table directly in your browser. Copy the output and paste it into any Markdown document.
Convert TSV to HTML Table Online
Convert TSV files to an HTML table directly in your browser. Copy the markup or download a ready-to-use HTML file.
Count Values in CSV Files Online
Group and count rows by any column in CSV files directly in your browser. Sort by frequency or value to find the most common entries — no upload required.
Count Values in Parquet Files Online
Group and count rows by any column in Parquet files directly in your browser. Sort by frequency or value to find the most common entries — no upload required.