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

From iSMS Wiki
Jump to: navigation, search
(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: Download CSV sample]]
+
[[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).
This will change all phone number to 60 formats.
+
  
[[File:isms-bulk-sms-csv-compose-3.jpg|thumb|500px|center|Illustration 5: Download CSV sample]]
+
[[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]]

Revision as of 15:19, 9 December 2013