This is actually an easy one.
Make sure your contacts are in an Excel spreadsheet or CSV file. If your contacts are currently stored in a CRM program, most, if not all of these contact database programs will allow you to export into an Excel spreadsheet.
On your spreadsheet, make sure the mobile numbers are in COLUMN A. Any other data you can keep in the other columns (eg first name, last name)
It doesn't matter if they have the zero at the front missing...excel has an annoying habit of chopping off what's called "leading zeros". It is actually a program for number crunching but many people use it as a contact database.
But this doesn't matter with SMS Express as when the numbers are imported, the system will change them into international format anyway (61 replaces any 0 at the front of the number).
You also don't have to change your numbers into +61 or anything like that. Just make you have valid mobile numbers (eg 0434085892)...and remember it doesn't matter if the front 0 is removed (eg 434085892) as the system will change the number to 61434085892 after import.
Another tip...check your list to ensure there are no landlines or other dodgy numbers in there, as you don't want to waste credits on dud numbers.
A quick way to check your list for dodgy numbers before you import:
- open the spreadsheet
- highlight the whole spreadsheet so all columns and rows are highlighted (quick way is to click the small rectangle in the far left corner between the A column header and 1 Row..that should highlight everything)
- Go to the top menu ribbon and click on Data, then SORT, then a box will pop open. You can SORT BY Column A...if your column has a header in the top row (eg Number) make sure you tick the My Data Has Headers box top right.
- Then click OK.
This will sort that column into highest and lowest, so you'll be able to spot any short or odd numbers. Mobiles are always 04 so anything NOT 04 (eg 03 08 02) should be checked or deleted if not a mobile number.
Also, if a number looks too short, it may have a digit missing making it invalid. Fix or remove these. All Australian mobile numbers are 10 digits (0434085892) so any odd ones should stand out.
Once you are happy, SAVE the file on your PC and then upload into your SMS Express Group using Import Data.
Bamboozled? We've got a good working knowledge of Excel and use it every day! We're here to help. Just call 1300 668 287 or email email@example.com .