Difference between revisions of "How to Convert Microsoft Excel to CSV"
From iSMS Wiki
| Line 1: | Line 1: | ||
| − | + | ||
| + | |||
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. | ||
| − | + | '''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 | + | 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. | ||
