English
  1. Home
  2. Messaging
  3. How to get started

How to send SMS Messages to a list in Microsoft Excel?

Go to Send messages app via the menu in the top left corner and click on the blue "Send from Excel" button.

How to send SMS Messages to a list in Microsoft Excel? | CM Help Center

Upload: Upload your Excel file with the mobile numbers you want to send a message to. You can also upload a specific message text for each phone number in a second column.

Start with uploading your Microsoft Excel list with mobile numbers. We support .xls, .xlsx, .ods and .csv files from Microsoft Excel 2003 or LibreOffice. At this moment we support up to 1.000.000 rows you can download an example spreadsheet to use as template.

How to send SMS Messages to a list in Microsoft Excel? | CM Help Center

Match: Select the column in which the mobile numbers are stored, and if applicable, the column that contains the message body

The platform will identify all the active columns in your file and present them to you. Please select the column in which the mobile phone numbers are placed and if applicable the column in which the message bodies are located. All other columns will be omitted.

How to send SMS Messages to a list in Microsoft Excel? | CM Help Center
When the first row of the file contains contact data instead of headers you need to check the "The first row of the Excel contains contact data and should be used"-checkbox at this step; so the first row is also processed.

Number validation: All numbers are checked for syntax validity; you can change the invalid ones.

All mobile phone numbers will be validated to check whether they are valid phone numbers. Please format all the numbers using the international format by adding country codes. Here(link) you can read a bit more background to formatting international telephone numbers. When a phone number isn’t validated correctly, you can change it before sending or remove that number from your batch.

How to send SMS Messages to a list in Microsoft Excel? | CM Help Center

Message: If your source file does not contain message bodies please compose the message you want to send to all recipients.

Compose the message body if it wasn’t incluced in the Excel file. You can compose a text and send it to all recipients.

At the bottom of the input box you’ll find a counter. This counter shows the amount of characters in your message, the number of characters left and whether it is a Unicode(link) message you are about send. A message using the standard GSM alphabet can contain 160 characters. When you use the Unicode alphabet you are limited to 70 characters. When you use more characters the message will be sent in multiple parts(link).

After composing the message text you need to input or select the sender for your message. A sender (originator) can contain a maximum of 11 characters. If you send messages to operators that do not allow an alphanumeric sender name we will overwrite the sender with a numerical one.

How to send SMS Messages to a list in Microsoft Excel? | CM Help Center

Launch: Send your Excel batch directly or schedule it for dispatch on a later moment. The recipients can also be saved as a group for repeated sending.

The last step to take is to send your message. You can send it immediately or schedule it for a later moment. For smaller batches (less than 500 recipients) the batch can be saved as a group for a future dispatch. Now your message is ready to go!

How to send SMS Messages to a list in Microsoft Excel? | CM Help Center

Last modified on 10/03/2017
Was this article helpful?