How to send with customised .csv?

"I want to send the same structured messages with various contents according to the recipient" "I want to contact my customers thanks for purchase message with the product that the customer has purchased" With EZSMS, you can upload csv file with the data to insert the various contents to your set message according to the recipient.

the maximum sending per upload is limited to 1,000

Let's see more details with how to create a csv file in case you would like to send customised SMS to the phone number lists in spreadsheet like MS excel, by inserting some various data to a set message text.

  1. Please create a message text. Name variables  with double curly brackets {{ text }}  and put it where you want to change by recipient.

image csv-01

 in the case of inserting customers' name in {{name}}, purchased goods in {{product}}, to send this message to the customers' mobile numbers

  1. Now creating the data file that contains the recipients' mobile phone numbers, names and products. This example shows you to prepare the file in excel. Please type the name of the variables  on the first row. These name of variables  are set in instruction number 1. (above). The data in this file will be inserted where you put variables  in double curly brackets {{ text }}  to be sent to the phones.
  2. The name of Variable  are mandatory.
  3. Please create all variable  and data  that you set in the message text.
  4. The first column of the first row has to be to  and the data of recipients phone numbers.
  5. Please set the text encoding to UTF-8
  6. In case you insert 2 or more data in one cell and want to separate them with comma (,), please wrap the whole data in the cell with double quotation "text,text"
  7. Please also wrap the whole data in the cell with double quotation "text text"  when you have any space within the cell data.
  8. Please do not wrap the recipient number data with double quotation.

image csv-02

  1. Please select the columnns that you put the items on the first row and format them as Text  data. 
  2. Insert your data, then save the file as .csv 
  3. Go to [Send CSV SMS](  page to upload the csv file and proceed to the sending. 

The sample csv file used in above can be downloaded here

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us