Difference between revisions of "How to Convert Microsoft Excel to CSV"
From iSMS Wiki
| Line 17: | Line 17: | ||
| − | [[File:isms-bulk-sms- | + | [[File:isms-bulk-sms-convert-excel-to-csv-1.jpg|thumb|500px|center|Illustration 3: Download CSV sample]] |
| Line 24: | Line 24: | ||
You may leave the non related columns blank. The mobile number of the recipients must begin with prefix 60. | You may leave the non related columns blank. The mobile number of the recipients must begin with prefix 60. | ||
| − | [[File:isms-bulk-sms- | + | [[File:isms-bulk-sms-convert-excel-to-csv-2.jpg|thumb|500px|center|Illustration 3: Download CSV sample]] |
| Line 32: | Line 32: | ||
* Right click the selected phone number column, and click '''Format Cells'''. | * Right click the selected phone number column, and click '''Format Cells'''. | ||
| − | [[File:isms-bulk-sms- | + | [[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). | 5. Select Custom then key in "60##########" (# 10 times). | ||
| − | [[File:isms-bulk-sms- | + | [[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. | 6. This will add "60" to all mobile phone numbers in the selected column. | ||
| − | [[File:isms-bulk-sms- | + | [[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. | 7. Select "File" and click "Save As" to save the file as CSV format. | ||
| − | [[File:isms-bulk-sms- | + | [[File:isms-bulk-sms-convert-excel-to-csv-6.jpg|thumb|500px|center|Illustration 7: Save CSV file]] |
8. Select CSV (Comma Delimited) to save your file as CSV format. | 8. Select CSV (Comma Delimited) to save your file as CSV format. | ||
| − | [[File:isms-bulk-sms- | + | [[File:isms-bulk-sms-convert-excel-to-csv-7.jpg|thumb|500px|center|Illustration 8: Save CSV file]] |
