Format any phone number for WhatsApp — before it silently fails

The WhatsApp Business API identifies every recipient by their phone number in E.164 format — country code first, no punctuation. There is no fuzzy matching and no second guess: if the number you send to isn’t the number registered on the handset, the message simply doesn’t arrive. Unlike an email bounce, there is often no loud error either. A malformed number can be rejected quietly or, worse, resolve to a different valid number in another country. E.164 exists precisely so that +917880148433 means exactly one phone on the planet.

Indian contact lists are especially prone to two silent failure modes. The first is the trunk zero: numbers saved on handsets or exported from billing software often look like 078801 48433. That leading 0 is a domestic dialling convention, not part of the number — send it to the API as-is and it reads as an 11-digit number with no country code. The second is the bare 10-digit mobile with no 91 at all. Both look perfectly normal to a human scanning a spreadsheet, which is why they survive manual review and only show up later as a delivery rate that is mysteriously lower than it should be. Cleaning the list before import — dropping trunk zeros, adding the country code, converting 00 prefixes to a plus — removes the whole class of problem in one pass.

De-duplication is the other pre-import step worth doing. The same customer frequently appears in a list several times under different spellings of the same number: once with +91, once with a leading 0, once as bare digits. Import that list raw and your platform may treat them as three contacts — and a broadcast can reach the same person three times in a minute. Beyond the annoyance, repeated identical messages are a common trigger for recipients to tap Block or Report, which damages your number’s quality rating. Because this tool normalises every variant to a single canonical E.164 string first, duplicates that were invisible in the raw list become exact matches, and the “Copy valid list” output removes them automatically.

• Store numbers in E.164 in your CRM and convert to display format only in the UI — never the other way around.
• For wa.me links, drop the plus: wa.me/917880148433, with no spaces or dashes.
• Re-clean any list that has passed through Excel — it can strip leading zeros and mangle long numbers into scientific notation.