Formato E.164: como limpar listas de telefones para um discador
How to convert a call list to E.164: strip trunk zeros and exit codes, stop spreadsheets mangling numbers, validate with libphonenumber, match DNC exactly.
Resposta rápida
E.164 format is a plus sign, the country code and the national number, with no spaces, punctuation or trunk zero. To convert a call list, parse each number against its country, format it as E.164 with a library such as libphonenumber, and keep the column as text so a spreadsheet cannot strip the plus or the zeros. Store E.164 everywhere, so de-duplication and do-not-call matching compare like with like.
Most failed list imports have nothing to do with the dialer. The list had the same person three times in three formats, a column of numbers that a spreadsheet quietly rewrote, or a mix of national and international numbers with no country attached. A clean, uniform number format fixes all of these before the first call.
This guide shows how to convert a call list to E.164, why a spreadsheet damages numbers, how to validate them properly, and why one format matters for de-duplication, do-not-call suppression and consent records. It applies to any dialer and any country.
What E.164 is
E.164 is the ITU-T recommendation that defines the international public telecommunication numbering plan. The ITU lists the 02/26 edition as in force (ITU-T, checked November 7, 2026). In everyday list handling, "E.164 format" means a number written in its global form: a plus sign, the country code, then the national significant number.
The plus sign is not decoration. RFC 3966, which defines the tel URI, says globally unique numbers are identified by the leading "+" and are built from the country code and the national number (section 5.1.4). It also says visual separators such as hyphens, dots and brackets only aid readability and are not used for comparing numbers or placing a call, and that a tel URI must not use spaces as separators (section 5.1.1). So the form you want to store is +, then digits, with nothing else.
E.164 versus how people write numbers
People write numbers for their own country and their own habits. The same subscriber can arrive in a list in several forms:
| As written | What it is | Problema |
|---|---|---|
0NNN NNN NNN | National format with a trunk prefix and spaces | No country; the trunk zero is not part of the global number |
00 CC NNN NNN NNN | International with an exit code | The exit code is a dialling habit of the caller's country, not part of the number |
+CC (0) NNN NNN NNN | International with the trunk zero left in | The bracketed zero must go; it is not part of the global number |
+CCNNNNNNNNN | E.164 | None. This is the target. |
All examples use placeholders, CC for the country code and N for digits. The libphonenumber documentation gives a real, worked case: a Swiss number written 044 668 18 00 and parsed for the region CH gives country code 41 and national number 446681800. Formatted as E.164 it becomes +41446681800; formatted for dialling from the United States it becomes 011 41 44 668 1800 (libphonenumber README, checked November 7, 2026). Notice what happened: the leading zero is gone, the country code is added, and the exit code 011 belongs to the calling country in the example (the United States), not to the number. That is why a list needs the number's own country, not just the digits.
Spreadsheet traps
Opening a list in a spreadsheet and saving it again is a common way to break it. Microsoft's Excel documentation says Excel automatically removes leading zeros, converts large numbers to scientific notation such as 1.23E+15, and keeps at most 15 significant digits (Microsoft Support, checked November 7, 2026). Three failures follow from that:
- Lost leading zeros. A cell of digits is treated as a number, and a number has no leading zero. National-format values lose it silently, which turns a valid national number into a different, wrong one.
- Scientific notation. Long digit strings can be converted to exponent form. If the file is saved while the column looks like that, check that the full numbers survived before you use it.
- A stripped plus sign. A value starting with a plus can be read as a number rather than text, and the plus is dropped, leaving digits that look like a national number.
Safer habits:
- Set the phone column to Text before pasting or importing, not after. Microsoft notes that the Text format does not change numbers already entered.
- When opening a CSV, import it with the phone column marked as text instead of double-clicking the file.
- Check the saved file in a plain-text editor, and look at the raw phone column, not the spreadsheet view.
- Keep an untouched copy of the original export so you can re-run the clean-up.
- Do the conversion in a script or a dedicated tool where possible, and use the spreadsheet only to look.
Validate with libphonenumber, not a hand-written regex
Number plans differ by country, change over time, and carry rules about length and prefix that no short regex captures. A pattern that fits one market rejects real numbers in another or accepts junk. Use a maintained library instead. One widely used option is Google's libphonenumber; its README describes parsing, formatting and validating phone numbers for all countries and regions, with a quick isPossibleNumber check based on length alone and a full isValidNumber check that uses length and prefix information for a region (libphonenumber README, checked November 7, 2026). It also has a function, isNumberMatch, that gives a confidence level on whether two numbers could be the same.
A reliable pipeline looks like this:
- Know the region. Take it from a country column or the list's origin. If a list mixes countries and some numbers lack a plus sign, flag those rows for review instead of guessing.
- Parse each value with that region as the default. Numbers that already begin with a plus carry their own country.
- Check possibility first, then validity. Route failures to a reject file with a reason column.
- Formatar valid numbers as E.164.
- Keep the original value in a separate column, so the source can be traced.
An illustrative worked example, using placeholders, for a list of 1,000 rows (the counts are an example, not a benchmark): 940 parse and validate, 35 fail length checks, and 25 have no country and no plus sign. The 940 are formatted. The 60 others go to a review file with a reason, and nobody dials them until someone has looked.
Why one format matters
- De-duplication. Three spellings of one number are three records until you normalise them. Duplicates mean double calls to the same person, and double counting in reports.
- DNC suppression. Suppression compares numbers exactly. A DNC file in E.164 will not match a list in national format, and the suppressed person gets called. Normalise both sides first. The basics are in O que é o DNC?, and the rule setup is in Como definir horários de chamada, DNC e regras de consentimento.
- Consent records. A consent or opt-out record is only useful if it can be found again. Keying it to an E.164 number means a later import in a different format still matches it.
- Enrichment. Look-ups and matching against other data sources work on a consistent key. See the skip-tracing and list enrichment guide.
Storage format versus the format the trunk expects
Store E.164. Dial whatever your carrier needs. Some carriers want the plus sign, some want digits only, some want a prefix or the national form for domestic calls. That is a conversion at the edge, done once at dial time, driven by the trunk's setting. If you instead store the carrier's preferred form, a change of carrier means rewriting the whole database. The same logic applies to caller ID: the number you present may need a different shape on the wire from the one you store; see outbound caller ID not showing.
Como DialerBee se encaixa
DialerBee's lead management imports from CSV or XLSX and shows a preview of how the columns mapped before anything is written, so a bad mapping is fixed on the screen and not in the dialled list. DNC scrubbing runs on import, so suppressed numbers do not enter the list at all. The gestão de leads page describes the import, custom fields, lead groups and retry rules. For CRM-side data, the Guia de configuração da integração CRM covers how records get in and out.
The practical advice is to clean the file to E.164 before upload and use the preview to confirm the phone column landed in the phone field. A uniform format also helps any comparison you run yourself, against your own suppression or consent lists, because both sides use the same representation. This article is technical guidance only; check your own obligations before calling.
List-cleaning checklist
- Keep an untouched copy of the original export.
- Know the country for every row, and flag rows that have none.
- Format the phone column as Text before any spreadsheet opens it.
- Parse with a library, never a home-made regex.
- Reject and report numbers that fail the possible or valid check.
- Write every valid number as E.164 with a plus sign, no spaces or punctuation.
- De-duplicate after normalising, not before.
- Normalise the DNC and consent lists the same way before comparing.
- Check the saved CSV in a plain-text editor.
- Use the import preview to confirm the column mapping, then run a small test batch.
Perguntas frequentes
What is E.164 format?
E.164 is the international numbering plan from the ITU. In practice, an E.164 number is written with a plus sign, then the country code, then the national number, with no spaces, hyphens, brackets or leading trunk zero. The ITU lists the 02/26 edition of Recommendation E.164 as in force. Written this way, a number is unambiguous anywhere in the world (RFC 3966, section 5.1.4).
How do I convert phone numbers to E.164?
Do not rewrite them by hand. Parse each number with the country it was written for, then format the result as E.164, using a maintained library such as libphonenumber. Its documentation shows a Swiss number written 044 668 18 00 and parsed for region CH becoming +41446681800. The country must come from the record or the list, because the same digits mean different things in different countries.
Why does my spreadsheet remove the leading zero and the plus sign?
Spreadsheets treat a cell full of digits as a number by default, and a number has no leading zero to keep. Microsoft's Excel documentation says Excel automatically removes leading zeros and converts large numbers to scientific notation. A leading plus sign can be lost the same way. Set the column to Text before you paste or open the file, and check the saved CSV in a plain-text editor, not in the spreadsheet that caused the damage.
Should I keep the plus sign when I import a CSV?
Yes, as your stored format. A leading plus marks a number as global, so the country code is part of the data and nothing has to be guessed (RFC 3966, section 5.1.4). If your carrier wants digits only on the wire, convert at the moment of dialling and keep the stored value in E.164.
Is a regex good enough to validate phone numbers?
Rarely. Number lengths and prefixes differ by country and change over time, so a hand-written pattern either rejects real numbers or lets invalid ones through. A library that carries the numbering rules, such as libphonenumber, offers both a quick length-based check and a full validity check for a region.
Why does format matter for do-not-call lists?
Suppression is an exact match. If your list holds 0NNNNNNNN and the do-not-call file holds +CCNNNNNNNN, the two do not match and a suppressed person gets called. Normalising both sides to E.164 before comparing is what makes de-duplication, DNC scrubbing and consent records line up.
Fontes
- ITU-T Recommendation E.164, The international public telecommunication numbering plan, 02/26 listed as in force. itu.int/rec/T-REC-E.164 (consultado em 7 de novembro de 2026)
- RFC 3966, The tel URI for Telephone Numbers, sections 5.1.1 and 5.1.4. rfc-editor.org/rfc/rfc3966 (consultado em 7 de novembro de 2026)
- Microsoft Support, Keeping leading zeros and large numbers (Excel). support.microsoft.com (consultado em 7 de novembro de 2026)
- Google libphonenumber, README. github.com/google/libphonenumber (consultado em 7 de novembro de 2026)
Leituras relacionadas
Artigos relacionados
Melhor software de recepcionista com IA: como escolher um que agende, responda e transfira
Tempo de leitura: 9 minutos
GuiasMelhor agente de voz com IA para call centers: guia de compra para líderes de contact center
Tempo de leitura: 9 minutos
OperaçõesErlang A vs Erlang C: Staffing With Abandonment
Leitura de 10 minutos
ConformidadeFrance Telemarketing Opt-In: Rules Since 2026
Tempo de leitura: 9 minutos
Pronto para ver DialerBee em ação?
Solicite uma demo ao vivo de 15 minutos ou comece um teste grátis de 14 dias — sem slides, sem compromisso. As ligações começam assim que o seu próprio SIP trunk ou PBX estiver conectado e aprovado.
Teste grátis de 14 dias · crédito de IA gratuito · sem cartão · 11 idiomas · BYOC · controles de apoio à conformidade