Phone number splitter: country code, area code and number in separate columns
To split a phone number, separate its country calling code, area code, local number and extension. This splitter does it for a whole list: +1 415 555 0132 ext. 12 becomes +1, 415, 5550132 and 12. It reads each country's numbering plan, so numbers written any way split the same, and your other CSV columns are kept.
Used for numbers written without a + country code.
Sample result
(415) 555-0132 ext. 12 splits into +1, 415, 5550132 and extension 12.
- Phone number
- +44 20 7946 0958
- Country code
- +44
- Area code
- 20
What this means for you
Each part lands in its own column, ready for a CRM or dialer that imports them separately.
- Country code, area code, local number, extension
- +1 area codes from the first three digits
- Mobiles have no area code, so it stays empty
- Keeps every other column in a CSV
- Bulk
- CSV
- Area code
By SimpleVerifier Team · Last updated · Runs in your browser; nothing you paste is sent to us
How to split phone numbers into country code, area code and number
- Pick the default country for numbers written without a + code, like
(415) 555-0132. - Paste one number per line, or upload a CSV up to 25 MB; the phone column is found for you.
- Choose whether the local number keeps its spaces, then press Split the numbers.
- Download the CSV: your original columns plus country_code, area_code, local_number, extension, national_number, e164 and country.
Example
- You enter
(415) 555-0132 ext. 12,+44 20 7946 0958and+44 7400 123456, with United States as the default country.- You get
+1/415/5550132/ extension12;+44/20/79460958; and+44with no area code and local number7400123456, because UK mobiles have none. Each row also gets national_number, e164 and country columns.- Limits
- Uploaded files can be up to 25 MB; there is no cap on the number of rows, and it all runs in your browser.
How is the area code worked out?
On +1 (the US, Canada and the other North American Numbering Plan countries) every number is a three-digit area code, a three-digit exchange and four digits, as NANPA describes, so the area code is always the first three digits after the 1.
Elsewhere the splitter uses the way each country's plan groups a landline number in international format, as libphonenumber records it: +44 20 7946 0958 splits into 20 and 79460958, +49 30 901820 into 30 and 901820. Mobiles, toll-free and other non-geographic numbers have no area code, so that column is left empty and the whole number goes in local_number. A few countries, such as Singapore, Hong Kong, Denmark and Norway, have no area codes at all, and their landlines are left whole too.
Why split phone numbers into 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. Splitting by hand with text formulas breaks as soon as numbers are written in different ways; reading the numbering plan doesn't, because (415) 555-0132, 415.555.0132 and +14155550132 are the same number to it.
If your tool wants one column in a single format instead, use the phone number formatter to write every number in E.164.
What happens to extensions and invalid numbers?
Extensions written as ext. 12, x12 or #12 are moved to their own column. Numbers that don't fit their country's plan aren't split, because there is no reliable way to tell where the parts are; their row is kept with a note saying why, such as wrong length for the country.
Is this better than splitting numbers with Excel formulas?
| This splitter | LEFT/MID formulas in Excel | |
|---|---|---|
| Mixed formats | (415) 555-0132 and +14155550132 split the same | Each format needs its own formula |
| International lists | Each country's own grouping | Only works for one fixed layout |
| Extensions | Moved to their own column | Left inside the number |
| Bad numbers | Kept with a reason, not split | Split into wrong parts |
Who uses this tool, and for what?
- CRM admins
- Prepare an import for a system that wants country code and number in separate fields, with the original columns kept.
- Sales ops
- Group a call list by area code to plan local-presence dialing or call times by region.
- SMS teams
- Check which country codes a list holds before choosing sender IDs and routes for each country.
- Data teams
- Normalise numbers typed every possible way into consistent parts before matching them against another table.
What can’t this tool tell you?
- Outside +1, the area code comes from how the country's plan groups a landline number; for countries without area codes the column is empty.
- Mobiles and non-geographic numbers have no area code, so the whole number goes in local_number.
- Numbers that fail the numbering-plan check aren't split.
- It reads the digits only; it can't say a line is connected.
Common questions
- How do I separate the country code from a phone number?
- Paste the numbers here and the country code goes into its own column, read from the + or 00 prefix, or from the default country for numbers written without one. In a spreadsheet, a formula only works if every number is written the same way.
- How do I get the area code from a phone number?
- For US and Canadian numbers it's the first three digits after the country code 1. For other countries the splitter takes the first group of a landline number as the country's numbering plan writes it; mobiles have no area code.
- Does it work for UK numbers?
- Yes.
+44 20 7946 0958splits into country code+44, area code20and local number79460958. A UK mobile like+44 7400 123456has no area code, so the local number is7400123456. - Can I keep the spaces in the local number?
- Yes. Tick the box and the local number keeps the grouping the country uses, such as
7946 0958, instead of digits only. - Is my list uploaded?
- No. Everything runs in your browser using the numbering-plan data, and nothing you paste or upload is sent anywhere.
- Does splitting a number check that it works?
- No. It shows the parts of a number that fits its country's plan. It can't tell you the line is connected or who answers it.
Sources
Well formatted is not the same as reachable.
This tool fixes how numbers are written. It cannot tell you whether a line is mobile, landline or VoIP, or which carrier holds it. That takes a live carrier lookup, which is what the Email + Phone plan adds.
- Upload a CSV up to 100,000 rows with an email or phone column
- 5,000 live carrier lookups a month: carrier name and real line type
- Emails in the same file get a real SMTP mailbox check
One plan, cancel anytime, no contract. Sign in with Google and your first 100 email checks are free, no card. The free tools stay free either way.