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

From iSMS Wiki
Jump to: navigation, search
 
Line 1: Line 1:
 +
Microsoft Excel is a widely used software. If you have inserted your customer data into an Excel file, you are still able to convert the file and use it at iSMS. After amending your Excel file based on the format accepted by iSMS, save the file as CSV. Then finally, upload it to iSMS and blast out SMS to your customers in your list.
  
 +
Below is a short guide on how to convert Microsoft Excel file to CSV.
 +
 +
'''To learn how to compose CSV messages, please refer to [[How_to_Use_CSV_Compose|Compose CSV]].'''
  
  
Line 12: Line 16:
  
 
2. Open the sample CSV file at Microsoft Excel and you will see the format below.
 
2. Open the sample CSV file at Microsoft Excel and you will see the format below.
 +
  
 
'''NOTE:'''
 
'''NOTE:'''
Line 20: Line 25:
  
 
'''Final Result Hi JOHN, your credit balance is 300, please make payment to test 1'''
 
'''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]]
 
[[File:isms-bulk-sms-convert-excel-to-csv-1.jpg|thumb|500px|center|Illustration 3: Download CSV sample]]
Line 57: Line 63:
  
 
[[File:isms-bulk-sms-convert-excel-to-csv-7.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]]
 +
 +
 +
'''To learn how to compose CSV messages, please refer to [[How_to_Use_CSV_Compose|Compose CSV]].'''

Latest revision as of 17:50, 10 December 2013