Phone Number Normalizer to E.164 (CSV Column, Default Country)
Rewrites phone numbers to +countrycode and digits using a default country for numbers without a code, and flags odd lengths for review.
Use the tool
Why this tool exists
CRM and mailing exports hold numbers in every local style. E.164 (+442079460958) is what most SMS and voice systems expect. Pick the default country, and local numbers lose their trunk zero and gain the country code.
The check is structural: it knows each country calling code, the trunk prefix and the usual length of the national number (from Google libphonenumber metadata), but it does not know whether a number is assigned or a mobile. A number marked ok may still not exist. 00 is treated as the international prefix, as in most countries. Review flagged rows by hand.
How to use it
- Paste the CSV and name the phone column.
- Enter the default country as a two-letter code.
- Keep the phone_check column to see review flags.
- Copy or download the result.
Frequently asked questions
Is it as strict as libphonenumber?
No. It checks digit count only. We compared the output numbers with libphonenumber-js and they matched except for cases noted as 00 prefix handling.
Extensions?
A trailing ext or x number is dropped.
Which countries?
All with a calling code in the bundled table; use the ISO code, for example GB or DE.
Is the data private?
Yes, nothing leaves your browser.