How to Split Phone Numbers into Country Code, Area Code and Number
To split a phone number, separate its country calling code, area code, local number and extension. +1 415 555 0132 ext. 12 becomes +1, 415, 5550132 and 12. The phone number splitter does that for a whole list or CSV and keeps your other columns.
It reads each country's numbering plan, so (415) 555-0132, 415.555.0132 and +14155550132 split identically.
When you need separate columns
Some CRMs, dialers and SMS platforms import the country code and the rest of the number as separate fields, and some reports group by area code. If your platform wants one clean column instead, see formatting phone numbers in Excel or cleaning phone numbers in a CSV.
The by-hand way
- Strip spaces, dashes and brackets into a helper column.
- For US numbers, take the first three digits after the 1 as the area code.
- For other countries, look up how the plan groups a landline, and split there.
- Move
ext.,xor#suffixes into their own column.
Steps 1 and 2 are easy with text formulas. Steps 3 and 4 are where mixed lists break them.
Step 1: pick a default country
This applies to numbers written without a + code.
Step 2: paste or upload
Paste one number per line, or upload a CSV up to 25 MB. The phone column is found for you.
Step 3: split and download
Choose whether the local number keeps its spaces, press Split the numbers and download the CSV. On +1 numbers the area code is always the first three digits after the 1; elsewhere it follows how the country's plan groups a landline, so +44 20 7946 0958 gives 20 and 79460958.
What this check cannot do
- Outside +1, the area code comes from how the plan groups a landline; countries without area codes leave the column empty.
- Mobiles and non-geographic numbers have no area code.
- Numbers that fail the numbering-plan check are not split.
- It reads digits only and cannot say a line is connected.
For one clean E.164 column, use the phone number formatter.
Next: verify the emails on the same list
Splitting does not tell you whether the contact is reachable by email. Upload the email column at the verify page: the first 100 email checks are free with a Google sign-in, no card, and each result is valid, risky or invalid with a reason. For bigger lists, see bulk email verification and pricing.
Try it now
Open the phone number splitter.
Common questions
How do I split a phone number into parts?
Separate the country calling code, area code, local number and extension. The splitter does this for a list and reads each country's numbering plan, so numbers written any way split the same.
What does +1 415 555 0132 ext. 12 split into?
+1, 415, 5550132 and 12.
Do mobiles have an area code?
Not in the split. Mobiles and other non-geographic numbers leave the area code empty and the whole number goes in local_number.
What happens to invalid numbers?
They are not split, because there is no reliable way to tell where the parts are. The row is kept with a note saying why.
Which columns do I get back?
Your original columns plus country_code, area_code, local_number, extension, national_number, e164 and country.
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.