CallerHub
EN
Download

Phone numbers in E.164 format and readable caller names

The same number is written differently in every system: 030/23125456, +49 30 23125456, 00493023125456. For a call to find the right name, all notations must be brought into one common form – the international E.164 format.

What E.164 means

E.164 is the international numbering plan of the ITU (Recommendation ITU-T E.164). A number in this format starts with + and the country code, followed by the national number without the leading trunk prefix and without spaces or special characters; at most 15 digits in total.

Stored asCountryE.164
030 / 23 12 54 56Germany+493023125456
+49 (0)40 66969000Germany+494066969000
044 000 45 67Switzerland+41440004567
06 0000 6789Italy+390600006789 (the 0 remains part of the number)

Typical pitfalls in data sets

  • Foreign numbers without a country code, such as “044 000 45 67” for a customer in Zurich.
  • “(0)” between country code and area code, hyphens before the extension, slashes and brackets.
  • Several numbers in one field, e.g. “Tel. 030 23125456, mobile 0171 3920012”.
  • Saved as a number in Excel: the leading 0 disappears and long numbers turn into 4.91753E+11.

With CallerHub: normalise numbers without changing the data

CallerHub normalises every number when loading the data source and for every call. Your database stays as it is.

  • Remove characters: spaces, hyphens, slashes, brackets and “(0)” are dropped; + and 00 mark international numbers.
  • Country per row: a column land (country) may contain ISO codes (CH, AT, DEU), vehicle registration codes (D, A, FL), country codes (41, +41, 0041) or common country names. Without a country, the configured country code applies, e.g. 49.
  • Trunk prefix per country: usually 0; none for example in Italy, Spain, Portugal and Poland; 1 in North America, 06 in Hungary, 8 in Russia and Kazakhstan.
  • Numbering plan for over 240 countries: with the libphonenumber library, CallerHub recognises the type (landline, mobile, special number), the area, e.g. “Stuttgart (0711)”, and for foreign numbers the local time at the caller’s location.
  • Several numbers in one field: CallerHub takes each valid number separately (database, REST, LDAP, Microsoft 365, Exchange).
Call analytics · Calls by area
Table Calls by area with place, area code, calls, reachability and service level (test data).

Check and maintain

Check number shows a number as CallerHub searches for it (e.g. +494066969000), with national format and country, and for each data source whether it matches and which name appears on the phone system. When each data source is loaded, the log reports how many numbers are invalid according to the numbering plan, with examples; unknown country values appear as a warning.

Caller names that fit the display

Desk phones often show only a few characters. The name should therefore put the most important part first and stay short.

SettingExampleEffect
Display name from several fields{Company} || {First name} {Last name}company, otherwise the person’s name
Rank for duplicate numbers0 = company, 1 = contact personthe lower rank wins
ReplacementsGmbH & Co. KG;GmbH & Co.shortens names for narrow displays
Prefix before the name (per source)ERP:shows which source the name comes from
VIP list with text before the name030 23125456;Sample Ltd head office, text ★highlights important callers
Block list+49900*no name or a custom name for blocked numbers
Max. name lengthAdministration → Advancedshortens names that are too long

Responses to the phone system are UTF-8. If umlauts or accents appear wrong, check the character set of the phone system. In reports, CallerHub shows numbers in a readable form and, with a known base number, with the extension after the hyphen, e.g. +49 40 66969-930.

Frequently asked questions

Do I have to convert my database to E.164?

No. CallerHub normalises the numbers when loading and for every call. The phone system may also send the number in any notation (national, +49, 0049, with spaces).

What happens to numbers without a country code?

If the source provides a country column, it applies per row. Otherwise CallerHub uses the configured country code, e.g. 49 for Germany.

Why is the name cut off on the phone?

The display is narrower than the name. Shorten it with replacements (e.g. “GmbH & Co. KG” to “GmbH & Co.”) or limit the length under Administration → Advanced → Max. name length.

Try it

Test it with your own data.

Try the full edition for 30 days: choose “Request trial …” in CallerHub and the trial key arrives by e-mail. The setup wizard guides you through data source, phone system and test lookup. After that, CallerHub continues as the free basic edition without losing settings or data.