How to Find the State for Every Area Code in a List of Phone Numbers
To find the state for every area code in a list, read the three digits after the +1 and look each up in the NANPA table. The bulk area code to state lookup does this for a pasted list or CSV and adds four columns: area code, state or province, country and time zone. It runs in your browser.
What each new column means
The area code is the first three digits after the +1. The state or province is where NANPA, the North American numbering administrator, says that code was issued. The time zone comes from the same table, and where a code covers two zones both are shown. Overlay codes are placed in the same state as the code they overlay.
Step 1: pick the default country
Choose United States or Canada for numbers written without a +1.
Step 2: paste the list
Paste numbers, or upload a CSV and the phone column is found for you. Numbers are read first, so (415) 555-0132, 415.555.0132 and +1 415 555 0132 all give 415.
Step 3: read the new columns
Numbers outside +1, and numbers that fail the format check, are marked and left blank. Caribbean numbers under +1 show the territory or country as the place.
Step 4: download
Download the CSV with your original columns plus the four new ones.
The by-hand way in Excel or Sheets
First reduce each number to plain digits, then take the area code: =MID(B2,2,3) for an 11-digit number starting with 1, or =LEFT(B2,3) for 10 digits. Then look it up against a table of area codes: =VLOOKUP(C2,AreaCodes!A:B,2,FALSE). You need the table, and the NANPA codes change as new ones are added. See how to look up an area code for one at a time, and how to remove dashes and spaces from phone numbers for the clean-up.
Is the state where the person is
Not always. An area code says where a number was first issued. People move and keep their mobile numbers, so for deciding when to call the time zone is a good start, and for an address it is not. To split a list by time zone for a calling window, use the lead list time zone splitter and check hours with the TCPA calling hours checker. For one code at a time, the area code lookup lists cities and overlays.
What this tool cannot do
- An area code shows where a number was issued, not where its owner lives now.
- Where a code covers two time zones, it shows both and cannot say which applies to a person.
- Only +1 numbers get a place. Other countries are marked and left blank.
- The NANPA file changes as codes are added, so very new codes may be missing until the table is updated.
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.
Look up your area codes now
Paste the list into the bulk area code to state lookup.
Common questions
How do I find the state for an area code?
Look the three-digit code up in the NANPA table. For a whole list, a bulk tool reads the area code out of every number and adds the state or province and time zone to each row.
Does the area code show where the person lives?
Not always. It shows where the number was first issued. Mobile numbers keep their code when the owner moves.
Does it work for Canadian numbers?
Yes. Canadian area codes are in the same table and show the province and country.
Why is a number's state blank?
It is not a valid +1 number, or it belongs to another country code. The check column says which.
Does it use carrier data?
No. It uses the public NANPA area code table and the numbering plan, never carrier data.
Check your list before you send
Real mailbox checks over SMTP, and nothing is sent to the address. Sign in with Google and your first 100 email checks are free, no card. Plans for bigger lists are on the pricing page.