NewDedupely IntelligenceNow on every paid plan, monthly or yearly.

Format phone numbers to E.164 in bulk

Paste a column of numbers and get E.164 back with the bad ones flagged.

Free for 10 runs a day.

Run every free tool

Tell us who you are once, and every free tool works in this browser.

See our Privacy Policy for how we handle your data.

Thanks. Your tool is running.
Five ways of writing one phone number, (415) 555-0199, 415.555.0199, +1 415 555 0199, 1-415-555-0199, 415 5550199, all formatted to +14155550199.

One phone number written five ways

(415) 555-0199 and +1 415 555 0199 are one line. A CRM compares them as text. The duplicate survives.

This tool rewrites every phone number to E.164 so the copies line up.

Add the country code the import left out

Local numbers arrive with no country code. A dialer or an SMS step rejects them. Each CRM guesses a different country.

Pick a default country and every local phone number gets its code.

UK numbers written without a country code, 020 7946 0958, 07700 900123, 0161 496 0000, formatted to E.164 and international format with United Kingdom as the default country.

Use it from a script or an AI agent

MCP  https://dedupe.ly/tools/mcp   every free tool in one connector (this one: format_phone_numbers)

POST https://dedupe.ly/tools/api/phone-number-formatter
{ "numbers": ["(415) 555-0199", "020 7946 0958"], "defaultCountry": "US" }

Docs https://dedupe.ly/tools/api/openapi.json

OpenAPI document · API index · llms.txt

Questions about phone number formats

The international standard for a phone number: a plus sign, the country code and the number, with no spaces and at most 15 digits. +14155550199 is E.164.

E.164 is digits only after the plus sign. International format adds spaces: +1 415-555-0199. National format is how the number is dialled at home: (415) 555-0199.

The length and format rules of 44 countries. A number with a plus sign from any other country still gets its E.164 form.

Its length does not fit the country, it contains letters, or it is a North American number whose area code or exchange cannot exist.

They are in ranges set aside for films and tests, such as 555-0100 to 555-0199 in North America. A real customer never has one.

Excel reads the column as a number. Import the CSV with that column set to Text, or open the file in a text editor.

A plus sign, the country code and the number, such as +12125550123, with ext and the extension after it.

300 phone numbers a file and ten runs a day, free.

Get started for free

20 free trial merges and as much free support as you need to get your duplicates under control.

Or sign up with Google
  • "Great support. They are on top of things, and answer questions very quickly."

    Larry DPipedrive User

    Pipedrive Marketplace

Running CRM cleanup for clients? See the Partner Program