@leadsfreshdb Sign in 0

Reference · formats

Phone number formats in Europe

· 3 min read · Leads Fresh DB

Half the problems with a phone list are not about the people on it but about how the numbers are written. One wrong zero and a sending tool rejects the number — or, worse, sends to someone else.

The international format: E.164

Sending platforms expect numbers in E.164, the international standard: a plus sign, the country code, then the national number without the leading 0 ("trunk prefix") that people dial at home. No spaces, no dashes, no brackets, and never more than 15 digits in total. A UK mobile written 07700 900123 at home becomes +447700900123.

Mobile formats in our six countries

CountryCodeMobile at homeInternational
United Kingdom+4407xxx xxxxxx+44 7xxx xxxxxx
Netherlands+3106 xxxxxxxx+31 6 xxxxxxxx
Denmark+45xx xx xx xx (no 0, no area codes)+45 xxxxxxxx
Italy+393xx xxx xxxx (no 0 for mobiles)+39 3xx xxx xxxx
Portugal+3519xx xxx xxx+351 9xx xxx xxx
Austria+4306xx … (length varies)+43 6xx …

Spaces in the table are only for reading — the file should have none.

The mistakes we see most

  • Keeping the 0: +4407700… or +3106… are invalid. Drop the 0 after the country code.
  • Italy is the exception: Italian landlines keep their 0 after +39 (Rome is +39 06…), mobiles have none. Do not "fix" one rule onto the other.
  • Spreadsheets eating numbers: open a list in Excel and +447700900123 can turn into 4.477E+11, losing the plus and digits. Import the column as Text, or open the TXT file in a text editor instead.
  • Mixed formats: the same number written twice — once +31 6…, once 06… — slips past duplicate checks. Normalise first, then de-duplicate.
  • Austria's variable length: Austrian mobile numbers are not all the same length, so a "fixed length" filter will throw away good numbers.

Cleaning a list in four steps

  1. Remove everything that is not a digit or a leading plus.
  2. Add the country code where it is missing, removing the national 0.
  3. Check the result starts with the right country code and mobile prefix (+447, +316, +393, +3519, +436; Danish mobiles start with several digits, so check the length: 8 after +45).
  4. Remove duplicates — and remove everyone on your opt-out list.

Storing numbers in your own systems

Keep every number in your CRM or database as text, in E.164, never as a numeric field — a number type drops the plus and can round long values. Store the country in its own column so you can filter and apply the right rules per market, and keep the "pretty" format with spaces only for display. When you import a new list, normalise it first and check it against what you already have, so the same person is never messaged twice from two lists.

How our files come

Every list is delivered as a TXT file, one number per line in international format (+447…, +316…, +4520…), ready for any sending tool — CSV on request. No cleaning needed; just keep it away from spreadsheets that reformat numbers.

Questions & answers

What is the E.164 format?

The international phone number standard: a plus sign, the country code and the national number without its leading 0, with no spaces or symbols and at most 15 digits — for example +447700900123.

Why does Excel change my phone numbers?

Excel treats long numbers as numeric values, drops the plus sign and may show them in scientific notation. Import the column as text, or open the file in a text editor.

Do Italian mobile numbers start with 0?

No. Italian mobiles start with 3 (+39 3…). Only Italian landlines keep their 0 after the country code.

More guides

Write a message that gets replies

Character limits, structure, wording and calls to action for marketing texts — with a before-and-after example and the mistakes that make people ignore or report a message.

3 min read

Telegram sellers vs a lead shop

An honest comparison of buying phone lists from anonymous Telegram sellers and from a shop with a filtered, accountable process — price, quality, proof, payment and what to ask before you pay anyone.

3 min read

Filtered leads vs bulk lists

Bulk lists look cheaper per number; filtered lists often cost less per customer. A worked example, the hidden costs of sending to the wrong people, and when a bulk list is still the right call.

3 min read

SMS & phone marketing rules in Europe

What the UK, the Netherlands, Denmark, Italy, Portugal and Austria expect before you text or call people for marketing — consent, do-not-call registers and the regulators, in plain English.

3 min read

Fresh vs old phone lists

Why phone lists lose value every month, the signs of a tired or resold list, and a simple way to test any list before you spend money on a campaign.

3 min read

What is RCS messaging?

RCS explained: what rich messages can do that SMS cannot, which phones support them, what a business needs to send them, and when an RCS-ready list is worth it.

3 min read

Reaching seniors 55+ by message

Which offers work for people over 55, how to write a message they trust, when to send it, and the mistakes that get campaigns ignored or reported.

3 min read

Reaching small businesses by message

How to sell to shops, salons, garages and cafés by text: which offers work, how to write a B2B message owners answer, when to send, and the rules that still apply.

3 min read