Difference between revisions of "How to Convert Microsoft Excel to CSV"
From iSMS Wiki
(Created page with "== 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)...") |
|||
| 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-csv-compose-3.jpg|thumb|500px|center|Illustration 4: | + | [[File:isms-bulk-sms-csv-compose-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-csv-compose- | + | [[File:isms-bulk-sms-csv-compose-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-csv-compose-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-csv-compose-6.jpg|thumb|500px|center|Illustration 7: Save CSV file]] | ||
| + | |||
| + | |||
| + | 8. Select CSV (Comma Delimited) to save your file as CSV format. | ||
| + | |||
| + | [[File:isms-bulk-sms-csv-compose-6.jpg|thumb|500px|center|Illustration 8: Save CSV file]] | ||
