{"id":17218,"date":"2026-09-03T13:53:04","date_gmt":"2026-09-03T08:23:04","guid":{"rendered":"https:\/\/www.fast2sms.com\/help\/?p=17218"},"modified":"2026-09-03T15:39:47","modified_gmt":"2026-09-03T10:09:47","slug":"how-to-define-variables-in-excel-and-use-them-in-fast2sms","status":"publish","type":"post","link":"https:\/\/www.fast2sms.com\/help\/how-to-define-variables-in-excel-and-use-them-in-fast2sms\/","title":{"rendered":"How to Send Variable Values Using a CSV\/Excel File in Fast2SMS?"},"content":{"rendered":"<p><span style=\"font-family: arial, helvetica, sans-serif\">Bulk SMS campaigns can be much more effective when every recipient feels the spark of personalization in the message. Instead of sending the same text to everyone, you can include variables like the customer&#8217;s name, order ID or any other information directly from an Excel file.<\/span><\/p>\n<p><span style=\"font-family: arial, helvetica, sans-serif\">In this article, you will get to know how can we define variables in Excel and their usage in Fast2SMS to create personalized message in just a few minutes.<\/span><\/p>\n<h2><strong><span style=\"font-family: arial, helvetica, sans-serif\">Step 1: Format your data file properly<\/span><\/strong><\/h2>\n<p><span style=\"font-family: arial, helvetica, sans-serif\">Everything starts with a clean spreadsheet. Open Excel and arrange your contact list into clear columns.<\/span><\/p>\n<ul>\n<li>\n<p data-path-to-node=\"6,0,0\"><span style=\"font-family: arial, helvetica, sans-serif\">Use the first row strictly for column headers (e.g., <code data-path-to-node=\"6,0,0\" data-index-in-node=\"53\">mobile<\/code>, <code data-path-to-node=\"6,0,0\" data-index-in-node=\"61\">name<\/code>, <code data-path-to-node=\"6,0,0\" data-index-in-node=\"67\">order_id<\/code>, <code data-path-to-node=\"6,0,0\" data-index-in-node=\"77\">amount<\/code>).<\/span><\/p>\n<\/li>\n<li>\n<p data-path-to-node=\"6,1,0\"><span style=\"font-family: arial, helvetica, sans-serif\">Ensure all phone numbers are valid 10-digit numbers without spaces, prefixes like <code data-path-to-node=\"6,1,0\" data-index-in-node=\"82\">+91<\/code>, or special symbols.<\/span><\/p>\n<\/li>\n<li>\n<p data-path-to-node=\"6,2,0\"><span style=\"font-family: arial, helvetica, sans-serif\">Ensure there are no empty cells in columns you plan to use inside your message.<\/span><\/p>\n<\/li>\n<\/ul>\n<p><span style=\"font-family: arial, helvetica, sans-serif\"><strong><span style=\"color: #993300\"><em>For example: \ud83d\udc47<\/em><\/span><\/strong><\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-17224\" src=\"https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2026\/09\/Code_Generated_Image-1.jpg\" alt=\"\" width=\"1596\" height=\"463\" srcset=\"https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2026\/09\/Code_Generated_Image-1.jpg 1596w, https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2026\/09\/Code_Generated_Image-1-300x87.jpg 300w, https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2026\/09\/Code_Generated_Image-1-1024x297.jpg 1024w, https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2026\/09\/Code_Generated_Image-1-768x223.jpg 768w, https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2026\/09\/Code_Generated_Image-1-1536x446.jpg 1536w\" sizes=\"auto, (max-width: 1596px) 100vw, 1596px\" \/><\/p>\n<h2><span style=\"font-family: arial, helvetica, sans-serif\">Step 2: Open the Bulk SMS section<\/span><\/h2>\n<p><span style=\"font-family: arial, helvetica, sans-serif\">Sign in to your Fast2SMS dashboard. From the main navigation menu on the left, head into the <b data-path-to-node=\"11\" data-index-in-node=\"93\">Bulk SMS<\/b> section and you will be redirected to <strong>DLT SMS.<\/strong><\/span><\/p>\n<p><a href=\"https:\/\/www.fast2sms.com\/\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-17220 size-full\" src=\"https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2026\/09\/Signup-test-WhatsApp-API-for-FREE-2048x547-1.png\" alt=\"\" width=\"2048\" height=\"547\" srcset=\"https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2026\/09\/Signup-test-WhatsApp-API-for-FREE-2048x547-1.png 2048w, https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2026\/09\/Signup-test-WhatsApp-API-for-FREE-2048x547-1-300x80.png 300w, https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2026\/09\/Signup-test-WhatsApp-API-for-FREE-2048x547-1-1024x274.png 1024w, https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2026\/09\/Signup-test-WhatsApp-API-for-FREE-2048x547-1-768x205.png 768w, https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2026\/09\/Signup-test-WhatsApp-API-for-FREE-2048x547-1-1536x410.png 1536w\" sizes=\"auto, (max-width: 2048px) 100vw, 2048px\" \/><\/a><\/p>\n<h2><span style=\"font-family: arial, helvetica, sans-serif\">Step 3: Choose your Sender ID and Template<\/span><\/h2>\n<p data-path-to-node=\"14\"><span style=\"font-family: arial, helvetica, sans-serif\">Select your registered Sender ID. Next, pick the approved DLT template you want to send. Approved templates use variable placeholders, typically formatted as <code data-path-to-node=\"15\" data-index-in-node=\"68\">{#var#}<\/code> where custom values will be inserted.<\/span><\/p>\n<p data-path-to-node=\"16,0\"><span style=\"font-family: arial, helvetica, sans-serif\"><b data-path-to-node=\"16,0\" data-index-in-node=\"0\">Template Text: <strong><span style=\"color: #993300\"><em>\ud83d\udc47<\/em><\/span><\/strong><\/b><\/span><\/p>\n<p data-path-to-node=\"16,1\"><span style=\"color: #339966;font-family: arial, helvetica, sans-serif\"><i data-path-to-node=\"16,1\" data-index-in-node=\"0\">&#8220;Dear <code data-path-to-node=\"16,1\" data-index-in-node=\"6\">{#name#}<\/code>, your order <code data-path-to-node=\"16,1\" data-index-in-node=\"27\">{#order_id#}<\/code> of Rs. <code data-path-to-node=\"16,1\" data-index-in-node=\"46\">{#amount#}<\/code> has been confirmed.&#8221;<\/i><\/span><\/p>\n<p data-path-to-node=\"16,1\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-17226\" src=\"https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2026\/09\/ChatGPT-Image-Sep-3-2026-03_02_30-PM.png\" alt=\"\" width=\"1880\" height=\"836\" srcset=\"https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2026\/09\/ChatGPT-Image-Sep-3-2026-03_02_30-PM.png 1880w, https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2026\/09\/ChatGPT-Image-Sep-3-2026-03_02_30-PM-300x133.png 300w, https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2026\/09\/ChatGPT-Image-Sep-3-2026-03_02_30-PM-1024x455.png 1024w, https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2026\/09\/ChatGPT-Image-Sep-3-2026-03_02_30-PM-768x342.png 768w, https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2026\/09\/ChatGPT-Image-Sep-3-2026-03_02_30-PM-1536x683.png 1536w\" sizes=\"auto, (max-width: 1880px) 100vw, 1880px\" \/><\/p>\n<h2><span style=\"font-family: arial, helvetica, sans-serif\">Step 4: Import your Excel Sheet<\/span><\/h2>\n<p class=\"PDq2pG_selectionAnchorContainer\" data-start=\"2670\" data-end=\"2695\"><span style=\"font-family: arial, helvetica, sans-serif\">Select the option to upload or import your recipient list, then upload your saved <code data-path-to-node=\"19\" data-index-in-node=\"82\">.csv<\/code> file. The Fast2SMS parser will read the file and automatically extract your header names (<code data-path-to-node=\"20\" data-index-in-node=\"84\">contact number<\/code>, <code data-path-to-node=\"20\" data-index-in-node=\"92\">name<\/code>, <code data-path-to-node=\"20\" data-index-in-node=\"98\">url<\/code>) so you can connect them to the template in the next step.<\/span><\/p>\n<p data-start=\"2670\" data-end=\"2695\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-17219\" src=\"https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2026\/09\/image.png\" alt=\"Defining Variables\" width=\"1546\" height=\"823\" srcset=\"https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2026\/09\/image.png 1546w, https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2026\/09\/image-300x160.png 300w, https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2026\/09\/image-1024x545.png 1024w, https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2026\/09\/image-768x409.png 768w, https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2026\/09\/image-1536x818.png 1536w\" sizes=\"auto, (max-width: 1546px) 100vw, 1546px\" \/><\/p>\n<h2><span style=\"font-family: arial, helvetica, sans-serif\">Step 5: Map variables to column headers<\/span><\/h2>\n<p data-path-to-node=\"23\"><span style=\"font-family: arial, helvetica, sans-serif\">Now, match the template placeholders with the respective columns from your uploaded file:<\/span><\/p>\n<ul data-path-to-node=\"24\">\n<li>\n<p data-path-to-node=\"24,0,0\"><span style=\"font-family: arial, helvetica, sans-serif\"><code data-path-to-node=\"24,0,0\" data-index-in-node=\"0\">{#contact_number#}<\/code> -&gt; <strong>contact number<\/strong><\/span><\/p>\n<\/li>\n<li>\n<p data-path-to-node=\"24,1,0\"><span style=\"font-family: arial, helvetica, sans-serif\"><code data-path-to-node=\"24,1,0\" data-index-in-node=\"0\">{#name#}<\/code> <span class=\"math-inline\" data-math=\"\\rightarrow\" data-index-in-node=\"13\">-&gt;<\/span> <b data-path-to-node=\"24,1,0\" data-index-in-node=\"25\">name<\/b><\/span><\/p>\n<\/li>\n<li>\n<p data-path-to-node=\"24,2,0\"><span style=\"font-family: arial, helvetica, sans-serif\"><code data-path-to-node=\"24,2,0\" data-index-in-node=\"0\">{#url#}<\/code> <span class=\"math-inline\" data-math=\"\\rightarrow\" data-index-in-node=\"11\">-&gt;<\/span> <b data-path-to-node=\"24,2,0\" data-index-in-node=\"23\">url<\/b><\/span><\/p>\n<\/li>\n<\/ul>\n<p data-path-to-node=\"25\"><span style=\"font-family: arial, helvetica, sans-serif\">Double-check this mapping carefully. If you accidentally map <code data-path-to-node=\"25\" data-index-in-node=\"61\">{#contact_number#}<\/code> to <code data-path-to-node=\"25\" data-index-in-node=\"75\">name<\/code>, your recipients will receive broken or confusing messages.<\/span><\/p>\n<p data-start=\"3045\" data-end=\"3105\"><a href=\"https:\/\/www.fast2sms.com\/\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-17221 size-full\" src=\"https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2026\/09\/Signup-test-WhatsApp-API-for-FREE-2048x547-2.png\" alt=\"\" width=\"2048\" height=\"547\" srcset=\"https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2026\/09\/Signup-test-WhatsApp-API-for-FREE-2048x547-2.png 2048w, https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2026\/09\/Signup-test-WhatsApp-API-for-FREE-2048x547-2-300x80.png 300w, https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2026\/09\/Signup-test-WhatsApp-API-for-FREE-2048x547-2-1024x274.png 1024w, https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2026\/09\/Signup-test-WhatsApp-API-for-FREE-2048x547-2-768x205.png 768w, https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2026\/09\/Signup-test-WhatsApp-API-for-FREE-2048x547-2-1536x410.png 1536w\" sizes=\"auto, (max-width: 2048px) 100vw, 2048px\" \/><\/a><\/p>\n<h2><span style=\"font-family: arial, helvetica, sans-serif\">Step 6: Verify with live previews<\/span><\/h2>\n<p data-path-to-node=\"28\"><span style=\"font-family: arial, helvetica, sans-serif\">Before triggering the campaign, inspect the generated previews. Fast2SMS will show you what the actual message will look like for rows in your file:<\/span><\/p>\n<ul data-path-to-node=\"29\">\n<li>\n<p data-path-to-node=\"29,0,0\"><span style=\"font-family: arial, helvetica, sans-serif\"><b data-path-to-node=\"29,0,0\" data-index-in-node=\"0\">Preview for Rahul:<\/b><\/span><\/p>\n<p data-path-to-node=\"29,0,1\"><span style=\"font-family: arial, helvetica, sans-serif\"><i data-path-to-node=\"29,0,1\" data-index-in-node=\"0\">&#8220;Dear <strong>Rahul<\/strong>, your order <strong>ORD1001<\/strong> of <strong>Rs. 1500<\/strong> has been confirmed.&#8221;<\/i><\/span><\/p>\n<\/li>\n<li>\n<p data-path-to-node=\"29,1,0\"><span style=\"font-family: arial, helvetica, sans-serif\"><b data-path-to-node=\"29,1,0\" data-index-in-node=\"0\">Preview for Priya:<\/b><\/span><\/p>\n<p data-path-to-node=\"29,1,1\"><span style=\"font-family: arial, helvetica, sans-serif\"><i data-path-to-node=\"29,1,1\" data-index-in-node=\"0\">&#8220;Dear <strong>Priya<\/strong>, your order <strong>ORD1002<\/strong> of <strong>Rs. 2000<\/strong> has been confirmed.&#8221;<\/i><\/span><\/p>\n<\/li>\n<\/ul>\n<p data-path-to-node=\"30\"><span style=\"font-family: arial, helvetica, sans-serif\">Use this step to check for punctuation, proper spacing around placeholders, and accurate data mapping.<\/span><\/p>\n<p data-path-to-node=\"30\"><span style=\"font-family: arial, helvetica, sans-serif\"><strong>Preview of message preview:<\/strong> <strong><span style=\"color: #993300\"><em>\ud83d\udc47<\/em><\/span><\/strong><\/span><\/p>\n<p data-path-to-node=\"30\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-17228\" src=\"https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2026\/09\/102Capture.png\" alt=\"\" width=\"913\" height=\"538\" srcset=\"https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2026\/09\/102Capture.png 913w, https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2026\/09\/102Capture-300x177.png 300w, https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2026\/09\/102Capture-768x453.png 768w\" sizes=\"auto, (max-width: 913px) 100vw, 913px\" \/><\/p>\n<h2><span style=\"font-family: arial, helvetica, sans-serif\">Step 7: Review parameters and send<\/span><\/h2>\n<p><span style=\"font-family: arial, helvetica, sans-serif\">Take a quick final check of the recipient count, selected Sender ID, and sample previews. Once satisfied, click <b data-path-to-node=\"33\" data-index-in-node=\"112\">Send<\/b>. Fast2SMS will iterate through the dataset, dynamically populate the placeholders for each contact, and deliver each text.<\/span><\/p>\n<h2><span style=\"font-family: arial, helvetica, sans-serif\">Common issues to avoid<\/span><\/h2>\n<ul>\n<li>\n<p data-path-to-node=\"36,0,0\"><span style=\"font-family: arial, helvetica, sans-serif\"><b data-path-to-node=\"36,0,0\" data-index-in-node=\"0\">Template tampering:<\/b> Do not modify any static words in the approved DLT template text. Any deviation from the registered phrasing will cause carrier level rejection.<\/span><\/p>\n<\/li>\n<li>\n<p data-path-to-node=\"36,1,0\"><span style=\"font-family: arial, helvetica, sans-serif\"><b data-path-to-node=\"36,1,0\" data-index-in-node=\"0\">Missing values:<\/b> If a row has a blank space in a mapped column, that recipient&#8217;s text may either drop the text variable or fail delivery altogether.<\/span><\/p>\n<\/li>\n<li>\n<p data-path-to-node=\"36,2,0\"><span style=\"font-family: arial, helvetica, sans-serif\"><b data-path-to-node=\"36,2,0\" data-index-in-node=\"0\">Character counts:<\/b> Dynamic data varies in length. A long customer name or multi digit ID can push your text beyond the standard 160-character limit, splitting it into a multi SMS and consuming extra credits.<\/span><\/p>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Bulk SMS campaigns can be much more effective when every recipient feels the spark of personalization in the message. Instead of sending the same text to everyone, you can include variables like the customer&#8217;s name, order ID or any other information directly from an Excel file. In this article, you will get to know how [&hellip;]<\/p>\n","protected":false},"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[],"class_list":["post-17218","post","type-post","status-publish","format-standard","hentry","category-address-book"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Send Variable Values Using a CSV\/Excel File in Fast2SMS?<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.fast2sms.com\/help\/how-to-define-variables-in-excel-and-use-them-in-fast2sms\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Send Variable Values Using a CSV\/Excel File in Fast2SMS?\" \/>\n<meta property=\"og:description\" content=\"Bulk SMS campaigns can be much more effective when every recipient feels the spark of personalization in the message. Instead of sending the same text to everyone, you can include variables like the customer&#8217;s name, order ID or any other information directly from an Excel file. In this article, you will get to know how [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.fast2sms.com\/help\/how-to-define-variables-in-excel-and-use-them-in-fast2sms\/\" \/>\n<meta property=\"og:site_name\" content=\"Fast2SMS\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/Fast2SMS\/\" \/>\n<meta property=\"article:published_time\" content=\"2026-09-03T08:23:04+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-09-03T10:09:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2026\/09\/Code_Generated_Image-1.jpg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@fast2sms\" \/>\n<meta name=\"twitter:site\" content=\"@fast2sms\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/how-to-define-variables-in-excel-and-use-them-in-fast2sms\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/how-to-define-variables-in-excel-and-use-them-in-fast2sms\\\/\"},\"author\":{\"@id\":\"https:\\\/\\\/www.fast2sms.com\\\/#organization\"},\"headline\":\"How to Send Variable Values Using a CSV\\\/Excel File in Fast2SMS?\",\"datePublished\":\"2026-09-03T08:23:04+00:00\",\"dateModified\":\"2026-09-03T10:09:47+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/how-to-define-variables-in-excel-and-use-them-in-fast2sms\\\/\"},\"wordCount\":534,\"publisher\":{\"@id\":\"https:\\\/\\\/www.fast2sms.com\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/how-to-define-variables-in-excel-and-use-them-in-fast2sms\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/Code_Generated_Image-1.jpg\",\"articleSection\":[\"Address Book\"],\"inLanguage\":\"en-IN\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/how-to-define-variables-in-excel-and-use-them-in-fast2sms\\\/\",\"url\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/how-to-define-variables-in-excel-and-use-them-in-fast2sms\\\/\",\"name\":\"How to Send Variable Values Using a CSV\\\/Excel File in Fast2SMS?\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/how-to-define-variables-in-excel-and-use-them-in-fast2sms\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/how-to-define-variables-in-excel-and-use-them-in-fast2sms\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/Code_Generated_Image-1.jpg\",\"datePublished\":\"2026-09-03T08:23:04+00:00\",\"dateModified\":\"2026-09-03T10:09:47+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/how-to-define-variables-in-excel-and-use-them-in-fast2sms\\\/#breadcrumb\"},\"inLanguage\":\"en-IN\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/how-to-define-variables-in-excel-and-use-them-in-fast2sms\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-IN\",\"@id\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/how-to-define-variables-in-excel-and-use-them-in-fast2sms\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/Code_Generated_Image-1.jpg\",\"contentUrl\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/Code_Generated_Image-1.jpg\",\"width\":1596,\"height\":463},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/how-to-define-variables-in-excel-and-use-them-in-fast2sms\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Address Book\",\"item\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/address-book\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"How to Send Variable Values Using a CSV\\\/Excel File in Fast2SMS?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/#website\",\"url\":\"https:\\\/\\\/www.fast2sms.com\\\/help\\\/\",\"name\":\"Fast2SMS\",\"description\":\"Help\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.fast2sms.com\\\/#organization\"},\"inLanguage\":\"en-IN\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.fast2sms.com\\\/#organization\",\"name\":\"Fast2SMS\",\"url\":\"https:\\\/\\\/www.fast2sms.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/www.fast2sms.com\\\/#logo\",\"url\":\"https:\\\/\\\/www.fast2sms.com\\\/Fast2SMS.png\",\"contentUrl\":\"https:\\\/\\\/www.fast2sms.com\\\/Fast2SMS.png\",\"caption\":\"Fast2SMS\"},\"image\":{\"@id\":\"https:\\\/\\\/www.fast2sms.com\\\/#logo\"},\"email\":\"support@fast2sms.com\",\"telephone\":\"+91-6262778822\",\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/Fast2SMS\",\"https:\\\/\\\/www.instagram.com\\\/fast2sms\",\"https:\\\/\\\/x.com\\\/fast2sms\",\"https:\\\/\\\/www.youtube.com\\\/Fast2SMSofficial\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/fast2sms\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Send Variable Values Using a CSV\/Excel File in Fast2SMS?","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.fast2sms.com\/help\/how-to-define-variables-in-excel-and-use-them-in-fast2sms\/","og_locale":"en_US","og_type":"article","og_title":"How to Send Variable Values Using a CSV\/Excel File in Fast2SMS?","og_description":"Bulk SMS campaigns can be much more effective when every recipient feels the spark of personalization in the message. Instead of sending the same text to everyone, you can include variables like the customer&#8217;s name, order ID or any other information directly from an Excel file. In this article, you will get to know how [&hellip;]","og_url":"https:\/\/www.fast2sms.com\/help\/how-to-define-variables-in-excel-and-use-them-in-fast2sms\/","og_site_name":"Fast2SMS","article_publisher":"https:\/\/www.facebook.com\/Fast2SMS\/","article_published_time":"2026-09-03T08:23:04+00:00","article_modified_time":"2026-09-03T10:09:47+00:00","og_image":[{"url":"https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2026\/09\/Code_Generated_Image-1.jpg","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_creator":"@fast2sms","twitter_site":"@fast2sms","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.fast2sms.com\/help\/how-to-define-variables-in-excel-and-use-them-in-fast2sms\/#article","isPartOf":{"@id":"https:\/\/www.fast2sms.com\/help\/how-to-define-variables-in-excel-and-use-them-in-fast2sms\/"},"author":{"@id":"https:\/\/www.fast2sms.com\/#organization"},"headline":"How to Send Variable Values Using a CSV\/Excel File in Fast2SMS?","datePublished":"2026-09-03T08:23:04+00:00","dateModified":"2026-09-03T10:09:47+00:00","mainEntityOfPage":{"@id":"https:\/\/www.fast2sms.com\/help\/how-to-define-variables-in-excel-and-use-them-in-fast2sms\/"},"wordCount":534,"publisher":{"@id":"https:\/\/www.fast2sms.com\/#organization"},"image":{"@id":"https:\/\/www.fast2sms.com\/help\/how-to-define-variables-in-excel-and-use-them-in-fast2sms\/#primaryimage"},"thumbnailUrl":"https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2026\/09\/Code_Generated_Image-1.jpg","articleSection":["Address Book"],"inLanguage":"en-IN"},{"@type":"WebPage","@id":"https:\/\/www.fast2sms.com\/help\/how-to-define-variables-in-excel-and-use-them-in-fast2sms\/","url":"https:\/\/www.fast2sms.com\/help\/how-to-define-variables-in-excel-and-use-them-in-fast2sms\/","name":"How to Send Variable Values Using a CSV\/Excel File in Fast2SMS?","isPartOf":{"@id":"https:\/\/www.fast2sms.com\/help\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.fast2sms.com\/help\/how-to-define-variables-in-excel-and-use-them-in-fast2sms\/#primaryimage"},"image":{"@id":"https:\/\/www.fast2sms.com\/help\/how-to-define-variables-in-excel-and-use-them-in-fast2sms\/#primaryimage"},"thumbnailUrl":"https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2026\/09\/Code_Generated_Image-1.jpg","datePublished":"2026-09-03T08:23:04+00:00","dateModified":"2026-09-03T10:09:47+00:00","breadcrumb":{"@id":"https:\/\/www.fast2sms.com\/help\/how-to-define-variables-in-excel-and-use-them-in-fast2sms\/#breadcrumb"},"inLanguage":"en-IN","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.fast2sms.com\/help\/how-to-define-variables-in-excel-and-use-them-in-fast2sms\/"]}]},{"@type":"ImageObject","inLanguage":"en-IN","@id":"https:\/\/www.fast2sms.com\/help\/how-to-define-variables-in-excel-and-use-them-in-fast2sms\/#primaryimage","url":"https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2026\/09\/Code_Generated_Image-1.jpg","contentUrl":"https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2026\/09\/Code_Generated_Image-1.jpg","width":1596,"height":463},{"@type":"BreadcrumbList","@id":"https:\/\/www.fast2sms.com\/help\/how-to-define-variables-in-excel-and-use-them-in-fast2sms\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.fast2sms.com\/help\/"},{"@type":"ListItem","position":2,"name":"Address Book","item":"https:\/\/www.fast2sms.com\/help\/address-book\/"},{"@type":"ListItem","position":3,"name":"How to Send Variable Values Using a CSV\/Excel File in Fast2SMS?"}]},{"@type":"WebSite","@id":"https:\/\/www.fast2sms.com\/help\/#website","url":"https:\/\/www.fast2sms.com\/help\/","name":"Fast2SMS","description":"Help","publisher":{"@id":"https:\/\/www.fast2sms.com\/#organization"},"inLanguage":"en-IN"},{"@type":"Organization","@id":"https:\/\/www.fast2sms.com\/#organization","name":"Fast2SMS","url":"https:\/\/www.fast2sms.com\/","logo":{"@type":"ImageObject","@id":"https:\/\/www.fast2sms.com\/#logo","url":"https:\/\/www.fast2sms.com\/Fast2SMS.png","contentUrl":"https:\/\/www.fast2sms.com\/Fast2SMS.png","caption":"Fast2SMS"},"image":{"@id":"https:\/\/www.fast2sms.com\/#logo"},"email":"support@fast2sms.com","telephone":"+91-6262778822","sameAs":["https:\/\/www.facebook.com\/Fast2SMS","https:\/\/www.instagram.com\/fast2sms","https:\/\/x.com\/fast2sms","https:\/\/www.youtube.com\/Fast2SMSofficial","https:\/\/www.linkedin.com\/company\/fast2sms"]}]}},"_links":{"self":[{"href":"https:\/\/www.fast2sms.com\/help\/wp-json\/wp\/v2\/posts\/17218","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fast2sms.com\/help\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fast2sms.com\/help\/wp-json\/wp\/v2\/types\/post"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fast2sms.com\/help\/wp-json\/wp\/v2\/comments?post=17218"}],"version-history":[{"count":5,"href":"https:\/\/www.fast2sms.com\/help\/wp-json\/wp\/v2\/posts\/17218\/revisions"}],"predecessor-version":[{"id":17223,"href":"https:\/\/www.fast2sms.com\/help\/wp-json\/wp\/v2\/posts\/17218\/revisions\/17223"}],"wp:attachment":[{"href":"https:\/\/www.fast2sms.com\/help\/wp-json\/wp\/v2\/media?parent=17218"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fast2sms.com\/help\/wp-json\/wp\/v2\/categories?post=17218"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fast2sms.com\/help\/wp-json\/wp\/v2\/tags?post=17218"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}