{"id":45841,"date":"2018-08-30T05:06:58","date_gmt":"2018-08-30T05:06:58","guid":{"rendered":"https:\/\/www.sogolytics.com\/help\/?page_id=45841"},"modified":"2020-08-15T07:59:17","modified_gmt":"2020-08-15T07:59:17","slug":"sogosurvey1-format-for-import","status":"publish","type":"page","link":"https:\/\/www.sogolytics.com\/help\/sogosurvey1-format-for-import\/","title":{"rendered":"Sogolytics1 Format for Import"},"content":{"rendered":"

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 revise 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

\n<\/i><\/p>\n

Incomplete responses are not included in Sogolytics1 export format.<\/p>\n<\/div>\n

Sogolytics1 Formatting<\/h2>\n

The format of exported responses varies from question to question. A few essentials tips will be helpful:<\/p>\n

    \n
  • \n
      \n
    • 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<\/ul>\n<\/li>\n<\/ul>\n
      \n<\/i><\/p>\n

      The system will automatically append serial numbers in case of duplicate serial entries. For example: if you have four entries by the serial name XYZ, then the remaining three entries will appear as: XYZ1, XYZ2 and XYZ3.<\/p>\n<\/div>\n

        \n
      • Word or Phrase:<\/strong>\n
          \n
        • A one word response\/answer option can be directly imported in Sogolytics1 format.<\/li>\n
        • If your answer option includes a space, like Strongly Agree, it needs to represented as: Strongly\/~~\/Agree<\/li>\n
        • 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>\n
        • Other (Please Specify) <\/strong>\n
            \n
          • 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
          • Other\/~~\/(Please\/~~\/specify):\/~~\/I\/~~\/will\/~~\/enroll\/~~\/next\/~~\/year<\/li>\n<\/ul>\n<\/li>\n
          • Ranking <\/strong>\n
              \n
            • 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
            • Represent this response like this: Paris : 2 , Hawaii : 1 , Vienna : 3<\/li>\n<\/ul>\n<\/li>\n
            • Rating Scale <\/strong>\n
                \n
              • 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
              • 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>\n
              • Multi Select <\/strong>\n
                  \n
                • Responses for a Multi Select question are usually separated by a comma.<\/li>\n
                • 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>\n
                • 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
                • 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":"

                  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 revise any Excel document that you would like to upload, so that your data is organized in such a way that importing becomes seamless. Incomplete responses are not included in Sogolytics1 export format. 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. The system will automatically append serial numbers in case of duplicate serial entries. For example: if you have four entries by the serial name XYZ, then the remaining three entries will appear as: XYZ1, XYZ2 and XYZ3. 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 […]<\/p>\n","protected":false},"author":26,"featured_media":0,"parent":0,"menu_order":269,"comment_status":"closed","ping_status":"closed","template":"sogo_new_design.php","meta":{"footnotes":""},"categories":[200],"tags":[288,289],"yoast_head":"\nSogolytics1 Format for Import - Sogolytics<\/title>\n<meta name=\"description\" content=\"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\" \/>\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\/sogosurvey1-format-for-import\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Sogolytics1 Format for Import - Sogolytics\" \/>\n<meta property=\"og:description\" content=\"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\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sogolytics.com\/help\/sogosurvey1-format-for-import\/\" \/>\n<meta property=\"og:site_name\" content=\"Sogolytics\" \/>\n<meta property=\"article:modified_time\" content=\"2020-08-15T07:59:17+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\/sogosurvey1-format-for-import\/\",\"url\":\"https:\/\/www.sogolytics.com\/help\/sogosurvey1-format-for-import\/\",\"name\":\"Sogolytics1 Format for Import - Sogolytics\",\"isPartOf\":{\"@id\":\"https:\/\/www.sogolytics.com\/help\/#website\"},\"datePublished\":\"2018-08-30T05:06:58+00:00\",\"dateModified\":\"2020-08-15T07:59:17+00:00\",\"description\":\"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\",\"breadcrumb\":{\"@id\":\"https:\/\/www.sogolytics.com\/help\/sogosurvey1-format-for-import\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sogolytics.com\/help\/sogosurvey1-format-for-import\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sogolytics.com\/help\/sogosurvey1-format-for-import\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sogolytics.com\/help\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Sogolytics1 Format for Import\"}]},{\"@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":"Sogolytics1 Format for Import - Sogolytics","description":"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","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\/sogosurvey1-format-for-import\/","og_locale":"en_US","og_type":"article","og_title":"Sogolytics1 Format for Import - Sogolytics","og_description":"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","og_url":"https:\/\/www.sogolytics.com\/help\/sogosurvey1-format-for-import\/","og_site_name":"Sogolytics","article_modified_time":"2020-08-15T07:59:17+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\/sogosurvey1-format-for-import\/","url":"https:\/\/www.sogolytics.com\/help\/sogosurvey1-format-for-import\/","name":"Sogolytics1 Format for Import - Sogolytics","isPartOf":{"@id":"https:\/\/www.sogolytics.com\/help\/#website"},"datePublished":"2018-08-30T05:06:58+00:00","dateModified":"2020-08-15T07:59:17+00:00","description":"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","breadcrumb":{"@id":"https:\/\/www.sogolytics.com\/help\/sogosurvey1-format-for-import\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sogolytics.com\/help\/sogosurvey1-format-for-import\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sogolytics.com\/help\/sogosurvey1-format-for-import\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sogolytics.com\/help\/"},{"@type":"ListItem","position":2,"name":"Sogolytics1 Format for Import"}]},{"@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":"Sogolytics1 Format for Import","yoast_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…","rankmath_title":"Sogolytics1 Format for Import","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…"},"_links":{"self":[{"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/pages\/45841"}],"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=45841"}],"version-history":[{"count":3,"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/pages\/45841\/revisions"}],"predecessor-version":[{"id":52063,"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/pages\/45841\/revisions\/52063"}],"wp:attachment":[{"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/media?parent=45841"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/categories?post=45841"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/tags?post=45841"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}