View source for 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).

[[File:isms-bulk-sms-csv-compose-sample-1.jpg|thumb|500px|center|Illustration 1: Login iSMS]]

[[File:isms-bulk-sms-csv-compose-sample-2.jpg|thumb|500px|center|Illustration 2: Go to Compose CSV]]

[[File:isms-bulk-sms-csv-compose-sample-3.jpg|thumb|500px|center|Illustration 3: Download CSV sample]]


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%'''

'''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]]


3. You will need to follow the format and insert your data accordingly as shown in the example below. 

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]]


4. To add prefix "60" to all of the mobile phone numbers:

* Highlight the entire phone number column which you have just inserted.
* Right click the selected phone number column, and click '''Format Cells'''.

[[File:isms-bulk-sms-convert-excel-to-csv-3.jpg|thumb|500px|center|Illustration 4: Format Cell]]


5. Select "Custom" then key in "60##########" (# 10 times).

[[File:isms-bulk-sms-convert-excel-to-csv-4.jpg|thumb|500px|center|Illustration 5: Formal Cell]]


6. This will add "60" to all mobile phone numbers in the selected column.

[[File:isms-bulk-sms-convert-excel-to-csv-5.jpg|thumb|500px|center|Illustration 6: Add 60 to the front of all mobile phone numbers]]


7. Select "File" and click "Save As" to save the file as CSV format.

[[File:isms-bulk-sms-convert-excel-to-csv-6.jpg|thumb|500px|center|Illustration 7: Save CSV file]]


8. Select CSV (Comma Delimited) and click "Save" to save your file as CSV format.

[[File:isms-bulk-sms-convert-excel-to-csv-7.jpg|thumb|500px|center|Illustration 8: Save CSV file]]