How to reformat mobile numbers to include country codes

Modified on Thu, 23 Mar, 2023 at 1:46 PM

When importing mobile numbers into Audience Republic, the country codes in your import file must meet certain formatting requirements, or the import may not succeed. 

Before you get started

  • Make sure you have a CSV file with the contacts information included

Mobile number requirements

  • The cell format should be General or Text
  • Mobile numbers must include:
    - International country calling code
    Area code
    Phone number
  • Numbers and '+' symbol will be accepted
    Spaces and dashes will be ignored


How to reformat mobile numbers to include country codes

  • Open your excel CSV file
  • Add another column next to the Phone number column 
  • Write:  ="(country code) "&cell reference


  • Click on the cell formula, move the pointer to the bottom right corner so it turns into a   sign
  • Double click to auto-fill that formula all the way down


Watch this video: How to add area codes to phone numbers in Excel


Related articles

Import data formatting requirements

Prepare contacts data for import

Troubleshooting: importing contacts to a list

Still need help?

Contact us at support@audiencerepublic.com 

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article