# Excel to WhatsApp: How to Import Contacts from Excel or CSV

> Move contacts from Excel to WhatsApp with country code formulas, landline and duplicate checks, a clean CSV file and a WhatsApp contact list ready to use.

Published 4 October 2026 · About Nitro · 7 min read
Source: https://leadsadd.com/blog/excel-to-whatsapp-contacts

Moving contacts from Excel to WhatsApp sounds simple until the import shows numbers like 9.71501E+11, numbers with no country code, and half the list made of office landlines. This guide shows how to prepare an Excel or CSV file so every number works on WhatsApp: the right number format for the Gulf, the UK and the USA, copy-ready formulas for the common problems, and the checks to make before you import contacts to WhatsApp campaigns.

## The short answer

1. Keep one row per contact and one column per field: name, phone, group or source, and the date they agreed to hear from you.
2. Store phone numbers as text, in international format, digits only, with no plus sign, spaces or leading zero.
3. Add the country code to local numbers and remove the trunk zero (the 0 at the start of local UAE, Saudi and UK numbers).
4. Remove duplicates and landlines.
5. Keep only people who expect your messages, save as .xlsx or CSV UTF-8, and import.

## Why phone numbers break in Excel

Excel was built for sums, not phone numbers, and it changes them without asking.

- **Scientific notation.** A long number such as a full UAE mobile shows as 9.71501E+11. If you save that sheet as CSV, the file can keep the short form and the real digits are lost.
- **Lost leading zeros.** Type 0501234567 into a number cell and Excel stores 501234567.
- **Mixed formats.** The same column holds +971 50..., 00971 50..., 050... and 50..., depending on who typed them.
- **Landlines.** Office numbers usually cannot receive WhatsApp messages, and they waste your checks.
- **Duplicates.** The same customer saved twice, once with spaces and once without.
- **Broken names.** A plain CSV can turn Arabic or other non-Latin names into question marks. Excel's "CSV UTF-8 (Comma delimited)" option keeps them.

## How to format phone numbers for WhatsApp

WhatsApp numbers use the full international format: country code, then the number, with no plus sign, spaces or leading zero. The table shows what that looks like for the countries our readers message most. X stands for any digit.

| Country | Code | Local mobile looks like | WhatsApp-ready format |
|---|---|---|---|
| UAE | 971 | 05X XXX XXXX | 9715XXXXXXXX |
| Saudi Arabia | 966 | 05X XXX XXXX | 9665XXXXXXXX |
| Qatar | 974 | XXXX XXXX | 974XXXXXXXX |
| Kuwait | 965 | XXXX XXXX | 965XXXXXXXX |
| Bahrain | 973 | XXXX XXXX | 973XXXXXXXX |
| Oman | 968 | XXXX XXXX | 968XXXXXXXX |
| United Kingdom | 44 | 07XXX XXXXXX | 447XXXXXXXXX |
| United States | 1 | (XXX) XXX-XXXX | 1XXXXXXXXXX |

The pattern to remember: in the UAE, Saudi Arabia and the UK you drop the 0 when you add the country code. Qatar, Kuwait, Bahrain and Oman have no leading 0 to drop. US numbers have no leading 0 either; you add 1 in front.

## Excel to WhatsApp: clean your contact list step by step

Put the raw numbers in column A and build each step in the next column, so you can always see the original.

1. **Format the phone column as text** before you paste anything: select the column, choose Format Cells, then Text. This stops the scientific notation and the lost zeros.
2. **Strip spaces, dashes, brackets and plus signs** (result in column B):

```
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2," ",""),"-",""),"(",""),")",""),"+","")
```

3. **Remove a leading 00** (result in column C):

```
=IF(LEFT(B2,2)="00",MID(B2,3,20),B2)
```

4. **Add the country code to local numbers that start with 0.** This example uses the UAE code; change 971 to 966 for Saudi Arabia or 44 for the UK (result in column D):

```
=IF(LEFT(C2,1)="0","971"&MID(C2,2,20),C2)
```

5. **Remove the hidden zero.** People often write +971 (0)50 or +44 (0)7, which becomes 9710... or 440... after cleaning. This removes that zero for UAE numbers (result in column E):

```
=IF(LEFT(D2,4)="9710","971"&MID(D2,5,20),D2)
```

6. **Flag landlines.** In the UAE, mobiles start 9715 once the code is added; numbers starting 9712, 9713, 9714, 9716, 9717 or 9719 are landlines. Saudi mobiles start 9665 and UK mobiles start 447. US numbers do not show the difference, so leave that to a WhatsApp check.

```
=IF(LEFT(E2,4)="9715","mobile","check")
```

7. **Remove duplicates** with Data, then Remove Duplicates, on the cleaned column.
8. **Add a source column** (website form, shop counter, past order) and the date each person agreed.
9. **Save** as .xlsx, or as CSV UTF-8 if your names include Arabic or other non-Latin letters.

If your list mixes countries, add a country column and run step 4 per country, or sort by country and correct each block separately.

## Keep only contacts who expect your messages

The import is the best moment to make your list honest. Leave out bought lists, numbers copied from groups, people who asked you to stop, and old numbers nobody has used for years. A clean list of 800 people who know you is worth more than 8,000 strangers. WhatsApp is built for conversations people welcome, and it can limit accounts that many people block or report, so message people who know your business and expect to hear from you.

## Good practice and local rules

The rules point the same way. In the UAE, the TDRA rules and the PDPL (Federal Decree-Law 45 of 2021) expect clear consent for marketing messages, sender identity and a free opt-out. Saudi Arabia's PDPL, overseen by SDAIA, requires prior consent and an easy way to withdraw it. In the UK, PECR treats WhatsApp messages as electronic mail: individuals and sole traders need consent or a valid soft opt-in. In the USA, get written consent before automated marketing texts. Keeping the source and date columns from step 8 means you can show where each contact came from. This is general information, not legal advice; check the current rules for the country you send to.

## Importing your list into Nitro

Nitro is WhatsApp campaign software for Windows that sends through your own WhatsApp numbers, linked with Linked devices the same way WhatsApp Web works. Its [contact import](/nitro/features#import) takes CSV, .xlsx or .xls files up to 50 MB and 200,000 rows. It matches your columns for you, lets you set a default country code for numbers saved without one, skips landlines, and puts the contacts into a group as they arrive. Rows that need attention can be downloaded, corrected in Excel and imported again; the cleaner the file, the shorter that download. [Rovero exports](/nitro/features#from-rovero) are recognised as they are. Once imported, you can use groups, tags and filters, check which numbers are on WhatsApp before sending, and save a file of up to 3,000 contacts at a time to import into each phone's Google Contacts, with opted-out, landline and non-WhatsApp numbers left out.

## Frequently asked questions

### How do I add a country code to phone numbers in Excel?

Clean the numbers first (no spaces or plus signs), then use a formula such as `=IF(LEFT(C2,1)="0","971"&MID(C2,2,20),C2)`, which swaps a leading 0 for 971. Change 971 to the right code for each country, and check for a hidden zero after the code.

### Why does Excel show my phone numbers as 9.71E+11?

Excel treats a long number as a value and shows it in scientific notation. Format the column as Text before pasting, or the digits can be lost when you save as CSV.

### Can I import an Excel file directly into WhatsApp?

The WhatsApp app has no Excel import; it reads contacts from the phone's address book. You can import a CSV into Google Contacts so the numbers appear on the phone, or import the file into campaign software. WhatsApp broadcast lists only reach people who have saved your number.

### How do I remove landlines from a contact list?

Once numbers are in international format, mobiles start with a known prefix in many countries: 9715 in the UAE, 9665 in Saudi Arabia and 447 in the UK. Flag everything else and check it. For US numbers, use a WhatsApp check instead, because the number itself does not show whether it is a mobile.

## Next step

Clean one list with the steps above, import it, and review the rows that need attention before any campaign. When the list is ready, read [how to plan a WhatsApp marketing campaign](/blog/whatsapp-marketing-campaign). To import your list and start sending, [see how Nitro works and get started](/nitro), or read the full [Nitro features](/nitro/features).