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.

1
Count how often each line appears

→ 3 lines

Show the top (0 = all)

Treat "Apple" and "apple" as different

Order

Your text

6 lines

Result

3 lines

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.

All free tools

Your text stays on this computer
The list editor works on your computer. The text you paste or open is not uploaded or stored by HeyScraper, and closing the page clears it. Saved recipes are kept in this browser only.

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