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.
How to count Values in Excel files
- Drop your file onto the upload area. The row count is shown and the first column is pre-selected.
- Choose a column in the Group by column list.
- Pick a sort order: Count (high → low), Count (low → high) or Value (A → Z).
- Click Count. The result has two columns, value and count, and the heading shows how many distinct values were found.
- Click Download to save the counts in the same format you uploaded, with _countby added to the file name.
Your file is processed locally in your browser and is never uploaded. The free limit is 50 MB per file; larger files work if your device has the memory for them.
Worked example
A city bike-share scheme wants to know which docking stations trips start from most often. A few trips from a faulty dock have no start station recorded.
Input (Excel)
Excel workbook, first sheet (Sheet1)
| trip_id | start_station | duration_min | rider_type |
|---|---|---|---|
| 5001 | Quay St | 12 | member |
| 5002 | Park Rd | 25 | casual |
| 5003 | Quay St | 8 | member |
| 5004 | NULL | 17 | casual |
| 5005 | Quay St | 31 | casual |
| 5006 | Park Rd | 9 | member |
Settings
- Group by column: start_station
- Sort by: Count (high → low)
Result
| value | count |
|---|---|
| Quay St | 3 |
| Park Rd | 2 |
| NULL | 1 |
Six trips collapse to three groups. Quay St has three trips, Park Rd two, and the trip with no station forms its own group with a null value. Missing values are counted, not dropped, so the counts always add up to the total row count. The output columns are always named value and count, whatever the source column was called.
Working with Excel files
This does what a pivot table with one row field and a count of records does, without building one. Counting is done on the values as the first sheet displays them. Two cells showing 5% and 0.05 are different text, so they form separate groups.
Blank cells in the chosen column form one group with an empty value. Spacer rows and trailing empty rows inside the used range add to that group, so a surprisingly large blank count usually means the sheet has empty rows. The downloaded workbook has one sheet, Sheet1, with value and count columns that you can chart straight away in Excel. On sheets with hundreds of thousands of rows, this is often quicker than a pivot table. Formula cells are counted by their saved results. If the workbook was last saved before a recalculation, the counts reflect the old values.
Frequently Asked Questions
Is this the same as a COUNTIF or pivot table in Excel?
It gives the same result as a pivot table with the column as a row field and a count of records. It covers every distinct value at once, so you do not need one COUNTIF per value.
Why is there a large blank group in my Excel count?
Empty cells are counted as one group, including cells in blank rows inside the sheet's used range. Remove the empty rows or filter them out before counting.
Can I count by more than one column?
No. The tool groups by one column. For combinations of columns, use the Aggregate tool or the SQL Query tool with GROUP BY on several columns.
How are ties ordered when sorting by count?
Values with the same count have no fixed order between them. Choose Value (A → Z) if you need a stable, alphabetical order.
Does the on-screen table show every value?
The on-screen table shows the first 500 groups. The heading still gives the full number of distinct values, and the downloaded file contains every group.
Related Tools
Add Percent of Total to Excel Files Online
Add a percentage-of-total column to Excel files directly in your browser. Show each row's share of the grand total, or the share within each group — no upload required.
Sort Excel Files Online
Sort Excel files by any column, ascending or descending, directly in your browser.
Extract Unique Values from Excel Files Online
Extract all distinct values from any column in Excel files directly in your browser. Download the unique values list — no upload required.
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.
Count Values in JSON Files Online
Group and count rows by any column in JSON files directly in your browser. Sort by frequency or value to find the most common entries — no upload required.
Excel Viewer Online
View and inspect Excel files directly in your browser. Browse rows, check column names and data types — no upload required, your data stays on your device.
Convert Excel to Parquet Online
Convert Excel files to Parquet format directly in your browser. No upload required — your data never leaves your device.