How to Send SMS from Excel: A Step-by-Step Guide

Do you want to send personalized and automated SMS messages to your customers, employees, or contacts using Excel? If so, you’re in the right place. In this article, I’ll show you how to send SMS from Excel in a few easy steps. You’ll also learn why Ozeki SMS Gateway is the best choice for this task.

What is Excel to SMS and How Does It Work?

Excel to SMS is a convenient Excel plug-in that sits within your spreadsheet and connects to Ozeki SMS gateway. This enables you to send thousands of SMS messages in seconds, via direct connections with the mobile operators.

To use Excel to SMS, you need to download and install Ozeki SMS Gateway and you need to connect it to the mobile network. You also need to download the Excel to SMS add-in from Then, you can select the cells that contain the phone numbers and messages you want to send and click on the “Send SMS” button on the Excel spread sheet.

You can use text data or formulas or functions to create dynamic messages based on your data.

The Excel to SMS add-in provided by Ozeki also allows you to view the delivery status and replies of your messages in Excel. Note, that unfurtounately you cannot access the full functionality of the Ozeki SMS Gateway platform directly from Excel. To configue credit management, reporting, account administration, routing, and more, you need to login on the web user interface (Web GUI) of Ozeki SMS Gateway.

Why Send SMS from Excel?

Excel is a powerful and versatile tool that can help you manage your data, perform calculations, create charts, and more. Here are some benefits of sending SMS from Excel:

You can use your existing data and contacts in Excel without having to import or export them to another platform. You can customize and personalize your SMS messages based on the data in your Excel sheet, such as names, dates, amounts, etc. You can schedule and automate your SMS campaigns using Excel formulas, macros, or VBA scripts. You can track and analyze the results of your SMS campaigns using Excel functions and features.

What do you need to Send SMS from Excel?

To send SMS from Excel, you need two things: an SMS gateway and an Excel add-in. An SMS gateway is a software or service that connects your Excel sheet to the mobile network and allows you to send and receive SMS messages. An Excel add-in is a plugin that adds extra functionality to your Excel application and enables you to communicate with the SMS gateway.

There are many SMS gateways and Excel add-ins available on the market, but not all of them are reliable, secure, and easy to use. That’s why I recommend Ozeki SMS Gateway as the best option for sending SMS from Excel.

Ozeki SMS Gateway is a powerful and flexible software that lets you send and receive SMS messages from any application or device. It supports various protocols and interfaces, such as HTTP, SMTP, SMPP, UCP, CIMD2, etc. It also works with any mobile network operator or service provider, such as GSM modems, IP SMS connections, Android phones, etc.

Ozeki SMS Gateway also offers a free Excel add-in that allows you to send SMS messages directly from your Excel sheet. You can download it from here. The installation and configuration are very simple and straightforward. You just need to enter your Ozeki SMS Gateway credentials and select the appropriate connection type.

Once you have installed the Ozeki SMS Gateway Excel add-in, you can follow these steps to send SMS from Excel:

Step 1: Open your Excel sheet that contains the data and contacts you want to send SMS messages to.

Step 2: Select the cells that contain the phone numbers of your recipients. You can select multiple cells or ranges if you want to send bulk SMS messages.

Step 3: Click on the “Send” button on the Ozeki SMS Gateway ribbon tab in Excel.

A new window will pop up where you can compose your SMS message. You can use placeholders like {A1}, {B1}, etc. to insert data from your Excel sheet into your message. For example, if you want to greet your recipients by their names, you can use {A1} as a placeholder for the name column in your sheet.

Step 4: Click on the “Send” button again to send your SMS message. You will see a confirmation message and a status report in the same window. That’s it! You have successfully sent SMS messages from Excel using Ozeki SMS Gateway.

Why Choose Ozeki SMS Gateway?

As you can see, sending SMS from Excel using Ozeki SMS Gateway is very easy and convenient. But that’s not all. Ozeki SMS Gateway also offers many other advantages over other solutions, such as:

  • High reliability and performance: Ozeki SMS Gateway can handle thousands of messages per second with minimal delays and errors.
  • High security and privacy: Ozeki SMS Gateway encrypts all your data and messages with SSL/TLS protocols and protects them from unauthorized access or interception.
  • High scalability and flexibility: Ozeki SMS Gateway can adapt to any size or complexity of your project or business. You can add or remove connections, devices, users, or applications as needed.
  • High compatibility and integration: Ozeki SMS Gateway can work with any platform or system that supports standard protocols or interfaces. You can also integrate it with other applications or services using APIs or SDKs.
  • High support and service: Ozeki SMS Gateway provides free updates and technical support for its customers. You can also access online documentation, tutorials, videos, forums, etc.


Sending SMS from Excel is a great way to communicate with your audience in a fast, effective, and personal way. With Ozeki SMS Gateway, you can easily send SMS from Excel without any hassle or compromise. Ozeki SMS Gateway is the best choice for sending SMS from Excel because it offers high reliability, security, scalability, compatibility, and support.

If you want to try Ozeki SMS Gateway for yourself, you can download a free trial from You can also contact ozeki if you have any questions or need any assistance. To get support simply create an account ht