Count Values in Excel Files Online
Group and count rows by any column in Excel 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 Excel 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 Excel 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 Excel 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 Excel 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
Bin Column in Excel Files Online
Bucket a numeric column in Excel files into labelled ranges — equal-width bins or custom edges. Runs entirely in your browser.
Add Calculated Column to Excel Files Online
Add a new column to Excel files computed from an arithmetic expression over existing columns. No formulas, no code — just point and click.
Extract JSON Column from Excel Files Online
Extract values from a JSON-encoded column in Excel files into a new flat column using a JSON path expression. Runs in your browser.
Calculate Date Difference in Excel Files Online
Calculate the difference between two date or timestamp columns in Excel files directly in your browser. Output in days, months, years, hours, minutes, or seconds — no upload required.
Normalize Columns in Excel Files Online
Normalize numeric columns in Excel files using min-max scaling (0–1) or z-score standardisation (mean=0, std=1). Adds new columns alongside the originals — no upload required.