How to format an excel spreadsheet

How to format an excel spreadsheet

Administrator

Last Update 2 jaar geleden

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.

Was this article helpful?

0 out of 0 liked this article

Still need help? Message Us