Chapter 07 · Part 1
How to Create a CSV File in Excel
Building your recipient list in Excel is straightforward — the key is the phone-number format. Every Malaysian number must start with 60. Here’s how to set that up and save a clean CSV.
Building your CSV in Excel
60123456789) in the first column. You can also download the sample CSV from the CSV Compose page to start from.- 1
Arrange your data
Lay your data out in the CSV column order, with the mobile number (starting 60) in the first column.
- 2
Select the phone numbers
Highlight all the phone numbers, right-click, and choose Format Cells.
- 3
Apply the 60 format
Choose Custom and enter
60##########(60 followed by ten#symbols), then click OK. Excel adds the 60 prefix to every number.
The phone-number format
The custom mask 60########## keeps the country code on every number and stops Excel dropping leading digits.
- 4
Save as CSV
Go to File → Save As and choose CSV (Comma delimited) (.csv) as the file type.
- 5
Confirm the CSV format
When Excel asks, confirm you want to keep the CSV format. Your file is now ready to upload to iSMS.
Your CSV is ready — head to CSV Compose to upload and send.