{"id":45800,"date":"2018-08-30T04:19:27","date_gmt":"2018-08-30T04:19:27","guid":{"rendered":"https:\/\/www.sogolytics.com\/help\/?page_id=45800"},"modified":"2019-11-14T04:47:48","modified_gmt":"2019-11-14T04:47:48","slug":"import-sogosurvey1-format","status":"publish","type":"page","link":"https:\/\/www.sogolytics.com\/help\/import-sogosurvey1-format\/","title":{"rendered":"Import Sogolytics1 Format"},"content":{"rendered":"<p>Sogolytics1 format is an Excel format which is only used to import responses back into the platform. Generally, it is used to upload responses received offline (paper survey responses) or to upload responses from some other survey for combined analysis. This powerful export option can also be used to review any Excel document that you would like to upload, so that your data is organized in such a way that importing becomes seamless.<\/p>\n<h2>Sogolytics1 Formatting<\/h2>\n<p>The format of exported responses varies from question to question. A few essentials tips will be helpful:<\/p>\n<ul>\n<li><strong>First Column<\/strong> in your Sogolytics1 document (serial number) must be unique to differentiate one response from another. Or, you can entirely remove this column to let the system assign an auto generated value.<\/li>\n<li><strong>Word or Phrase:<\/strong><\/li>\n<ul>\n<li>A one word response\/answer option can be directly imported in Sogolytics1 format.<\/li>\n<li>If your answer option includes a space, like Strongly Agree, it needs to represented as: Strongly\/~~\/Agree<\/li>\n<li>Similarly, when you have a comma in answer option, like Yes, I know, this needs to represented as: Yes\/~\/\/~~\/I\/~~\/know Here, we replace comma with \/~\/ and a space by \/~~\/<\/li>\n<\/ul>\n<li><strong>Other (Please Specify) <\/strong><\/li>\n<ul>\n<li>When a respondent answers your closed-ended question using \u2018Other (Please Specify)\u2019, here\u2019s how to format the example response: I will enroll next year<\/li>\n<li>Other\/~~\/(Please\/~~\/specify):\/~~\/I\/~~\/will\/~~\/enroll\/~~\/next\/~~\/year<\/li>\n<\/ul>\n<li><strong>Ranking <\/strong><\/li>\n<ul>\n<li>The Ranking question comes with a specific format. For example: You are asked to list the three best tourist destinations and you select (1) Hawaii, (2) Paris, (3) Vienna with Hawaii being the best and Vienna the third best.<\/li>\n<li>Represent this response like this: Paris : 2 , Hawaii : 1 , Vienna : 3<\/li>\n<\/ul>\n<li><strong>Rating Scale <\/strong><\/li>\n<ul>\n<li>For a Rating Scale question, you need not worry about the text that you input. All that is necessary is the numbers (weights) associated with each answer.<\/li>\n<li>For example, if you have a scale of 1 to 5 with 1 being Least Important and 5 Most Important, you need to enter the respective weight value such as 1 if someone answered Least Important.<\/li>\n<\/ul>\n<li><strong>Multi Select <\/strong><\/li>\n<ul>\n<li>Responses for a Multi Select question are usually separated by a comma.<\/li>\n<li>For example, if a respondent selects USA and Australia as their response, this can be inputted in the spreadsheet as: USA, Australia.<\/li>\n<\/ul>\n<li><strong>Open Ended questions<\/strong> (Text Box, Multiple Text Box, Demographics) do not require any formatting. If a participant has provided text as a response, you can copy and paste this directly into your spreadsheet as the answer.<\/li>\n<li><strong>Date<\/strong> needs to be entered in the same format [MM\/DD\/YYYY] or [DD\/MM\/YYYY] to be imported successfully.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Sogolytics1 format is an Excel format which is only used to import responses back into the platform. Generally, it is used to upload responses received offline (paper survey responses) or to upload responses from some other survey for combined analysis. This powerful export option can also be used to review any Excel document that you would like to upload, so that your data is organized in such a way that importing becomes seamless. Sogolytics1 Formatting The format of exported responses varies from question to question. A few essentials tips will be helpful: First Column in your Sogolytics1 document (serial number) must be unique to differentiate one response from another. Or, you can entirely remove this column to let the system assign an auto generated value. Word or Phrase: A one word response\/answer option can be directly imported in Sogolytics1 format. If your answer option includes a space, like Strongly Agree, it needs to represented as: Strongly\/~~\/Agree Similarly, when you have a comma in answer option, like Yes, I know, this needs to represented as: Yes\/~\/\/~~\/I\/~~\/know Here, we replace comma with \/~\/ and a space by \/~~\/ Other (Please Specify) When a respondent answers your closed-ended question using \u2018Other (Please Specify)\u2019, here\u2019s how to format the example response: I will enroll next year Other\/~~\/(Please\/~~\/specify):\/~~\/I\/~~\/will\/~~\/enroll\/~~\/next\/~~\/year Ranking The Ranking question comes with a specific format. For example: You are asked to list the three best tourist destinations and you select (1) Hawaii, (2) Paris, (3) Vienna with Hawaii being the best and Vienna [&hellip;]<\/p>\n","protected":false},"author":26,"featured_media":0,"parent":0,"menu_order":262,"comment_status":"closed","ping_status":"closed","template":"sogo_new_design.php","meta":{"footnotes":""},"categories":[201],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.7.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Import Sogolytics1 Format | Sogolytics<\/title>\n<meta name=\"description\" content=\"The Sogolytics1 format is an Excel format which is only used to import responses back into the platform. Visit here and follow the steps to use this cool feature.\" \/>\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.sogolytics.com\/help\/import-sogosurvey1-format\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Import Sogolytics1 Format | Sogolytics\" \/>\n<meta property=\"og:description\" content=\"The Sogolytics1 format is an Excel format which is only used to import responses back into the platform. Visit here and follow the steps to use this cool feature.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sogolytics.com\/help\/import-sogosurvey1-format\/\" \/>\n<meta property=\"og:site_name\" content=\"Sogolytics\" \/>\n<meta property=\"article:modified_time\" content=\"2019-11-14T04:47:48+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sogolytics.com\/help\/import-sogosurvey1-format\/\",\"url\":\"https:\/\/www.sogolytics.com\/help\/import-sogosurvey1-format\/\",\"name\":\"How to Import Sogolytics1 Format | Sogolytics\",\"isPartOf\":{\"@id\":\"https:\/\/www.sogolytics.com\/help\/#website\"},\"datePublished\":\"2018-08-30T04:19:27+00:00\",\"dateModified\":\"2019-11-14T04:47:48+00:00\",\"description\":\"The Sogolytics1 format is an Excel format which is only used to import responses back into the platform. Visit here and follow the steps to use this cool feature.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.sogolytics.com\/help\/import-sogosurvey1-format\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sogolytics.com\/help\/import-sogosurvey1-format\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sogolytics.com\/help\/import-sogosurvey1-format\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sogolytics.com\/help\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Import Sogolytics1 Format\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sogolytics.com\/help\/#website\",\"url\":\"https:\/\/www.sogolytics.com\/help\/\",\"name\":\"Sogolytics\",\"description\":\"Sogolytics - Online Survey Tool\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sogolytics.com\/help\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Import Sogolytics1 Format | Sogolytics","description":"The Sogolytics1 format is an Excel format which is only used to import responses back into the platform. Visit here and follow the steps to use this cool feature.","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.sogolytics.com\/help\/import-sogosurvey1-format\/","og_locale":"en_US","og_type":"article","og_title":"How to Import Sogolytics1 Format | Sogolytics","og_description":"The Sogolytics1 format is an Excel format which is only used to import responses back into the platform. Visit here and follow the steps to use this cool feature.","og_url":"https:\/\/www.sogolytics.com\/help\/import-sogosurvey1-format\/","og_site_name":"Sogolytics","article_modified_time":"2019-11-14T04:47:48+00:00","twitter_card":"summary","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sogolytics.com\/help\/import-sogosurvey1-format\/","url":"https:\/\/www.sogolytics.com\/help\/import-sogosurvey1-format\/","name":"How to Import Sogolytics1 Format | Sogolytics","isPartOf":{"@id":"https:\/\/www.sogolytics.com\/help\/#website"},"datePublished":"2018-08-30T04:19:27+00:00","dateModified":"2019-11-14T04:47:48+00:00","description":"The Sogolytics1 format is an Excel format which is only used to import responses back into the platform. Visit here and follow the steps to use this cool feature.","breadcrumb":{"@id":"https:\/\/www.sogolytics.com\/help\/import-sogosurvey1-format\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sogolytics.com\/help\/import-sogosurvey1-format\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sogolytics.com\/help\/import-sogosurvey1-format\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sogolytics.com\/help\/"},{"@type":"ListItem","position":2,"name":"Import Sogolytics1 Format"}]},{"@type":"WebSite","@id":"https:\/\/www.sogolytics.com\/help\/#website","url":"https:\/\/www.sogolytics.com\/help\/","name":"Sogolytics","description":"Sogolytics - Online Survey Tool","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sogolytics.com\/help\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"}]}},"seo_meta_info":{"yoast_noindex":"","rankmath_noindex":"","yoast_title":"How to Import Sogolytics1 Format | Sogolytics","yoast_desc":"The Sogolytics1 format is an Excel format which is only used to import responses back into the platform. Visit here and follow the steps to use this cool feature.","rankmath_title":"Import Sogolytics1 Format","rankmath_desc":"Sogolytics1 format is an Excel format which is only used to import responses back into the platform. Generally, it is used to upload responses received&hellip;"},"_links":{"self":[{"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/pages\/45800"}],"collection":[{"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/users\/26"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/comments?post=45800"}],"version-history":[{"count":10,"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/pages\/45800\/revisions"}],"predecessor-version":[{"id":49186,"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/pages\/45800\/revisions\/49186"}],"wp:attachment":[{"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/media?parent=45800"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/categories?post=45800"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/tags?post=45800"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}