Free tool
Count occurrences in a list
Count occurrences in a list: one row per value with how many times it appears, most common first. The value and count are separated by a tab, so they paste into two spreadsheet columns.
The example is loaded. Paste your own list to replace it.
→ 3 lines
Show the top (0 = all)
Treat "Apple" and "apple" as different
Order
Your text
Result
What it does
One row per value with its count, most common first. Pastes into a spreadsheet as two columns.
Settings you can change
- Show the top (0 = all)
- Treat "Apple" and "apple" as different
- Order: Most common first, As they first appear, A to Z
When to use it
You collected the category of 300 products. See which categories are the biggest.
Example: count occurrences in a list
Input
Result
Used in these recipes
Often used with
List each line that appears more than once.
Turn https://shop.example.com/page into shop.example.com.
A to Z, Z to A, or by number.
Your text stays on this computer
Got your list from a web page?
HeyScraper turns the page you’re on into a spreadsheet, so you can skip the copying and pasting. Free: 500 pages a month.
Get HeyScraper