Upload Contacts from Excel and Send Named Bulk SMS in Ghana

Upload Contacts from Excel and Send Named Bulk SMS in Ghana

Customer spreadsheet uploaded from Excel with phone number and first name columns, imported into a contact group, and a bulk SMS on a phone that greets Ama by name

If your customers live in an Excel sheet, you can upload contacts from Excel to a bulk SMS platform in Ghana and send each person a message with their own name in it. On Arkesel bulk SMS, you set the sheet up with one row per customer, import it into a contact group, then choose the First Name field when you write the message. Each customer receives the text with their own name filled in from the sheet.

Clean the list before you import it. On Arkesel’s promotional route, credit is charged for every number uploaded, including numbers that do not receive the message, so a dead or unwanted number on your list still costs you.

If you do not have an approved sender ID yet, submit one now, so it can be approved while you prepare your list. The section on testing and sending below explains what it is.

What should your Excel sheet look like before you upload?

Before you change anything, save a copy of your existing sheet under a different name and make every change below in the copy. Renaming headings, fixing the phone column and deleting rows all change the file, and the untouched original lets you recover a row or a number if something goes wrong.

Give the sheet one row per customer and one column per detail. Put a header row at the top so you can tell the columns apart when you map them during the import. The import can map these columns to contact fields:

  • Phone number
  • First name
  • Last name
  • Email
  • Company
  • Birth date

Every row needs a phone number. Add the other columns where you have the data and expect to use it, most often First Name. There is no sample file to download, so build the columns yourself or rename the headings on a sheet you already keep.

Save the file as CSV, XLS or XLSX. All three are accepted.

Annotated Excel sheet ready to upload: a header row, one row per customer, a phone number in every row in 0, 233 or +233 form, the phone column formatted as text, the six columns the import can map, and the CSV, XLS and XLSX file types

How should Ghana numbers be formatted in the spreadsheet?

You can leave numbers as your customers gave them. The import accepts local numbers that start with 0 (0244…), numbers that start with 233, and numbers that start with +233, and converts them to one format for you. You do not need to rewrite a mixed column before uploading.

The one thing to protect is the leading 0. Excel treats a value such as 0244… as an ordinary number and can drop the 0 when you type or paste it.

If some numbers in your phone column show only nine digits, the 0 has already been dropped. Restore them in the copy you saved, not in the original:

  1. Insert an empty helper column next to the phone column. If the first phone number is in cell A2, type =IF(LEN(A2)=9,"+233"&A2,A2) in the helper column on that row and fill it down to the last row.
  2. Copy the helper column and paste it over the phone column as values (Paste Special, then Values), so the cells hold the numbers rather than the formula.
  3. Delete the helper column.

The formula changes only nine-digit numbers, so numbers that already start with 0, 233 or +233 stay as they are.

To stop the 0 disappearing again, format the phone column as text before you add more numbers to it, and check a few rows afterwards.

How do you clean the list before a campaign?

Some of the cleaning is done for you during the import. Duplicate numbers inside the file are removed, and numbers the import cannot read as valid are counted and set aside in a list you can download. You do not need to remove repeated numbers by hand.

The rest is up to you, because it depends on what you know about your customers. If you have not saved a copy of the original file yet, do it now, so you can recover a row you removed by mistake. Then work through the copy you will upload:

  1. Where a customer has asked you not to message them again, first copy their number and the date to your own opt-out list, then delete their row. Deleting the row from your sheet does not take that customer out of a contact group you have already imported, so if they are in a saved group, remove them from the group itself before your next send. Before every later import, save a copy of the new sheet, check its numbers against your opt-out list and delete any row whose number appears there. Match on the last nine digits, because the same number can be written with 0, 233 or +233: searching the new sheet (Ctrl+F) for those nine digits finds it in any of the three forms. A customer you removed from the group is no longer in it, so without this check the import would add them back.
  2. Where a number has failed in two campaigns in a row in your delivery reports, delete it, and remove it from any saved group it is already in. If you have not sent to this list before, skip this step and come back to it once you have delivery reports from two campaigns.
  3. Where a row has a phone number but an empty first name cell, either fill the name in or move the row to a separate sheet. The section on missing names below explains what to do with that sheet.
  4. Where the first name cell holds something other than a name, such as “Madam” or a shop name, correct it. Whatever sits in the cell is what your customer will read. Get names right before the first import: a number already in the group is skipped when you import again, so a name you correct in the sheet later does not replace the one already saved.

On a promotional send, steps 1 and 2 are where the cost is decided. A number that will never receive your message, or a customer who asked to stop, adds nothing to a promotional campaign except a charge. If you are not sure which kind of message you are sending, our guide to how promotional and transactional SMS differ explains how to tell them apart.

Checklist for cleaning a contact list before import: duplicates and invalid numbers are handled by the import, while removing opted-out customers and repeatedly failed numbers, filling empty first names and correcting non-names are up to you

How do you upload contacts from Excel into Arkesel?

Importing the file into a contact group is the path to use when you will message the same customers again. The group stays saved, and every later campaign can be sent to it.

  1. Log in to your Arkesel dashboard and create a contact group, or open an existing group you want to add to. Give a new group a name you will recognise later, such as “Osu shop customers”.
  2. Choose to import contacts into that group and select your CSV, XLS or XLSX file.
  3. Say whether the file has a header row. If you added headings as described above, the answer is yes.
  4. Map each column to a contact field: phone number, first name, last name, email, company or birth date. Map every column you plan to use in a message.
  5. Wait for the import to finish. A large file is processed in the background, and you are notified when it is done. You do not need to upload the file again while it runs.
  6. Check the invalid count. The import reports how many numbers were invalid. Download the rejected list, correct those numbers in your sheet, and import the corrected rows into the same group.

When should you send straight from the file instead?

Arkesel also lets you send an SMS directly from a file without saving a contact group. This suits a one-off send, such as a message to everyone who attended a single event. Clean the file the same way before you use it.

Sending from a file has one further advantage. When you write the message, every column of the uploaded file is offered as a field, not only the contact fields listed above. If your message needs a detail such as an order number, an amount due or a pickup date, put it in its own column and send from the file.

How do you send personalised bulk SMS with each customer’s name?

You do not type a code for the name. When you write the message, Arkesel shows you a list of the fields you can insert, and you pick the one you want at the point in the message where it belongs. Only the fields the platform offers can be inserted.

For a contact group, the fields offered are First Name, Last Name, User Name, Company, Phone Number and Email Address. The useful ones are those you filled from your sheet, which for most customer lists means First Name, and Company if you sell to businesses. For a send from a file, every column of the file is offered.

As an example, a shop might write “Hi”, insert First Name, and continue with “, your order is ready for pickup at our Osu branch until Saturday.” Ama receives “Hi Ama, your order is ready for pickup at our Osu branch until Saturday.” and Kwame receives the same message with his own name. The details are filled per recipient from each contact’s own fields.

Personalised bulk SMS: First Name picked from the fields offered for a contact group fills in Ama and Kwame in the same message, and contacts with no first name get a version without the name

Keep an eye on length when a field goes in. SMS is billed per segment, not per message: a message that splits into several segments is charged as several messages, and a single non-GSM character drops segment capacity from 160 to 70 characters. A message that fits one segment with a short name can spill into two for a customer with a long name. Write the message with your longest name in mind, and watch for names typed with characters outside the standard SMS character set. Our guide to SMS length and character limits explains which characters those are.

For ideas on what to personalise beyond the name, and when it helps, read our guide to personalising bulk SMS messages.

What happens if a contact has no name in the file?

Each message takes the name from that contact’s own First Name field, so a contact whose cell is empty has no name to insert. Plan for this before you send rather than relying on a stand-in name being added. “Hi Ama, your order is ready” reads well. The same message without the name does not.

You have three choices:

  • Fill in the missing names in your sheet before you import, if you can find them.
  • Import the rows without a name into their own group, then send that group a version of the message that does not use the name: “Hello, your order is ready for pickup at our Osu branch until Saturday.”
  • Write one message that reads well without a name, and leave the field out. This suits a short announcement where the name adds little.

The separate group works best when you sort the sheet before the import. Filter the First Name column for empty cells, move those rows to their own file, and import each file into its own group.

How do you test, send and check the delivery report?

You need an approved sender ID before you send. Bulk messages go out from a sender ID, the name your customers see as the sender, and Arkesel submits yours to the Ghanaian networks for you, so submit it well before your first campaign. Step 1 of our guide on how to send bulk SMS in Ghana explains how to choose one. Your account also needs SMS credit.

Send the campaign to yourself before it goes to your customers.

  1. Create a small test group with your own number and a colleague’s, with First Name filled in, and send the message to it. Check that the name appears in the right place and that the message reads correctly.
  2. Send to the full group. When you set up the campaign, choose the contact group as the recipients and select your approved sender ID. For promotional messages, keep to the consent rules and sending hours set out in our guide on how to send bulk SMS in Ghana.
  3. Read the delivery report. The platform normally updates a message’s delivery status within about one minute of delivery and shows it in the per-recipient report. It does not send failure alerts, so the report is where you find the numbers that failed.
  4. Note the failed numbers. Where a number fails again in your next campaign, so it has failed in two campaigns in a row, remove it from the group before the one after. The copy of your original file still holds the row if you need it again.

Our guide on how to read your SMS delivery report explains what each status means and what to check when a message fails.

Frequently asked questions

Can I add new customers to the same group later?

Yes. Before you import, save a copy of the new file, check its numbers against your opt-out list and delete any row whose number appears there. A customer you removed from the group is no longer in it, so the import would add them back. Then import the file into the same contact group. Numbers already in the group are skipped and duplicates inside the file are removed, so customers you already imported are not repeated and the details saved for them do not change. Deleting a customer from your sheet before importing does not take them out of the group. Remove customers who opted out from the saved group itself.

Can I do this from my phone?

The Arkesel web dashboard works in your phone’s browser, where you can register, add contacts, compose and send a campaign. There is no app to install. Preparing and cleaning a long spreadsheet is usually easier on a computer.

Can I use the same list for birthday messages?

Yes, if you mapped a birth date column during the import. Map it the first time you import the sheet, because a later import skips numbers already in the group and will not add birth dates to them. Automated birthday messaging is switched on per contact group, and every contact in that group with a saved birth date receives the message on their birthday. Our guide on how to send birthday SMS to your contacts walks through the setup.

Send your first personalised campaign

Start with the list you already have. Save a copy, clean it, import it into a contact group and send a named test message to yourself before it reaches your customers. Create a free account to upload your first contact list, and see current pricing for SMS credit. For consent, timing and what to send, our guide to SMS marketing in Ghana covers the wider plan.

Scroll to Top