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.

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

What is E.164 format?

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.

What is the difference between E.164, international and national format?

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.

Which countries does it know?

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

Why is a number marked invalid?

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

Why are some numbers marked fictional?

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.

Why does Excel drop the plus sign or the leading zero?

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

What phone format does HubSpot want?

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

How many numbers can I format?

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.

"Great support. They are on top of things, and answer questions very quickly."

Larry D

Pipedrive User

Pipedrive MarketplacePipedrive Marketplace

Running CRM cleanup for clients? See the Partner Program

Skip to content