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

From iSMS Wiki
Jump to: navigation, search
Line 17: Line 17:
  
  
[[File:isms-bulk-sms-csv-compose-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 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-csv-compose-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]]
  
  
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: Format Cell]]
+
[[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-csv-compose-4.jpg|thumb|500px|center|Illustration 5: Formal Cell]]
+
[[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-csv-compose-5.jpg|thumb|500px|center|Illustration 6: Add 60 to the front of all mobile phone numbers]]
+
[[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-csv-compose-6.jpg|thumb|500px|center|Illustration 7: Save CSV file]]
+
[[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-csv-compose-6.jpg|thumb|500px|center|Illustration 8: Save CSV file]]
+
[[File:isms-bulk-sms-convert-excel-to-csv-7.jpg|thumb|500px|center|Illustration 8: Save CSV file]]

Revision as of 15:25, 9 December 2013