Bulk SMS User Guide
Send Text Messages From a Spreadsheet
This page show how to send text messages by uploading the details as a spreadsheet.
The first line of the spreadsheet is the CASE-SENSITIVE header that defines the data, and each subsequent line represents the text messages
that are to be sent. It is very important that the spreadsheet is in .csv format, as .xls is not supported.
You may need to select "File", "Save As..." in Excel to get the required format.
Example 1:
The simplest form of the file to upload consists of a set of fixed messages to be sent to one or more mobiles, for example:
MOBILE,MESSAGE
447000000001,Sale now on! Big Savings. From Example.com
447000000002,Sale now on! Big Savings. From Example.com
447000000003,Sale now on! Big Savings. From Example.com
This means that the messages that are sent would be as follows:
| 447000000001 |
Sale now
on! Big
Savings.
From
Example.com |
|
| 447000000002 |
Sale now
on! Big
Savings.
From
Example.com |
|
| 447000000003 |
Sale now
on! Big
Savings.
From
Example.com |
|
Example 2:
It is also possible to customise the message that is sent to each person. This is done by including one or more additional columns.
Wherever the name of the additional columns is found within any of the messages, then the value of that row of the column will be
inserted into the message. The following examples have been colour coded for clarity:
MOBILE,COST,MESSAGE
447000000001, 10, Your book is ready, £COST to pay
447000000002, 14, Your book is ready, £COST to pay
447000000003, 8, Your book is ready, £COST to pay
This means that the messages that are sent would be as follows:
| 447000000001 |
Your book
is ready,
£10 to pay |
|
| 447000000002 |
Your book
is ready,
£14 to pay |
|
| 447000000003 |
Your book
is ready,
£8 to pay |
|
Example 3:
Any number of extra columns can be inserted to allow your messages to be highly customised. The following examples have been colour coded for clarity:
MOBILE,COST,NAME,MESSAGE
447000000001, 10, Callum, Your book is ready NAME, £COST to pay
447000000002, 14, Mark, Your book is ready NAME, £COST to pay
447000000003, 8, Emma, Your book is ready NAME, £COST to pay
This means that the messages that are sent would be as follows:
| 447000000001 |
Your book
is ready
Callum,
£10 to pay |
|
| 447000000002 |
Your book
is ready
Mark,
£14 to pay |
|
| 447000000003 |
Your book
is ready
Emma,
£8 to pay |
|