Importing Mobile Numbers with Country Codes | Audience Republic Help Center

To ensure your contact import runs smoothly, mobile numbers in your CSV file must be formatted correctly. Here's how to get it right:

Before You Start

Make sure your CSV file includes all required contact information and that mobile numbers meet the following requirements.

Cell format should be set to General or Text
Mobile numbers must include:
- Country calling code
- Area code
- Phone number
Both numbers with a + symbol and without are accepted
Spaces and dashes will be ignored

Example formats:
+61400123456 or 61400123456

If your mobile numbers don’t include country codes, you can reformat them using a formula:

Open your CSV file in Excel.
Add a new column next to the mobile number column.
Use the following formula (replace A2 with your cell reference and 61 with your country code):
```
arduinoCopyEdit="61"&A2
```
Click on the cell with the formula, hover over the bottom-right corner until the + sign appears.
Double-click to auto-fill the formula down the column.
Copy and paste the new column values as plain text before saving.

Watch this short video on how to add country codes in Excel.