How to format an excel spreadsheet
How to format an excel spreadsheet
Administrator
Last Update 3 years ago
1. Open up an excel document, this will need to be saved in .CSV or .xls format
Add a series of titles (field merges) in the first row.
The default titles FxbulkSMS requests you to use are:
- Phone Numbers
- Email addresses
- User Names
- Company
- First Name
- Last Name
- Message
Note: The default international code is ‘61’ for Australia, so if you’re sending to Australian numbers, they can be entered with a 0 at the beginning. For example 04555224190.
To easily add the international code in front of the number:
2. Select the cell next to the first number. In this case it is F2.
3. Click on the corner of the green box and drag it down the column. This will transform all the mobile numbers into international form.
4. Give this column a name that you will remember, such as ‘International Mobile Numbers’, and be sure to select this as your ‘Mobile Number’ after uploading.