Home / About SMSGUYS

SMSGUYS · EXCEL TO SMS & SPREADSHEET MERGE

Excel to SMS: upload, personalise and send

Send thousands of personalised SMS messages from your own spreadsheet. Upload your Excel or CSV file to SMSGUYS, or send completed messages directly from desktop Excel using our add-in.

Each person receives their own details: an account balance, order number, appointment time or work instruction. You can also send the same announcement to everyone.

Registration is free. Sending requires available SMS credits.

Choose the way that suits your business

WEBSITE UPLOAD

Spreadsheet Merge SMS

Upload an Excel or CSV file containing mobile numbers and your own information. Write one template and insert the fields you want to include in each person's SMS.

No Excel add-in or formulas required. SMSGUYS combines the fields and lets you review the individual messages before sending.

Explore Spreadsheet Merge SMS

DESKTOP EXCEL

SMSGUYS Excel add-in

Prepare mobile numbers and completed messages in your worksheet. Use the SMSGUYS ribbon inside Excel to validate, check credits and send.

This option requires the installed add-in and your SMSGUYS API key.

Explore the Excel add-in

NEW · SPREADSHEET MERGE SMS

One template. Thousands of individual messages.

Your column headings. Your information. Your message.

Whether your business uses SAP, Sage, a simple business program or just Excel, save the information you need in an Excel or CSV file. Include each recipient's mobile number, then upload the file to SMSGUYS.

Use up to 10 custom merge fields, plus the mobile-number column. These fields could contain names, account numbers, balances, order references, appointment dates, branches, sites or delivery details.

Each Spreadsheet Group supports up to 10,000 data rows. File-size and import checks also apply.

Everything happens inside the website. Upload your file, select the fields to include, review the personalised messages and confirm the send. You do not need to install the Excel add-in for this workflow.

See how your spreadsheet becomes a personal message

This retail example uses three custom fields alongside the mobile-number column.

Example upload — replace masked numbers before sending
MobileNameOrderNumberBranch
27XXXXXXXXXThandi1042Sandton
27XXXXXXXXXSipho2086Rosebank

These are masked example numbers. Use valid mobile numbers belonging to recipients you are authorised to contact.

Write one message template

Hi {Name}, order {OrderNumber} is ready for collection at {Branch}.

Use the field controls for your uploaded columns to insert the matching placeholders into your message.

Each recipient receives their own details

Thandi receives

Hi Thandi, order 1042 is ready for collection at Sandton.

Sipho receives

Hi Sipho, order 2086 is ready for collection at Rosebank.

A simple process, all inside SMSGUYS

Export → Upload → Merge → Review → Send

  1. Prepare your spreadsheet. Put clear column headings in the first row. Include a mobile-number column and up to 10 fields you want to use in your messages. Use one intended message recipient per data row.
  2. Create a Spreadsheet Group. Sign in, open Bulk SMS and choose the Spreadsheet Group option. Give your group a recognisable name, upload the Excel or CSV file and identify the mobile-number column.
  3. Review and save the uploaded information. Check the rows, resolve or exclude invalid entries and ensure each mobile number matches the intended person's details before saving.
  4. Compose your message. Write your wording and insert your uploaded fields wherever you want each person's details to appear. You can include emojis too.
  5. Check the personalised messages and credits. Review the final wording, recipients and total credits required. SMSGUYS checks the completed messages after merging and whether your balance is sufficient.
  6. Confirm and send. Once you are happy with the review, confirm the send. Messages enter the sending queue. Follow their reported delivery statuses in your SMSGUYS account.

Preparing data from another business system? Check that dates, amounts and account references display as intended. If your workbook uses formulas, prepare a copy containing their calculated values before uploading.

Read our full personalised SMS from Excel guide .

Useful messages for every kind of organisation

From a small business to a large organisation, the principle is the same: use the information you already have to send each person a relevant message.

Retail

Hi {Name}, order {OrderNumber} is ready for collection at {Branch}.

Manufacturing

Hi {Name}, your order for {Product} is scheduled for dispatch on {Date}.

Mining

Hi {Name}, your induction is on {Date} at {Time}. Please report to {Venue}.

Transport

Hi {Driver}, collect load {Reference} from {Location} at {Time}.

Construction

Hi {Name}, please report to {Site} on {Date} at {Time}. Ask for {Supervisor}.

Education

Hi {ParentName}, {PupilName}'s meeting is on {Date} at {Time} in {Venue}.

Property

Hi {Name}, your inspection at {Property} is booked for {Date} at {Time}.

Accounts

Hi {Name}, account {AccountNumber} has R{Amount} outstanding. Please pay by {DueDate}.

Professional services

Hi {Name}, your appointment with {Consultant} is on {Date} at {Time}.

More personal communication. Less repetitive typing.

  • 10 custom merge fields plus your mobile-number column.
  • Up to 10,000 rows per Spreadsheet Group.
  • Up to 600 characters per final personalised message.
  • Emoji support to add personality to your wording.
  • No coding or Excel add-in required for website spreadsheet uploads.
  • No special app needed by recipients.
  • Review before sending with calculated credit requirements.
  • Delivery-status tracking inside SMSGUYS.

DESKTOP EXCEL ADD-IN

Prefer to send directly from Microsoft Excel?

Your spreadsheet can also be your sending workspace. Use the SMSGUYS add-in to send completed messages directly from desktop Excel.

Prepare mobile numbers in column A and completed messages in column B. Repeat one announcement for everyone, or prepare a different message for each row.

Use Excel formulas if you want to combine names, appointment times, account references or job details. The sending sheet should contain the completed text that each recipient must receive.

Your SMSGUYS ribbon tools

Settings Check Connection Validate Sheet Check Credits Send Active Sheet

These labels describe the Excel ribbon tools. Sending is available after successful validation and the required checks.

What a prepared Excel sending sheet looks like

Desktop add-in: completed messages ready to validate
Column A: MobileColumn B: Message
27XXXXXXXXX Hi Thabo, your appointment is on 15 October at 09:00. Please quote REF101.
27XXXXXXXXX Hi Lerato, your appointment is on 15 October at 10:30. Please quote REF102.

The masked numbers are examples, not sendable numbers. Replace them with authorised recipient numbers. Keep one recipient and one completed message per row.

The two workflows use different layouts. Website Merge SMS uses your mobile-number column and individual data fields. The desktop add-in uses a mobile-number column and a completed Message column.

Our step-by-step personalisation guide explains website merging and how to prepare completed messages in Excel.

Sending through the Excel add-in

  1. Install and connect. Obtain the current installer and your API key from SMSGUYS. Enter the key in Settings and use Check Connection.
  2. Prepare the active sheet. Put mobile numbers in column A and completed message text in column B. Review the recipients and wording.
  3. Validate Sheet. Resolve any reported problems and review the total credits required.
  4. Check Credits. Confirm that your account has sufficient credits for the prepared messages.
  5. Send Active Sheet. Review the confirmation before submitting a live send.
  6. Keep the results. Save the workbook after sending and review reported delivery statuses in your SMSGUYS account.

If you change recipients or message text after validation, validate the sheet again before sending.

Excel add-in installation and account access

The current add-in is for 64-bit Microsoft 365 desktop Excel on 64-bit Windows 10 or Windows 11 . It is a desktop Excel add-in, not an Excel Online or Mac add-in.

You need an internet connection, a SMSGUYS account, an API key and sufficient credits for live sending. Email info@smsguys.co.za for the current installation package and your key.

Follow the supplied installation instructions. If your organisation manages software installation centrally, ask its IT team to arrange the installation.

Using website Spreadsheet Merge SMS instead? You do not need to install this add-in or configure an add-in API key. Sign in to SMSGUYS and use the Spreadsheet Group option in Bulk SMS.

Understand the total before you send

Different messages can require different numbers of credits. The total reflects every completed message, including the details inserted from your spreadsheet.

For example, five messages requiring one credit each and five messages requiring two credits each need 15 credits in total.

A 600-character message is not a single-credit SMS. Longer messages can require multiple SMS parts. Emojis and other Unicode characters can also reduce the amount of text that fits into each part.

Website Merge SMS calculates credits after inserting each recipient's details. Check the final messages and total credit requirement before confirming.

Longer names, references or other values can change an individual message's length. Review the longest messages as well as the shortest.

See our SMS credits and message-length guide for further information.

Frequently asked questions

Do I need a large business system?

No. A simple Excel spreadsheet is enough. You can also use suitable information exported from an accounting, customer-management or other business system.

Does Spreadsheet Merge SMS connect directly to SAP or Sage?

This workflow uses a file exported from your system. It does not require a direct connection to that system. Developers can discuss a direct REST API integration with SMSGUYS if required.

Do I need to write code?

No programming is required for either standard workflow. Website Merge SMS inserts your uploaded fields into a template. With the desktop add-in, you can use Excel formulas to prepare completed messages before sending.

How many custom fields can I use?

Website Spreadsheet Groups support up to 10 custom merge fields, plus the mobile-number column. Choose fields that suit your organisation and the message you want to send.

How many rows can I upload?

A Spreadsheet Group supports up to 10,000 data rows. File-size limits and import checks also apply.

Can I send the same message to everyone?

Yes. In website Merge SMS, use the same wording without inserting fields. In the desktop add-in, repeat the completed message against each intended mobile number.

Can I upload fresh information each month?

Yes. Create a clearly named Spreadsheet Group for each new upload, such as “Customers October 2026”. Check the current information and preview before sending.

Can I include emojis?

Yes, website Spreadsheet Merge SMS supports emojis. They can increase the number of SMS credits required, so always check the calculated total before sending.

Can I send a message longer than 160 characters?

SMSGUYS allows up to 600 characters per final message. Longer messages can require multiple credits. Review the validation and credit results before sending.

Do recipients need an app?

No special app is required. The message is sent as an SMS to the recipient's mobile number.

Does queued mean delivered?

No. Queued means the messages are waiting to be sent. Review the reported delivery statuses in your SMSGUYS account afterwards.

Let your spreadsheet do more for your business

Less repetitive typing. More relevant communication. Send thousands of people the information that matters to them.

Registration is free. Live SMS sending requires available credits. Existing customers can sign in here.

Same trusted SMSGUYS. A completely new experience.