Excel to SMS

Send bulk SMS right from Excel spreadsheet with Textlocal Excel plugin

Problem Tag: Module not found
Problem Tag: Asset not found
 

With Textlocal's Excel plugin you can send SMS directly from your Excel sheet, without logging into the Textlocal Messenger. This guide walks you through a few simple steps that are required to set up Excel to SMS in your Textlocal account.

Download Plug-in

 1. Sign up and add credits

Sign up for a free Textlocal account and activate it by verifying your e-mail address & mobile number.

Add credits to your Textlocal account

To send SMS using the plugin you must have credits in your Textlocal account. One credit is used for 1 SMS of up to 160 characters. You can see your existing credit balance in the top right corner of the Textlocal dashboard. To purchase credits, you can log on to the website and click on 'Buy' button on the top right corner.

 

Problem Tag: Asset not found
excelsms1.JPG
officestore.JPG

2. Download & install the plugin

Download the plugin and install it

  1. Go to this page from Office Store
  2. Click on 'Add' button, it takes you to the template install page
  3. Then click on 'Open in Excel' which downloads an excel sheet
  4. Open the sheet, click on 'Enable editing' and then 'Trust this add-in' to finish the installation
  5. You can always open the plugin from your excel sheet by going to Insert > My Add-ins > Excel to SMS
Problem Tag: Asset not found

3. Connect to Textlocal

The first time you use Excel to SMS, you need to connect Excel to Textlocal account using an API key.

You can find the API key here:

  1. Click Settings > All settings > API keys
  2. Click on Create New Key
  3. In the Notes field, give your API key a recognisable name, for example; Excel. Click Save New Key

Your API key will be an alphanumeric string in the format

XXXvIElXXXEha4FWmXXX5HWMiL5IuGuXXX16XXXX

When you first install the plug in, you will be prompted to add your API key in to the Textlocal window in Excel.

Click Enter to connect Excel to your Textlocal account.

Problem Tag: Asset not found

 

 

ExcelPlugin3.JPG

 

 

 

 

 

 

 

 

excelsms3.JPG

4. Compose your message

After you have installed the Excel plug in and entered your API key, you can begin writing your message.

Configure Sender IDs

Note: If your account is in promotional route, the messages will be sent with a random 6 digit Sender IDs assigned by the operator. To get a Sender ID of your choice, upgrade to transactional route. (Know the differences between Promotional and Transactional messages here)

After upgrading to Transactional route, you can request for a 6 alpha character Sender ID of your choice. Upon approval, you can select the Sender Names under the drop down 'Sender Name' when you next open your Excel file.

You can use existing data from the Excel sheet to form the message content and contacts. Alternatively, you can manually type the message content and contact numbers in the plugin window.

Manual messages

To manually create messages, set 'Use Selected Cells' to No. Select Compose Message and type your message in the pop up window. When your message is ready, click Save.

Next, manually add your phone numbers into the Numbers field. You need to press 'Enter' or ',' after entering each number – you will see that the number turns blue once it has been accepted into the system.

You can send this message to as many numbers are you want and every recipient will receive the same message; no personalisation can be applied with this method.

Automated messages

If you want to personalise your messages, select the cells you want to use in your message, set Use Selected Cells to Yes and confirm your selection by clicking OK in the pop up box.

Select Compose Message.

When you want to add personalised content in to your messages, use the Columns drop-down menu to select the information you want to add to your message then click Insert Placeholder.

You can also add in personalised information without using the drop-down menu, by typing the column header in { } brackets, e.g. {Pet} is due a {Treatment}. If you use this option, you MUST observe the same spelling, spacing and capitalising as in your column headers.

When your message is ready, click Save.

Next, you must tell Excel to SMS which of your columns contains your phone numbers. Use the Numbers column drop-down menu to do this.

Scheduling messages

Use the Date and Time field to schedule your message send. if you want to send your message ‘now’, you must schedule it to go out in one or two minutes’ time.

Problem Tag: Asset not found

5. Send your message

When you hit Send you will see a summary of your message.

This window will show you the content of your message and the Number of Messages you are sending (this is the number of contacts you are sending to, NOT the number of 160-character SMS credits you are using).  You can also review the Date and Time scheduled for your send.

The Calculate Cost function shows you the number of SMS credits that your send will consume (1 credit = 160 characters). If your account is in 'Promotional route', our DND filter will automatically remove the numbers activated for DND and this will be reflected in the cost.

To send your message, click Confirm.

Problem Tag: Asset not found
ExcelPlugin5.png
ExcelPlugin6.png

6. Hiding or removing Excel to SMS plug-in

If you want to close the Textlocal panel in Excel, simply click on 'Close' button in the top right corner of your spreadsheet.

Click on the top of the plugin window and drag it to move it to a different position. You can double-click on the plugin window to expand the Excel to SMS panel again.

Click on 'Logout' to logout of the plugin completely. You can login back using the API key.

Problem Tag: Asset not found