Map Extract
Free tool

Format a list of phone numbers to +44 and readable UK style

Lead lists collect phone numbers in every possible shape: 0161-496-0321, +44 (0)161 496 0321, 0044 161 4960321, or a mobile with no spaces at all. Paste them here, one per line, and get every number in two consistent forms, international E.164 for your CRM, dialler or WhatsApp and the familiar spaced UK form for people to read.

Runs in your browser. Nothing you enter is uploaded.

Example: cleaning the phone column of a scraped list

A web designer pulled together a list of local businesses from several sources and the phone column was a mess. She pasted the numbers with Numbers are from set to United Kingdom.

Eight of nine were formatted. The (0) that people add after +44 was dropped, 0044 was treated as +44, and the extension on one number was left out, so she noted it separately. The five-digit line was not a phone number and was marked as not recognised.

Input
01614960321
+44 (0)20 7946 0000
07700 900456
0044 113 496 0999
0800 123 4567
tel: 0161-496-0000 ext 12
01632 960123
12345
(0)7700900123
Result
8 of 9 formatted.

Input                        International    Readable
01614960321                  +441614960321    0161 496 0321
+44 (0)20 7946 0000          +442079460000    020 7946 0000
0044 113 496 0999            +441134960999    0113 496 0999
tel: 0161-496-0000 ext 12    +441614960000    0161 496 0000
12345                        Not recognised

Formatting your numbers

  1. Paste one number per line

    Copy the phone column from a spreadsheet and paste it straight in. Spaces, dashes, dots, brackets and labels such as tel: are ignored.

  2. Say where the numbers are from

    Choose the country used for numbers written without a country code: United Kingdom, Ireland, United States, Australia, France or Germany. Numbers already starting with + or 00 keep their own country.

  3. Check the table

    The counter shows how many were formatted. Each row gives the input, the international form and the readable national form, with Not recognised where a line could not be a valid number.

  4. Copy or download

    Copy +44 format copies just the international numbers. Download CSV gives input, international and readable columns so you can paste them back next to the original data.

UK number shapes this handles

You might seeInternationalReadable
020 7946 0000 (London)+442079460000020 7946 0000
0161 496 0321 (four-digit area code)+4416149603210161 496 0321
01632 960123 (five-digit area code)+44163296012301632 960123
07700 900456 (mobile)+44770090045607700 900456
0800 123 4567 (freephone)+4480012345670800 123 4567

Why +44 without the zero

The 0 at the start of a UK number is the trunk prefix, used only when dialling within the UK. From abroad, or in the international E.164 format that phone systems, CRMs and messaging apps store, it is replaced by the country code 44. That is why +44 (0)161 is a common mistake: dialled literally it includes a 0 that should not be there. Store the international form and show the spaced national form to people.

Keeping the + in a spreadsheet also stops Excel treating the number as a sum and stripping the leading zero, which is the commonest way phone columns get damaged.

Questions people ask

How do I convert UK phone numbers to +44 format?

Paste them here one per line with the country set to United Kingdom. The leading 0 is removed and +44 put in its place, so 07700 900456 becomes +447700900456. Copy the results or download a CSV. In a spreadsheet you could do the same with a formula, but it gets fiddly with brackets, spaces and numbers that already have +44.

What is E.164 format?

E.164 is the international numbering standard used by phone networks. Written down, a number in this form begins with + and the country code, followed by the rest of the number without its trunk 0 and without spaces or punctuation, up to 15 digits. CRMs, diallers, SMS services and WhatsApp generally expect it.

What happens to extensions?

They are not kept. A number such as 0161 496 0000 ext 12 is formatted as the main number only, because E.164 has no place for an extension. If extensions matter for your calls, keep them in a separate column before formatting.

Does it check whether a number is actually in service?

No. It checks that the number has a valid shape and length for the country and rewrites it consistently. Whether it is connected, who owns it or whether it is on the TPS or CTPS registers are separate questions; the TPS and CTPS can be checked through a licensed screening service before marketing calls.

Where your data goes

The numbers are parsed and reformatted by code running on this page. Nothing is uploaded or looked up, so a list of customer or prospect phone numbers never leaves your browser.

Checked against the tool on

Top