Line-based word ranking
Same op as Find most frequent list items and Count list item occurrences - every line is a separate value, counts are tallied, output is `count<tab>item` sorted by frequency.
The word-specific framing assumes one word per line. A line like `apple orange banana` would be counted as the single 3-word string, not as three separate words. To tokenize prose into one-word-per-line input, use Split a list into items on whitespace first.
Case-insensitive by default so `Apple` and `apple` merge. Trim strips leading/trailing whitespace. Sort by Frequency (default) or Alphabetical.
How to use find top words in a list
- 1Paste one word per line into the input panel
- 2For prose input, pre-split with Split on whitespace
- 3Toggle Case sensitive for strict matching (default: off)
- 4Pick Sort by: Frequency or Alphabetical
- 5Output is `count<tab>word` per line
Keyboard shortcuts
Drive ListShift without touching the mouse.
What this tool actually does
Line-based frequency tally, same op as the other counters.
One line = one word
The op counts lines, not words-within-lines. If your input is prose, pre-tokenize with Split before running this.
Frequency-desc default
Most common word first. Ties broken alphabetically for stable output.
Tab-separated output
Each line is `count<tab>word`. Pastes into Excel / Sheets as two columns.
Case-insensitive and trim-aware by default
`Apple`, `apple`, `APPLE` all tally together. ` apple ` matches `apple`.
No stopword filter
Every line (word) is counted including common words like `the`, `and`, `of`. For stopword removal, chain Filter before or after to drop them.
Worked example
One word per line. Output ranked by frequency - ties sorted A-Z.
apple orange banana apple grape banana apple
3 apple 2 banana 1 grape 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 word first | `3\tapple` / `2\tbanana` / `1\tgrape` / `1\torange` |
| Sort by: Alphabetical | A → Z | `3\tapple` / `2\tbanana` / `1\tgrape` / `1\torange` (ties keep alpha order either way) |
| Case sensitive: on | Cased variants separate | `Apple` and `apple` become two entries |
| Input: prose on one line (warning) | Counts the whole line as one "word" | Pre-split with Split first |