When importing a list of phone numbers, we always recommend that the file be cleaned up FIRST. The easiest way to do this is to open the file in EXCEL or a similar program and remove all special characters from the data by doing a FIND and REPLACE in your excel file.
If the file is too large or if there are different variations in how the phone numbers are formatted, this can cause problems with uploading the file.
Common special characters to find and remove from your file and mobile number column data:
- FIND and REPLACE all ( with nothing - (Open Bracket)
- FIND and REPLACE all ) with nothing - (Closing Bracket)
- FIND and REPLACE all - with nothing - (Dash)
- FIND and REPLACE all <spaces> with nothing - (Empty space)
- Look for any ".ext" or "x" in the mobile column data
- FIND and REPLACE all , with nothing - (Commas)