{"id":11624,"date":"2022-11-09T11:03:06","date_gmt":"2022-11-09T05:33:06","guid":{"rendered":"https:\/\/www.fast2sms.com\/help\/?p=11624"},"modified":"2024-02-08T16:49:50","modified_gmt":"2024-02-08T11:19:50","slug":"csv-or-excel-file","status":"publish","type":"post","link":"https:\/\/www.fast2sms.com\/help\/csv-or-excel-file\/","title":{"rendered":"How to upload a CSV or Excel file?"},"content":{"rendered":"<p style=\"text-align: justify;\">Create an Excel file of the contacts you want to send SMS to. If you want to upload a CSV file, save the file with the extension .csv after the file name. You can upload both CSV and Excel files.<\/p>\n<p style=\"text-align: justify;\">1. The following screen will appear as shown in the image below. In the Mobile Number field, select the Excel checkbox to upload your Excel or CSV file.<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12916\" src=\"https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2022\/11\/Quick-SMS-section-of-Fast2SMS.png\" alt=\"Quick SMS section of Fast2SMS\" width=\"791\" height=\"571\" srcset=\"https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2022\/11\/Quick-SMS-section-of-Fast2SMS.png 791w, https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2022\/11\/Quick-SMS-section-of-Fast2SMS-300x217.png 300w, https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2022\/11\/Quick-SMS-section-of-Fast2SMS-768x554.png 768w\" sizes=\"(max-width: 791px) 100vw, 791px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\">2. As you select the excel checkbox, you need to upload your csv or excel file from the Select tab. As shown below, a file is uploaded having three columns name, number and result.<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-11776\" src=\"https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2022\/11\/Screenshot-7.png\" alt=\"\" width=\"1291\" height=\"356\" srcset=\"https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2022\/11\/Screenshot-7.png 1291w, https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2022\/11\/Screenshot-7-300x83.png 300w, https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2022\/11\/Screenshot-7-1024x282.png 1024w, https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2022\/11\/Screenshot-7-768x212.png 768w\" sizes=\"(max-width: 1291px) 100vw, 1291px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>3. Now, select the column which has mobile numbers.<\/p>\n<p><strong>Note<\/strong>: <span style=\"text-decoration: underline;\">By default, name will appear, you need to click on the dropdown arrow to select the number option.<\/span><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12915\" src=\"https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2022\/11\/Adding-contacts-at-the-Quick-SMS-section-of-Fast2SMS.png\" alt=\"Adding contacts at the Quick SMS section of Fast2SMS\" width=\"777\" height=\"572\" srcset=\"https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2022\/11\/Adding-contacts-at-the-Quick-SMS-section-of-Fast2SMS.png 777w, https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2022\/11\/Adding-contacts-at-the-Quick-SMS-section-of-Fast2SMS-300x221.png 300w, https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2022\/11\/Adding-contacts-at-the-Quick-SMS-section-of-Fast2SMS-768x565.png 768w\" sizes=\"(max-width: 777px) 100vw, 777px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\">4. If your SMS is &#8220;Dear (name), your result is (result).&#8221; You need to select the variable from the uploaded table while writing the message and click on Send to send the SMS. It will appear as shown in the image below. Name and result will be sent accordingly. Similarly, you can add other variables as per your data and requirement.<\/p>\n<p>Dear A, your result is Pass<\/p>\n<p>Dear B, your result is Fail<\/p>\n<p>Dear C, your result is Pass<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12914\" src=\"https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2022\/11\/adding-excel-to-Quick-SMS-at-Fast2SMS.png\" alt=\"adding excel to Quick SMS at Fast2SMS\" width=\"787\" height=\"578\" srcset=\"https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2022\/11\/adding-excel-to-Quick-SMS-at-Fast2SMS.png 787w, https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2022\/11\/adding-excel-to-Quick-SMS-at-Fast2SMS-300x220.png 300w, https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2022\/11\/adding-excel-to-Quick-SMS-at-Fast2SMS-768x564.png 768w\" sizes=\"(max-width: 787px) 100vw, 787px\" \/><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Create an Excel file of the contacts you want to send SMS to. If you want to upload a CSV file, save the file with the extension .csv after the file name. You can upload both CSV and Excel files. 1. The following screen will appear as shown in the image below. In the Mobile [&hellip;]<\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_yoast_wpseo_focuskw":"","_yoast_wpseo_title":"","_yoast_wpseo_metadesc":"","footnotes":""},"categories":[1],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to upload a CSV or Excel file?<\/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\/csv-or-excel-file\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to upload a CSV or Excel file?\" \/>\n<meta property=\"og:description\" content=\"Create an Excel file of the contacts you want to send SMS to. If you want to upload a CSV file, save the file with the extension .csv after the file name. You can upload both CSV and Excel files. 1. The following screen will appear as shown in the image below. In the Mobile [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.fast2sms.com\/help\/csv-or-excel-file\/\" \/>\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=\"2022-11-09T05:33:06+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-02-08T11:19:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2022\/11\/Quick-SMS-section-of-Fast2SMS.png\" \/>\n<meta name=\"author\" content=\"Fast2SMS\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@fast2sms\" \/>\n<meta name=\"twitter:site\" content=\"@fast2sms\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Fast2SMS\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.fast2sms.com\/help\/csv-or-excel-file\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.fast2sms.com\/help\/csv-or-excel-file\/\"},\"author\":{\"name\":\"Fast2SMS\",\"@id\":\"https:\/\/www.fast2sms.com\/help\/#\/schema\/person\/8ed00ead0c1ba2b7eee1265e983d7a53\"},\"headline\":\"How to upload a CSV or Excel file?\",\"datePublished\":\"2022-11-09T05:33:06+00:00\",\"dateModified\":\"2024-02-08T11:19:50+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.fast2sms.com\/help\/csv-or-excel-file\/\"},\"wordCount\":223,\"publisher\":{\"@id\":\"https:\/\/www.fast2sms.com\/help\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.fast2sms.com\/help\/csv-or-excel-file\/\",\"url\":\"https:\/\/www.fast2sms.com\/help\/csv-or-excel-file\/\",\"name\":\"How to upload a CSV or Excel file?\",\"isPartOf\":{\"@id\":\"https:\/\/www.fast2sms.com\/help\/#website\"},\"datePublished\":\"2022-11-09T05:33:06+00:00\",\"dateModified\":\"2024-02-08T11:19:50+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.fast2sms.com\/help\/csv-or-excel-file\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.fast2sms.com\/help\/csv-or-excel-file\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.fast2sms.com\/help\/csv-or-excel-file\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.fast2sms.com\/help\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to upload a CSV or Excel file?\"}]},{\"@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\/help\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.fast2sms.com\/help\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.fast2sms.com\/help\/#organization\",\"name\":\"Fast2SMS\",\"url\":\"https:\/\/www.fast2sms.com\/help\/\",\"sameAs\":[\"https:\/\/www.facebook.com\/Fast2SMS\/\",\"https:\/\/twitter.com\/fast2sms\"],\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.fast2sms.com\/help\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2021\/01\/Fast2SMS-logo.jpg\",\"contentUrl\":\"https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2021\/01\/Fast2SMS-logo.jpg\",\"width\":210,\"height\":210,\"caption\":\"Fast2SMS\"},\"image\":{\"@id\":\"https:\/\/www.fast2sms.com\/help\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.fast2sms.com\/help\/#\/schema\/person\/8ed00ead0c1ba2b7eee1265e983d7a53\",\"name\":\"Fast2SMS\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to upload a CSV or Excel file?","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\/csv-or-excel-file\/","og_locale":"en_US","og_type":"article","og_title":"How to upload a CSV or Excel file?","og_description":"Create an Excel file of the contacts you want to send SMS to. If you want to upload a CSV file, save the file with the extension .csv after the file name. You can upload both CSV and Excel files. 1. The following screen will appear as shown in the image below. In the Mobile [&hellip;]","og_url":"https:\/\/www.fast2sms.com\/help\/csv-or-excel-file\/","og_site_name":"Fast2SMS","article_publisher":"https:\/\/www.facebook.com\/Fast2SMS\/","article_published_time":"2022-11-09T05:33:06+00:00","article_modified_time":"2024-02-08T11:19:50+00:00","og_image":[{"url":"https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2022\/11\/Quick-SMS-section-of-Fast2SMS.png"}],"author":"Fast2SMS","twitter_card":"summary_large_image","twitter_creator":"@fast2sms","twitter_site":"@fast2sms","twitter_misc":{"Written by":"Fast2SMS","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.fast2sms.com\/help\/csv-or-excel-file\/#article","isPartOf":{"@id":"https:\/\/www.fast2sms.com\/help\/csv-or-excel-file\/"},"author":{"name":"Fast2SMS","@id":"https:\/\/www.fast2sms.com\/help\/#\/schema\/person\/8ed00ead0c1ba2b7eee1265e983d7a53"},"headline":"How to upload a CSV or Excel file?","datePublished":"2022-11-09T05:33:06+00:00","dateModified":"2024-02-08T11:19:50+00:00","mainEntityOfPage":{"@id":"https:\/\/www.fast2sms.com\/help\/csv-or-excel-file\/"},"wordCount":223,"publisher":{"@id":"https:\/\/www.fast2sms.com\/help\/#organization"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.fast2sms.com\/help\/csv-or-excel-file\/","url":"https:\/\/www.fast2sms.com\/help\/csv-or-excel-file\/","name":"How to upload a CSV or Excel file?","isPartOf":{"@id":"https:\/\/www.fast2sms.com\/help\/#website"},"datePublished":"2022-11-09T05:33:06+00:00","dateModified":"2024-02-08T11:19:50+00:00","breadcrumb":{"@id":"https:\/\/www.fast2sms.com\/help\/csv-or-excel-file\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.fast2sms.com\/help\/csv-or-excel-file\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.fast2sms.com\/help\/csv-or-excel-file\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.fast2sms.com\/help\/"},{"@type":"ListItem","position":2,"name":"How to upload a CSV or Excel file?"}]},{"@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\/help\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.fast2sms.com\/help\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.fast2sms.com\/help\/#organization","name":"Fast2SMS","url":"https:\/\/www.fast2sms.com\/help\/","sameAs":["https:\/\/www.facebook.com\/Fast2SMS\/","https:\/\/twitter.com\/fast2sms"],"logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.fast2sms.com\/help\/#\/schema\/logo\/image\/","url":"https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2021\/01\/Fast2SMS-logo.jpg","contentUrl":"https:\/\/www.fast2sms.com\/help\/wp-content\/uploads\/2021\/01\/Fast2SMS-logo.jpg","width":210,"height":210,"caption":"Fast2SMS"},"image":{"@id":"https:\/\/www.fast2sms.com\/help\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.fast2sms.com\/help\/#\/schema\/person\/8ed00ead0c1ba2b7eee1265e983d7a53","name":"Fast2SMS"}]}},"_links":{"self":[{"href":"https:\/\/www.fast2sms.com\/help\/wp-json\/wp\/v2\/posts\/11624"}],"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"}],"author":[{"embeddable":true,"href":"https:\/\/www.fast2sms.com\/help\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fast2sms.com\/help\/wp-json\/wp\/v2\/comments?post=11624"}],"version-history":[{"count":14,"href":"https:\/\/www.fast2sms.com\/help\/wp-json\/wp\/v2\/posts\/11624\/revisions"}],"predecessor-version":[{"id":11772,"href":"https:\/\/www.fast2sms.com\/help\/wp-json\/wp\/v2\/posts\/11624\/revisions\/11772"}],"wp:attachment":[{"href":"https:\/\/www.fast2sms.com\/help\/wp-json\/wp\/v2\/media?parent=11624"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fast2sms.com\/help\/wp-json\/wp\/v2\/categories?post=11624"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fast2sms.com\/help\/wp-json\/wp\/v2\/tags?post=11624"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}