To import contacts into a WhatsApp CRM without creating a mess, prepare one clean spreadsheet, convert every UAE number to the same international format (+971), remove duplicates by phone number, and carry over consent and tags exactly as they are. Then check a sample after the import. An hour of preparation saves weeks of fixing wrong or doubled records.

This article is part of our guide to WhatsApp lead management.

Preparing the file

Most CRMs accept CSV or Excel files. Before importing:

Split full names into first and last name only if your messages will use them. Never include sensitive information you do not need, such as passport or medical details.

UAE number formats

The same UAE mobile number can appear in many forms:

As written Standard format
050 123 4567 +971501234567
0501234567 +971501234567
971501234567 +971501234567
00971 50 123 4567 +971501234567
+971 (0) 50 123 4567 +971501234567

Rules for converting:

  1. Remove spaces, dashes, brackets and dots.
  2. Replace 00 at the start with +.
  3. Replace the first 0 of a local number with +971.
  4. Remove a “(0)” or 0 that appears straight after 971.
  5. Check the result: UAE mobile numbers start with +9715 and have nine digits after 971.

Landline numbers, such as 04 numbers in Dubai, usually cannot receive WhatsApp messages unless they are registered as a WhatsApp business number. Keep them, but mark them so nobody tries to message them on WhatsApp. International numbers keep their own country code.

Deduplicating by phone

Once all numbers are in the same format, duplicates become easy to find, because the phone number is the key on WhatsApp.

Example: “Sara A, 0501234567, Source: Instagram” and “Sara Ahmed, +971 50 123 4567, Tag: VIP” become one record: “Sara Ahmed, +971501234567, Source: Instagram, Tag: VIP”.

Keeping consent and tags

Consent details are the most important columns to carry across. For each contact, keep:

If two records disagree, for example one says opted in and the other opted out, treat the contact as opted out. If consent is missing, mark it as unknown rather than guessing.

Standardise tags before importing, too. “Abu Dhabi”, “AD” and “AUH” should become one tag. Our help article on leads and contacts explains how tags and groups are used in Dub Ai.

Checking after import

After the import, check before anyone uses the list:

  1. Compare the total count with your cleaned file.
  2. Open twenty random records and compare them with the source.
  3. Search for a few known duplicates to confirm they merged.
  4. Filter by opted-out and confirm the numbers look right.
  5. Check Arabic names display correctly.

Common import problems

Only then use the list for campaigns, and only for contacts with recorded consent.

How Dub Ai helps

With CRM Data Migration, the Dub Ai team imports contacts and leads from spreadsheets or another system’s export, matched by phone number so the same person is not saved twice. Notes, tags, sources and groups are kept where they exist, and consent and opt-out details are carried across where you have them.

Once imported, contacts sit in the same leads list as new WhatsApp enquiries, and you can ask your admin agent about any contact by message.

Frequently asked questions

What format should UAE numbers be in?

Use the international format with the country code and no spaces: +971 followed by the number without its first zero, for example +971501234567. This format, often called E.164, works for WhatsApp and avoids duplicates caused by different spellings of the same number. Convert every number to it before importing.

Will importing message my contacts?

No. Importing only adds records to your CRM; it does not send anything. Messages go out only when you or your team choose to send them, for example through an approved template. Before any campaign, filter the imported list to contacts who opted in, and exclude anyone marked as opted out or unknown.

Book your demo on WhatsApp: +971 56 552 6662

Leave a Reply

Your email address will not be published. Required fields are marked *