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.
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
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
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.
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.
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.
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 see | International | Readable |
|---|---|---|
| 020 7946 0000 (London) | +442079460000 | 020 7946 0000 |
| 0161 496 0321 (four-digit area code) | +441614960321 | 0161 496 0321 |
| 01632 960123 (five-digit area code) | +441632960123 | 01632 960123 |
| 07700 900456 (mobile) | +447700900456 | 07700 900456 |
| 0800 123 4567 (freephone) | +448001234567 | 0800 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