Formatting UK Phone Numbers for Your CRM: The E.164 Guide
Open a scraped lead list in Excel and look at the phone column. If the numbers have lost their leading zero, you have met the single most common data quality failure in UK B2B lists.
It happens because UK numbers start with a zero and spreadsheets treat a column of digits as a quantity. 0113 249 6000 is not a quantity. It is an identifier that happens to be made of digits, and the moment Excel decides otherwise, the leading zero is gone and the number is unusable.
The fix is a format called E.164, and it takes about a minute to understand.
What E.164 Actually Is
E.164 is the international standard for phone numbers. A number in E.164 has a plus sign, then the country code, then the national number with any trunk prefix removed. No spaces, no brackets, no hyphens.
For the UK, the country code is 44 and the trunk prefix is the leading 0. So 0113 249 6000 becomes +441132496000. A mobile like 07700 900123 becomes +447700900123.
That is the entire transformation: strip spaces and punctuation, drop the leading 0, prepend +44.
Why It Fixes the Spreadsheet Problem
The leading plus is the important part. Both Excel and Google Sheets treat a value beginning with + as text rather than a number, so the leading digits survive. You are no longer relying on the recipient remembering to set the column type before opening the file.
It also removes ambiguity about where the number lives. A CRM importing 01132496000 has to infer the country from context, and if the record's country field is wrong or empty, the number is unusable for dialling. +441132496000 carries its own country.
Every major CRM expects this. HubSpot, Pipedrive, and Salesforce all store and validate phone numbers most reliably in E.164, and essentially every VoIP dialler and SMS provider requires it outright.
The Cases That Trip People Up
Most numbers convert cleanly. A few don't.
Numbers already in international form. Some scraped listings give you +44 113 249 6000 or 0044 113 249 6000. Detect and normalise these rather than blindly prepending +44, or you will produce +440044... Strip a leading 00 and treat what follows as an international number; if it already starts with +, just remove the spaces.
London and other short-area-code numbers. 020 numbers have a two-digit area code and an eight-digit local number, which trips up naive formatters that assume every UK area code is four or five digits. If you are only converting to E.164 you don't need to know the split — strip the zero and prepend +44 and it works regardless. You only need area code knowledge if you want to display numbers in a pretty national format.
Extensions. "0113 249 6000 ext 204" cannot be expressed in E.164, which has no concept of extensions. Split the extension into its own field. Leaving it in the phone string produces a number no dialler can call.
Non-geographic numbers. 0800, 0845, and 03 numbers convert the same way — drop the leading zero, prepend +44. They are valid E.164. Whether you want to ring an 0845 number is a separate question.
Numbers that aren't numbers. Scraped data occasionally yields "Call us today!" or a fax number in the phone field. Validate length after conversion: a UK E.164 number is almost always 13 characters including the plus, occasionally 12. Anything else needs looking at rather than importing.
Store One Format, Display Another
A useful habit: store the canonical E.164 string, and format it for display only at the point of display.
Your database, your export files, and your CRM's phone field should all hold +441132496000. If a salesperson wants to see 0113 249 6000 on screen, that is a presentation concern. Keeping one canonical form means deduplication works, integrations work, and you never have to reconcile three spellings of the same number.
That canonical form is also what makes phone a usable matching key when you dedupe your lead list — two rows can only be compared on phone number if both are in the same format.
Getting It Right Automatically
LeadSnipe formats UK phone numbers to E.164 as part of the export pipeline, alongside stripping tracking parameters from website URLs and applying a consistent empty-cell rule, so the file you download imports into a CRM without a cleanup pass. The clean CSV export guide covers the rest of that checklist, and the Google Maps scraping guide covers where the numbers come from in the first place.