Difference between revisions of "How to Convert Microsoft Excel to CSV"

From iSMS Wiki
Jump to: navigation, search
Line 1: Line 1:
== How to Convert Microsoft Excel to CSV  ==
+
 
 +
 
  
 
1. Please login to iSMS member console to download a csv sample file for reference. (You may skip this step if you have the file).
 
1. Please login to iSMS member console to download a csv sample file for reference. (You may skip this step if you have the file).
Line 12: Line 13:
 
2. Open the sample CSV file at Microsoft Excel and you will see the format below.
 
2. Open the sample CSV file at Microsoft Excel and you will see the format below.
  
To send SMS, you must follow the format.
+
'''NOTE:'''
 +
 
 +
If you intend to send personalised SMS via CSV, you must follow the format and fill in your data accordingly. Please refer to [[Personalised SMS|How to Compose Personalised SMS]] for more details.
  
 
'''Example :Hi %name%, your credit balance is %amount %, please make payment %string1%'''
 
'''Example :Hi %name%, your credit balance is %amount %, please make payment %string1%'''
  
 
'''Final Result Hi JOHN, your credit balance is 300, please make payment to test 1'''
 
'''Final Result Hi JOHN, your credit balance is 300, please make payment to test 1'''
 
  
 
[[File:isms-bulk-sms-convert-excel-to-csv-1.jpg|thumb|500px|center|Illustration 3: Download CSV sample]]
 
[[File:isms-bulk-sms-convert-excel-to-csv-1.jpg|thumb|500px|center|Illustration 3: Download CSV sample]]
Line 24: Line 26:
 
3. You will need to follow the format and insert your data accordingly as shown in the example below.  
 
3. You will need to follow the format and insert your data accordingly as shown in the example below.  
  
You may leave the non related columns blank. The mobile number of the recipients must begin with prefix 60.
+
You may leave the unused columns blank. The mobile number of the recipients must begin with prefix "60".
  
 
[[File:isms-bulk-sms-convert-excel-to-csv-2.jpg|thumb|500px|center|Illustration 3: Download CSV sample]]
 
[[File:isms-bulk-sms-convert-excel-to-csv-2.jpg|thumb|500px|center|Illustration 3: Download CSV sample]]
  
  
4. To add prefix 60 to all of the mobile phone numbers:
+
4. To add prefix "60" to all of the mobile phone numbers:
  
 
* Highlight the entire phone number column which you have just inserted.
 
* Highlight the entire phone number column which you have just inserted.

Revision as of 16:39, 9 December 2013