Tab-separated frequency table
Same op as Find most frequent list items - tabulates occurrences via a `Map`, emits one `count\titem` line per unique value. The tab separator means the output pastes directly into a two-column spreadsheet.
Default Sort by Frequency lists `banana (3)` before `apple (2)` before `orange (1)`. Ties are broken alphabetically for stable output. Switch to Alphabetical to see items A-Z regardless of count.
Case sensitive off (default) collapses `Apple` and `apple` into a single entry - the first-seen casing is displayed. Trim on (default) strips whitespace before tallying, so ` apple ` and `apple` count together.
How to use count list item occurrences
- 1Paste your list into the input panel
- 2Toggle Case sensitive to distinguish cased variants (default: off)
- 3Toggle Trim to normalise whitespace before tallying (default: on)
- 4Pick Sort by: Frequency (default, most-common first) or Alphabetical
- 5Output is `count<tab>item` per line - paste into a spreadsheet
Keyboard shortcuts
Drive ListShift without touching the mouse.
What this tool actually does
Map-based frequency tally with three options.
Tab-separated `count<tab>item` output
Each unique value emits one line: count, tab, item text. Pastes cleanly into Excel / Sheets as two columns.
Frequency-desc default with alphabetical tiebreak
Most common first. Ties sorted A-Z among themselves for stable output.
Case-insensitive by default
`Apple` and `apple` count together. First-seen casing is displayed. Toggle Case sensitive on for strict matching.
Trim-aware by default
`Apple` and ` Apple ` merge into one entry. The tallied key is the trimmed form; the displayed text is the first-seen trimmed value.
Blank lines skipped
Empty or whitespace-only lines are not tallied. You will not see an empty-string entry in the output.
Worked example
Six lines, three unique values. `banana` appears three times so it tops the output.
apple banana apple orange banana banana
3 banana 2 apple 1 orange
Settings reference
How each option shapes the output using the sample above.
| Setting | What it does | Effect on the sample |
|---|---|---|
| Sort by: Frequency (default) | Most common first, alphabetical tiebreak | `3\tbanana` / `2\tapple` / `1\torange` |
| Sort by: Alphabetical | A → Z by item name | `2\tapple` / `3\tbanana` / `1\torange` |
| Case sensitive: on | Cased variants separate | First-seen casing would no longer merge mixed-case inputs |
| Trim: off | Whitespace counts as distinctive | ` apple` and `apple` become two entries |