Online Tool Store
Frequency Table Maker
Paste a list and get a sorted count, percent, and cumulative running total for each unique value, with a choice of sort order and CSV export.
🔒 This tool runs entirely in your browser. Your files are never uploaded to a server.
| Value | Count | Percent | Cumulative count | Cumulative % |
|---|
Cumulative columns run down the table in its current sort order — they are not tied to any fixed category order.
How it works
- Paste a list of values, one per line or separated by commas.
- Each unique value is counted, with a running cumulative count and cumulative percent alongside it.
- Toggle case-insensitive matching if "Apple" and "apple" should count as one value.
- Choose a sort order — most frequent, least frequent, or alphabetical — then copy the table or download it as a CSV.
The formula
Percent = (count of this value ÷ total number of values) × 100, rounded to one decimal place. Cumulative count and cumulative percent are running totals down the table in its current sort order, computed from the running count itself so the last row always reaches exactly 100% — not by adding up the already-rounded percentages, which can drift a fraction of a point short.
FAQ
What input formats work?
One value per line, or a comma-separated list — both are parsed the same way, and blank entries are ignored.
What does case-insensitive do?
When enabled, "Apple" and "apple" are counted as the same value; the table still shows whichever spelling appeared first.
How is percent calculated?
Each value's count divided by the total number of entries, shown to one decimal place.
How is the cumulative count and cumulative percent calculated?
Each row adds its own count (or percent) to a running total of every row above it, in whatever order the table is currently sorted in. Changing the sort order changes which values the cumulative total runs through, so the last row always reaches the full total and 100%.
Can I change how the table is sorted?
Yes — sort by most frequent first (the default), least frequent first, or alphabetically, using the Sort by control above the table.
Can I export the table?
Yes — "Copy table" copies it as tab-separated text ready to paste into a spreadsheet, and "Download CSV" saves it as a .csv file.
Is my list sent anywhere?
No — counting happens with a JavaScript Map, entirely in your browser as you type.
How we compare
| Feature | Online Tool Store | HackMath.net | StatsCalculators.com | Spreadsheet COUNTIF |
|---|---|---|---|---|
| No formulas to write | ✓ | ✓ | ✓ | ✗ |
| Instant, sorted results as you type | ✓ | requires clicking Calculate | requires clicking Generate | ✗ |
| Cumulative count and percent | ✓ | ✓ | ✓ | Manual formula |
| Choice of sort order | ✓ | Not stated | ✓ | Manual |
| Copy or download the result | ✓ | Not stated | sign-up required to export | it's already a spreadsheet |
If you just need "how many times does each value appear," with a running cumulative total, and without opening a spreadsheet or creating an account, pasting the list here is faster than writing a formula.