How to Count How Many Emails Are on Each Domain in a List

To count how many emails are on each domain, take the part after the @ in every address and count how often each one appears. The email domain frequency counter does this for a pasted column or an uploaded CSV or .xlsx, lists each domain with how many addresses it holds and its share of the list, biggest first, and runs in your browser.

It counts where addresses sit. It does not say whether they work.

Why the domain mix of a list matters

A list that is 60 percent one free provider behaves differently from one spread over company domains. A single large domain can be a client you scraped many addresses from, a test import, or a sign-up burst. Seeing the counts first tells you where to look before you spend on verification.

The by-hand way

1. Add a column that cuts the text after the @. In Excel or Google Sheets, =MID(A2,FIND("@",A2)+1,100) does it.
2. Lower-case the result so Gmail.com and gmail.com count together.
3. Build a pivot table with the domain as rows and a count of rows as values.
4. Sort the count from largest to smallest.

That works, but you rebuild it for every export, and rows that are not addresses at all quietly break the formula.

Step 1: load the list

Upload the list as a CSV or .xlsx, or paste the cells with the header row first. It needs a column of email addresses.

Step 2: pick domain or domain ending

Choose to count by domain (gmail.com) or by domain ending (com). Press Count the domains.

Step 3: read and download

The table runs from the biggest domain down, with each share of the list. Rows that hold no readable address are counted separately. Download the counts, or the whole list with a count column.

To split a list into free and company addresses, use the free vs business email filter. To pull the domain out of each address into its own column, use the email to domain extractor.

What this check cannot do

• It counts text after the @. It does not check that the domain exists or takes mail.
• One company can own several domains, and those are counted separately.
• Domain endings show a country or type, not where a person actually lives.
• It needs a column of email addresses; other columns are carried through, not analysed.

For finding domains that cannot take mail, use the bulk MX lookup.

What to do after this

Counting the domains shows where the list sits. Only a mailbox check tells you which addresses are real. The verify page does that part: sign in with Google and the first 100 checks cost nothing. You get valid, risky or invalid per address with the reason, and no message goes to anyone on the list. For a larger file, read about bulk email verification or see pricing.

Try it now

Upload your list to the email domain frequency counter.