How to Count Phone Numbers by Country in a List

To count phone numbers by country, read each number against its country's numbering plan and tally the results. The phone list country breakdown does that for a pasted list or CSV and shows a table of countries with calling codes, counts and each share of the list. It runs in your browser.

What the breakdown shows

One row per country: the calling code, how many numbers, and the share of the whole list. The last row groups every number that failed the format check, so the shares add up to the full list and you can see how much of it needs fixing. A second download adds country, calling code, E.164 and a format status to every row of your own file.

Step 1: pick the default country

Numbers written without a + code are counted in the default country you pick. (415) 555-0132 is a US number unless you choose another country. Numbers that start with a + ignore it.

Step 2: paste the list

Paste numbers, or upload a CSV and the phone column is found for you.

Step 3: read the table

Countries are sorted by size. Look at the failed-format row too: a large share there usually means cut-off cells or the wrong default country.

Step 4: download

Download the summary, or the file with a country column added to every row.

How the country is found

The tool reads each number with Google's libphonenumber data. Where several countries share a calling code, as the US, Canada and Caribbean nations do under +1, the area code decides. A few codes belong to no country, such as international toll-free numbers under +800, and are grouped as global service numbers.

The by-hand way in Excel or Sheets

With clean E.164 numbers in column A, you can count by prefix: =COUNTIF(A:A,"+44*") counts numbers starting +44. It works for one code at a time, but calling codes run from one to three digits and +1 covers many countries, so it needs a table of codes and gets unreliable on a mixed list. Clean the column first with how to format phone numbers in Excel and read how to find what country a phone number is from.

What to do with the result

A breakdown sizes a list before you plan around it: which countries need a local sender, which time zones to call in, whether a campaign meets the rules of every country on the list. For one file per country, use the phone list segmenter. For a single odd row, use the phone number country lookup. If a country is a surprise, look at the rows before deciding, since a wrong default country is the usual cause.

What this tool cannot do

• The country is where the number was issued, not where its owner lives or is now.
• Numbers without a + code are counted in the default country.
• Numbering plans change, so recently opened ranges can show as not valid until the data is updated.
• It counts and does not split. Use the segmenter for files.

Does a well-formed number mean it is active

No. Nothing here contacts a phone network, so a number that passes is only well formed. If the same list has email addresses, check them on the verify page: the first 100 email checks are free with a Google sign-in, no card. Each comes back valid, risky or invalid with a reason, and nothing is sent to anyone on the list. For larger or recurring lists, see bulk email verification, list cleaning and pricing.

Count your list now

Paste it into the phone list country breakdown.