How do I send personalised SMS to a list from Excel?
Updated
Put your contacts in an Excel sheet with column names in the first row (for example Name, Phone, Balance), upload it to Bulk SMS Uganda as a contact list, then write your message using fields like #Name# and #Balance#. Each contact receives the message with their own values filled in.
1. Set up your spreadsheet
Use one row per contact and put the column names in the first row. Any column can be used as a field in your message:
| Name | Phone | Balance |
|---|---|---|
| Grace | 0772123456 | 45,000 |
| Peter | +256701234567 | 12,500 |
Phone numbers can be in any common Ugandan format — 0772123456, 772123456, 256772123456 or +256772123456 — and are converted to +256 format before sending.
2. Upload it as a contact list
Create a new contact list in the dashboard, name it, and upload the .xlsx file. The columns from the first row become the list's fields.
3. Write the message with fields
On the list's send page, click a field name to insert it into your message. Fields are written between # signs and must match the column name exactly:
Dear #Name#, your balance is UGX #Balance#. Thank you for banking with us.Grace receives “Dear Grace, your balance is UGX 45,000. Thank you for banking with us.” and Peter receives the same message with his own name and balance.
Then choose the column that holds the phone numbers as the recipient field, and send now or schedule for later.
How personalisation affects credits
Credits are counted per recipient after the fields are filled in. A long name or value can push one contact's message past 160 characters, making it two credits for that contact. The platform works out the exact total for the whole list — and checks your balance covers it — before the send starts.
Contacts whose phone number is missing or malformed are skipped and not charged.
Related questions
How do I insert a contact's name into a bulk SMS?
Include a Name column in your Excel sheet, upload it as a contact list, and write #Name# in your message where the name should appear.
Can I reuse the same contact list?
Yes. Contact lists are saved to your account, so you can send new campaigns to the same list at any time.
What happens to rows with invalid phone numbers?
They are skipped when the list is sent and no credits are used for them.
Try it free with 5 SMS credits
Pay-as-you-go, credits never expire, and no credit card is needed to start.
Create a free account