How do I ensure mobile numbers format correctly in CSV?

Before uploading a CSV make sure the mobile number wasn’t converted by Excel. Excel formats longer numbers as follows: 

There are two ways to fix this using Excel: 

Option 1: Update the column format 

Highlight the column with the mobile numbers: 

Click on Excel’s Data tab and then the option “Text to Columns”:

On the pop-up window that appears click on “Next”:

Click Next again: 

On the screen that asks about the column data format, select Text and click Finish:  

The Mobile Number will now be returned to a full number:  

You can now Save the CSV for upload on the website. 

Option 2: Add an apostrophe in front of each mobile number 

The next method is not ideal for large files. Click in the mobile number cell, the full number will show in the formula bar: 

Click in the formula bar and add an apostrophe (‘) in front of the number:

Click Enter and see the full number will now show.  

Repeat this for all the mobile numbers in the file and save the CSV.