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

  1. Paste the CSV and name the phone column.
  2. Enter the default country as a two-letter code.
  3. Keep the phone_check column to see review flags.
  4. 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.