{"id":209,"date":"2013-06-26T11:54:31","date_gmt":"2013-06-26T11:54:31","guid":{"rendered":"http:\/\/www.firetext.co.uk\/blog\/?p=209"},"modified":"2025-03-11T10:08:28","modified_gmt":"2025-03-11T10:08:28","slug":"creating-your-csv-file-its-easier-than-you-think","status":"publish","type":"post","link":"https:\/\/www.firetext.co.uk\/blog\/creating-your-csv-file-its-easier-than-you-think\/","title":{"rendered":"Creating Your CSV File &#8211; it&#8217;s Easier Than you Think!"},"content":{"rendered":"\n<p class=\"sms-box\"><strong>Update: <\/strong>Our latest video shows you how to easily upload your contacts and map custom fields in your FireText account. <strong><a href=\"https:\/\/help.firetext.co.uk\/hc\/en-gb\/articles\/360000079931-Uploading-Contacts\"> Check it out here.<\/a><\/strong><\/p>\n\n\n\n<p>At FireText we love CSV files! Seriously, they are so easy to create and will save you bags of time when uploading your contacts. Let me convert you&#8230;<\/p>\n\n\n\n<!--more-->\n\n\n\n<p>CSV (comma-separated values if you&#8217;re that\u2019s interested) is a file format that stores your data in a structured table of lists. It&#8217;s the only file you can use when uploading your contact lists to a bulk SMS platform, unless of course you want to copy and paste.<\/p>\n\n\n\n<p>I\u2019d suggest a CSV file as this can be exported from your CRM system or put together in a spreadsheet keeping all your valuable contacts in one place.<\/p>\n\n\n\n<p>All records in the file should have the same number of fields, in the same order:<\/p>\n\n\n\n<p>On FireText you can include: First Name, Last Name, Mobile Number, Custom1, Custom2, Custom3<\/p>\n\n\n\n<p>Your custom fields are optional and can be any further information on the contact you might want to include in the message i.e. Membership Number or Discount Code.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><a href=\"https:\/\/www.firetext.co.uk\/blog\/wp-content\/uploads\/2013\/06\/EXCEL.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"716\" height=\"283\" src=\"https:\/\/www.firetext.co.uk\/blog\/wp-content\/uploads\/2013\/06\/EXCEL.jpg\" alt=\"\" class=\"wp-image-210\" srcset=\"https:\/\/www.firetext.co.uk\/blog\/wp-content\/uploads\/2013\/06\/EXCEL.jpg 716w, https:\/\/www.firetext.co.uk\/blog\/wp-content\/uploads\/2013\/06\/EXCEL-300x119.jpg 300w\" sizes=\"auto, (max-width: 716px) 100vw, 716px\" \/><\/a><\/figure>\n<\/div>\n\n\n<p><\/p>\n\n\n\n<p>Check the formatting of your columns (right click, format cells) to ensure the numbers upload correctly. We know excel will remove the zero at the beginning of the number; don\u2019t worry this is normal and we have made sure the FireText system still recognises this.<\/p>\n\n\n\n<p>When you\u2019re ready you can hit \u2018save as\u2019 and simply select CSV format from the drop down list. It may pop up with a warning, this is fine, just click OK and you\u2019re done!<\/p>\n\n\n\n<p>You can now log into the <a href=\"https:\/\/app.firetext.co.uk\">FireText<\/a> platform, upload your contacts and start texting.<\/p>\n\n\n\n<p>Told you it was easy!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Update: Our latest video shows you how to easily upload your contacts and map custom fields in your FireText account. Check it out here. At FireText we love CSV files! Seriously, they are so easy to create and will save you bags of time when uploading your contacts. Let me convert you&#8230;<\/p>\n","protected":false},"author":4,"featured_media":217,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[14],"class_list":["post-209","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sms-tips","tag-creating-your-csv-file-its-easier-than-you-think"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Creating Your CSV File - it&#039;s Easier Than you Think! - SMS Marketing Blog<\/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.firetext.co.uk\/blog\/creating-your-csv-file-its-easier-than-you-think\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Creating Your CSV File - it&#039;s Easier Than you Think! - SMS Marketing Blog\" \/>\n<meta property=\"og:description\" content=\"Update: Our latest video shows you how to easily upload your contacts and map custom fields in your FireText account. Check it out here. At FireText we love CSV files! Seriously, they are so easy to create and will save you bags of time when uploading your contacts. Let me convert you&#8230;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.firetext.co.uk\/blog\/creating-your-csv-file-its-easier-than-you-think\/\" \/>\n<meta property=\"og:site_name\" content=\"SMS Marketing Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/firetext.co.uk\/\" \/>\n<meta property=\"article:published_time\" content=\"2013-06-26T11:54:31+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-03-11T10:08:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.firetext.co.uk\/blog\/wp-content\/uploads\/2013\/06\/excellogo1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"251\" \/>\n\t<meta property=\"og:image:height\" content=\"255\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Holly Barber\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@firetext_uk\" \/>\n<meta name=\"twitter:site\" content=\"@firetext_uk\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Holly Barber\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.firetext.co.uk\/blog\/creating-your-csv-file-its-easier-than-you-think\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.firetext.co.uk\/blog\/creating-your-csv-file-its-easier-than-you-think\/\"},\"author\":{\"name\":\"Holly Barber\",\"@id\":\"https:\/\/www.firetext.co.uk\/blog\/#\/schema\/person\/fbd04606e14fca821589bba7405e5d61\"},\"headline\":\"Creating Your CSV File &#8211; it&#8217;s Easier Than you Think!\",\"datePublished\":\"2013-06-26T11:54:31+00:00\",\"dateModified\":\"2025-03-11T10:08:28+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.firetext.co.uk\/blog\/creating-your-csv-file-its-easier-than-you-think\/\"},\"wordCount\":299,\"publisher\":{\"@id\":\"https:\/\/www.firetext.co.uk\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.firetext.co.uk\/blog\/creating-your-csv-file-its-easier-than-you-think\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.firetext.co.uk\/blog\/wp-content\/uploads\/2013\/06\/excellogo1.jpg\",\"keywords\":[\"Creating your CSV file - It's easier than you think.\"],\"articleSection\":[\"SMS Tips &amp; Tricks\"],\"inLanguage\":\"en-GB\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.firetext.co.uk\/blog\/creating-your-csv-file-its-easier-than-you-think\/\",\"url\":\"https:\/\/www.firetext.co.uk\/blog\/creating-your-csv-file-its-easier-than-you-think\/\",\"name\":\"Creating Your CSV File - it's Easier Than you Think! - SMS Marketing Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.firetext.co.uk\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.firetext.co.uk\/blog\/creating-your-csv-file-its-easier-than-you-think\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.firetext.co.uk\/blog\/creating-your-csv-file-its-easier-than-you-think\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.firetext.co.uk\/blog\/wp-content\/uploads\/2013\/06\/excellogo1.jpg\",\"datePublished\":\"2013-06-26T11:54:31+00:00\",\"dateModified\":\"2025-03-11T10:08:28+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.firetext.co.uk\/blog\/creating-your-csv-file-its-easier-than-you-think\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.firetext.co.uk\/blog\/creating-your-csv-file-its-easier-than-you-think\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.firetext.co.uk\/blog\/creating-your-csv-file-its-easier-than-you-think\/#primaryimage\",\"url\":\"https:\/\/www.firetext.co.uk\/blog\/wp-content\/uploads\/2013\/06\/excellogo1.jpg\",\"contentUrl\":\"https:\/\/www.firetext.co.uk\/blog\/wp-content\/uploads\/2013\/06\/excellogo1.jpg\",\"width\":251,\"height\":255},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.firetext.co.uk\/blog\/creating-your-csv-file-its-easier-than-you-think\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.firetext.co.uk\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Creating Your CSV File &#8211; it&#8217;s Easier Than you Think!\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.firetext.co.uk\/blog\/#website\",\"url\":\"https:\/\/www.firetext.co.uk\/blog\/\",\"name\":\"SMS Marketing Blog\",\"description\":\"SMS Tips, Tricks and News from FireText\",\"publisher\":{\"@id\":\"https:\/\/www.firetext.co.uk\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.firetext.co.uk\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.firetext.co.uk\/blog\/#organization\",\"name\":\"FireText\",\"url\":\"https:\/\/www.firetext.co.uk\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.firetext.co.uk\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.firetext.co.uk\/blog\/wp-content\/uploads\/2021\/07\/Firetext-logo-white-1200-728.png\",\"contentUrl\":\"https:\/\/www.firetext.co.uk\/blog\/wp-content\/uploads\/2021\/07\/Firetext-logo-white-1200-728.png\",\"width\":1200,\"height\":728,\"caption\":\"FireText\"},\"image\":{\"@id\":\"https:\/\/www.firetext.co.uk\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/firetext.co.uk\/\",\"https:\/\/x.com\/firetext_uk\",\"https:\/\/www.instagram.com\/firetext_sms\/?hl=en-gb\",\"https:\/\/www.linkedin.com\/company\/firetext-communications-ltd\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.firetext.co.uk\/blog\/#\/schema\/person\/fbd04606e14fca821589bba7405e5d61\",\"name\":\"Holly Barber\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.firetext.co.uk\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/6576825742eb1fcbbd5da42a1881ebf99f46bb8dc24836deb92109eab3c6ee3a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/6576825742eb1fcbbd5da42a1881ebf99f46bb8dc24836deb92109eab3c6ee3a?s=96&d=mm&r=g\",\"caption\":\"Holly Barber\"},\"url\":\"https:\/\/www.firetext.co.uk\/blog\/author\/h-barber\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Creating Your CSV File - it's Easier Than you Think! - SMS Marketing Blog","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.firetext.co.uk\/blog\/creating-your-csv-file-its-easier-than-you-think\/","og_locale":"en_GB","og_type":"article","og_title":"Creating Your CSV File - it's Easier Than you Think! - SMS Marketing Blog","og_description":"Update: Our latest video shows you how to easily upload your contacts and map custom fields in your FireText account. Check it out here. At FireText we love CSV files! Seriously, they are so easy to create and will save you bags of time when uploading your contacts. Let me convert you&#8230;","og_url":"https:\/\/www.firetext.co.uk\/blog\/creating-your-csv-file-its-easier-than-you-think\/","og_site_name":"SMS Marketing Blog","article_publisher":"https:\/\/www.facebook.com\/firetext.co.uk\/","article_published_time":"2013-06-26T11:54:31+00:00","article_modified_time":"2025-03-11T10:08:28+00:00","og_image":[{"width":251,"height":255,"url":"https:\/\/www.firetext.co.uk\/blog\/wp-content\/uploads\/2013\/06\/excellogo1.jpg","type":"image\/jpeg"}],"author":"Holly Barber","twitter_card":"summary_large_image","twitter_creator":"@firetext_uk","twitter_site":"@firetext_uk","twitter_misc":{"Written by":"Holly Barber","Estimated reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.firetext.co.uk\/blog\/creating-your-csv-file-its-easier-than-you-think\/#article","isPartOf":{"@id":"https:\/\/www.firetext.co.uk\/blog\/creating-your-csv-file-its-easier-than-you-think\/"},"author":{"name":"Holly Barber","@id":"https:\/\/www.firetext.co.uk\/blog\/#\/schema\/person\/fbd04606e14fca821589bba7405e5d61"},"headline":"Creating Your CSV File &#8211; it&#8217;s Easier Than you Think!","datePublished":"2013-06-26T11:54:31+00:00","dateModified":"2025-03-11T10:08:28+00:00","mainEntityOfPage":{"@id":"https:\/\/www.firetext.co.uk\/blog\/creating-your-csv-file-its-easier-than-you-think\/"},"wordCount":299,"publisher":{"@id":"https:\/\/www.firetext.co.uk\/blog\/#organization"},"image":{"@id":"https:\/\/www.firetext.co.uk\/blog\/creating-your-csv-file-its-easier-than-you-think\/#primaryimage"},"thumbnailUrl":"https:\/\/www.firetext.co.uk\/blog\/wp-content\/uploads\/2013\/06\/excellogo1.jpg","keywords":["Creating your CSV file - It's easier than you think."],"articleSection":["SMS Tips &amp; Tricks"],"inLanguage":"en-GB"},{"@type":"WebPage","@id":"https:\/\/www.firetext.co.uk\/blog\/creating-your-csv-file-its-easier-than-you-think\/","url":"https:\/\/www.firetext.co.uk\/blog\/creating-your-csv-file-its-easier-than-you-think\/","name":"Creating Your CSV File - it's Easier Than you Think! - SMS Marketing Blog","isPartOf":{"@id":"https:\/\/www.firetext.co.uk\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.firetext.co.uk\/blog\/creating-your-csv-file-its-easier-than-you-think\/#primaryimage"},"image":{"@id":"https:\/\/www.firetext.co.uk\/blog\/creating-your-csv-file-its-easier-than-you-think\/#primaryimage"},"thumbnailUrl":"https:\/\/www.firetext.co.uk\/blog\/wp-content\/uploads\/2013\/06\/excellogo1.jpg","datePublished":"2013-06-26T11:54:31+00:00","dateModified":"2025-03-11T10:08:28+00:00","breadcrumb":{"@id":"https:\/\/www.firetext.co.uk\/blog\/creating-your-csv-file-its-easier-than-you-think\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.firetext.co.uk\/blog\/creating-your-csv-file-its-easier-than-you-think\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.firetext.co.uk\/blog\/creating-your-csv-file-its-easier-than-you-think\/#primaryimage","url":"https:\/\/www.firetext.co.uk\/blog\/wp-content\/uploads\/2013\/06\/excellogo1.jpg","contentUrl":"https:\/\/www.firetext.co.uk\/blog\/wp-content\/uploads\/2013\/06\/excellogo1.jpg","width":251,"height":255},{"@type":"BreadcrumbList","@id":"https:\/\/www.firetext.co.uk\/blog\/creating-your-csv-file-its-easier-than-you-think\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.firetext.co.uk\/blog\/"},{"@type":"ListItem","position":2,"name":"Creating Your CSV File &#8211; it&#8217;s Easier Than you Think!"}]},{"@type":"WebSite","@id":"https:\/\/www.firetext.co.uk\/blog\/#website","url":"https:\/\/www.firetext.co.uk\/blog\/","name":"SMS Marketing Blog","description":"SMS Tips, Tricks and News from FireText","publisher":{"@id":"https:\/\/www.firetext.co.uk\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.firetext.co.uk\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/www.firetext.co.uk\/blog\/#organization","name":"FireText","url":"https:\/\/www.firetext.co.uk\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.firetext.co.uk\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.firetext.co.uk\/blog\/wp-content\/uploads\/2021\/07\/Firetext-logo-white-1200-728.png","contentUrl":"https:\/\/www.firetext.co.uk\/blog\/wp-content\/uploads\/2021\/07\/Firetext-logo-white-1200-728.png","width":1200,"height":728,"caption":"FireText"},"image":{"@id":"https:\/\/www.firetext.co.uk\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/firetext.co.uk\/","https:\/\/x.com\/firetext_uk","https:\/\/www.instagram.com\/firetext_sms\/?hl=en-gb","https:\/\/www.linkedin.com\/company\/firetext-communications-ltd"]},{"@type":"Person","@id":"https:\/\/www.firetext.co.uk\/blog\/#\/schema\/person\/fbd04606e14fca821589bba7405e5d61","name":"Holly Barber","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.firetext.co.uk\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/6576825742eb1fcbbd5da42a1881ebf99f46bb8dc24836deb92109eab3c6ee3a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/6576825742eb1fcbbd5da42a1881ebf99f46bb8dc24836deb92109eab3c6ee3a?s=96&d=mm&r=g","caption":"Holly Barber"},"url":"https:\/\/www.firetext.co.uk\/blog\/author\/h-barber\/"}]}},"_links":{"self":[{"href":"https:\/\/www.firetext.co.uk\/blog\/wp-json\/wp\/v2\/posts\/209","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.firetext.co.uk\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.firetext.co.uk\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.firetext.co.uk\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.firetext.co.uk\/blog\/wp-json\/wp\/v2\/comments?post=209"}],"version-history":[{"count":0,"href":"https:\/\/www.firetext.co.uk\/blog\/wp-json\/wp\/v2\/posts\/209\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.firetext.co.uk\/blog\/wp-json\/wp\/v2\/media\/217"}],"wp:attachment":[{"href":"https:\/\/www.firetext.co.uk\/blog\/wp-json\/wp\/v2\/media?parent=209"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.firetext.co.uk\/blog\/wp-json\/wp\/v2\/categories?post=209"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.firetext.co.uk\/blog\/wp-json\/wp\/v2\/tags?post=209"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}