🌀Abdelkarim Ben Mohamadi
Email Marketing
0

Phone Number Formatter: One Number Written Ten Ways, and One Format for WhatsApp

Abdelkarim Ben Mohamadi Abdelkarim Ben Mohamadi
Phone Number Formatter: a free tool that runs in your browser

In the Data Booster tests there's a line that looks trivial:

phone_key("+212 535-74 00 37") == phone_key("0535740037")

It means: these two are one number. Data Booster finds numbers in different places: the business's own website, the open maps, the search results. And each place writes the number its own way. If it didn't know these two were the same number, it would think they were two different businesses.

I wrote this test because phone numbers on the internet are never written one way. And you know that if you've ever collected customer numbers in a spreadsheet.

1. The sheet no program accepts

Open any numbers file you've collected from different sources. You'll find something like this:

  • 0661 23 45 67
  • +212 (0)6 61 23 45 67
  • 00212661234567
  • 06.61.23.45.67

Four lines, one number. Then you try to upload the file to a sending tool, or open a WhatsApp chat, and half of them get rejected: WhatsApp wants the full number with the country code, no zero at the start, and no spaces or + sign in the link.

And the worst one: +212 (0)6. That zero in the brackets is written by people to say "dial it with a zero inside Morocco." If you leave it in, the number is wrong.

2. The tool: try it now

Paste your numbers, one number per line. Pick the country for numbers written without an international code, and the format you want, then press "Format numbers".

3. What it does with each number

  • Understands every way of writing: spaces, dots, dashes and brackets, 00 instead of +, the zero in brackets, an international number written without the + as some files export it, and an extension at the end (ext 12).
  • Four formats: international (+212661234567), for WhatsApp and sending tools (212661234567), with double zero, or local (0661234567).
  • Mobile or landline: from the first digits of the national number. And the "Mobile only" option gives you the numbers whose owners may be on WhatsApp.
  • A WhatsApp link for every mobile: click it in the table, or take all the links in a CSV file.
  • Duplicate removal: the four lines above become one number, and the tool tells you which line was a duplicate.
  • The reason for every rejection: shorter than this country's numbers, or longer, or with an international code the tool doesn't know.

Supported countries: Morocco, Algeria, Tunisia, Egypt, Saudi Arabia, the UAE, France, Belgium, Spain, and the United States and Canada. And the numbers never leave your device.

4. What it doesn't know, frankly

  • "Valid" means the length is right: it doesn't mean the number works, or that its owner will reply.
  • It doesn't know who is on WhatsApp: "mobile" is a guess from the first digits. And in the United States and Canada you can't tell mobile from landline by the number, so the tool gives a link for every number.
  • Only ten countries: a number with another international code shows as "invalid" with the reason. If you need your country, write it in the comments.

And a word on use: a WhatsApp link makes chatting easier, but it doesn't give you permission. Message people you know your message is relevant to, introduce yourself, and accept "no" the first time.

💳 Price and purchase

The tool formats numbers you already have. Data Booster finds them: it takes the email addresses Lead Miner collected and, for each address, looks up the publicly published information about its owner, including phone, company name, city, website and social media pages, with the source of every piece of information and the confidence in it. It runs alongside Lead Miner on your computer.

Data Booster add-on: $97 a year (or the bundle with Lead Miner: $149 a year)

Get your copy now 🚀

A question before buying? Message me on WhatsApp.

Messy data doesn't need more effort. It needs one rule applied to every line.

Which country are most of your customers' numbers from? And what strange way of writing a number have you run into? Write it in the comments, without any real number.

Got a lot of files? Merge them first with the CSV Merger, and every month a new free tool reaches the subscribers of the newsletter first.


Get it free now

Every week I send you my latest tech tutorials and free tools, straight to your inbox.

Free, and you can unsubscribe anytime.





Comments

Comments

Discover the latest tech solutions and PRO tools to grow your traffic, customers and sales For questions or to order any service or product, contact me directly on WhatsApp