Interested with Bulk SMS Philippines? Contact Us HERE

How to Create CSV File using Microsoft Excel

Creating a CSV File using Microsoft Excel

NOTE: Download the sample CSV file to begin.

Step 1 : Follow the format as shown. The mobile phone number must begin with prefix (63 for Philippines numbers).

Bulk SMS End User Guide How to Create CSV File in Excel

Step 2 : Apply the settings below in order to change the prefix.

Bulk SMS End User Guide How to Create CSV File in Excel
  1. Select and highlight the phone numbers
  2. Right click on the selected phone no, and select "Format Cells"


Step 3 : Select "Custom" and key in " 63########## " (# equals 9 times). This setting will format all phone number to 63.

Bulk SMS End User Guide How to Create CSV File in Excel

Step 4 : Save document by selecting Excel Workbook

Bulk SMS End User Guide How to Create CSV File in Excel

Step 5 : Save file as .csv format.

Bulk SMS End User Guide How to Create CSV File in Excel

The generated CSV file can be used for various purposes. Learn more about Sending SMS by CSV file