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:
- Combine sources into one sheet: old CRM exports, phone contacts, order lists, event sign-ups.
- One row per person, one column per field.
- Clear column names: Name, Phone, Language, Source, Tags, Consent, Consent date, Notes.
- Remove empty rows, test entries and staff numbers.
- Keep a copy of the original files, untouched, in case you need to check something later.
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:
- Remove spaces, dashes, brackets and dots.
- Replace 00 at the start with +.
- Replace the first 0 of a local number with +971.
- Remove a “(0)” or 0 that appears straight after 971.
- 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.
- Sort the sheet by phone number.
- Where two rows share a number, merge them into one: keep the most complete name, combine tags and notes, and keep the earliest source.
- Where one person has two numbers, keep both, but decide which is primary.
- Watch for shared numbers, such as a company reception line used by several contacts.
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:
- whether they opted in to receive messages, and for which types (orders, offers);
- when and how they opted in;
- any opt-out, with the date.
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:
- Compare the total count with your cleaned file.
- Open twenty random records and compare them with the source.
- Search for a few known duplicates to confirm they merged.
- Filter by opted-out and confirm the numbers look right.
- Check Arabic names display correctly.
Common import problems
- Numbers turned into scientific notation (for example 9.71501E+11) by Excel. Format the phone column as text before saving.
- Arabic text shown as question marks. Save the CSV with UTF-8 encoding.
- Dates in mixed formats, such as 03/10 and 10/03. Pick one format, ideally year-month-day, before importing.
- Notes split across columns because of commas in the text. Use Excel files or quote text fields.
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.