{"id":45826,"date":"2018-08-30T04:45:46","date_gmt":"2018-08-30T04:45:46","guid":{"rendered":"https:\/\/www.sogolytics.com\/help\/?page_id=45826"},"modified":"2022-04-15T07:18:05","modified_gmt":"2022-04-15T07:18:05","slug":"export-data-to-ms-excel","status":"publish","type":"page","link":"https:\/\/www.sogolytics.com\/help\/export-data-to-ms-excel\/","title":{"rendered":"Export Data to MS Excel"},"content":{"rendered":"

Under the Report tab, you analyze aggregate information about your survey responses. To extract raw data, you can navigate to the Data tab and download\/export your raw response in the format of your choice.<\/p>\n

For example, let\u2019s say you\u2019d like your data in an Excel spreadsheet. Not a problem! As soon as you have results, you can seamlessly download survey data into Excel for additional analysis outside the Sogolytics platform at any time. Sogolytics\u2019s Data tab gives you instant access to your data in the format that you need.<\/p>\n

Below is a step-by-step guide to export survey data in Excel:<\/p>\n

    \n
  1. Select your survey, then click Data. From the Export options presented, click on Excel.<\/li>\n

    <\/p>\n

  2. A pop-up will appear, asking you to prepare your raw data for export. Click Continue to proceed.<\/li>\n

    <\/p>\n

  3. As your data is prepared, you can navigate to other sections to complete any other tasks. A confirmation email will be sent to the email address you identified under Settings as a notification when the export process is completed.<\/li>\n

    <\/p>\n

  4. Once your data is prepared, click on Export Responses.<\/li>\n
    <\/i><\/p>\n

    You can directly export raw data to Excel once your survey is prepared. You will not need to prepare data for your survey again unless you have received a new response for your survey, excluded a response, or made textual changes to your survey questions.<\/p>\n<\/div>\n

  5. On the \u2018Select Survey Questions\u2019 step, you may choose to select all or selected question for which you would like to export your raw data.<\/li>\n
  6. Click on Continue to add additional attributes or click Export Now to export your raw data in Excel.<\/li>\n
  7. In the \u2018Select Export Attributes\u2019 step, you may customize the attributes to be included. Options include Respondent, Response, and Assessment Attributes. Click Continue to proceed.<\/li>\n
      \n
    • Email Address will only be displayed for Unique invitations\/Access Codes or survey participation using authentication.<\/li>\n
    • IP address will only be displayed if the survey is not anonymous.<\/li>\n
    • Exclude responses will be enabled only for responses marked as Excluded in an individual report.<\/li>\n
    • Assessment Attributes will be enabled only for surveys under the Assessment Tool.<\/li>\n<\/ul>\n
    • Under \u2018Select Survey Conditions\u2019 step, you can:<\/li>\n
        \n
      • Filter responses based on response to a question in your survey<\/li>\n
      • Filter responses based on time period<\/li>\n<\/ul>\n
      • Next, you can assign codes to your survey. This is typically only useful when you are working with SPSS or other statistical software or need to make textual changes to your question and answer text.<\/li>\n
      • Finally, select the range of responses to export. This step is only necessary if you have more than 10,000 responses, as you may export 10,000 responses at a time. Click Export.<\/li>\n

        <\/ol>\n","protected":false},"excerpt":{"rendered":"

        Under the Report tab, you analyze aggregate information about your survey responses. To extract raw data, you can navigate to the Data tab and download\/export your raw response in the format of your choice. For example, let\u2019s say you\u2019d like your data in an Excel spreadsheet. Not a problem! As soon as you have results, you can seamlessly download survey data into Excel for additional analysis outside the Sogolytics platform at any time. Sogolytics\u2019s Data tab gives you instant access to your data in the format that you need. Below is a step-by-step guide to export survey data in Excel: Select your survey, then click Data. From the Export options presented, click on Excel. A pop-up will appear, asking you to prepare your raw data for export. Click Continue to proceed. As your data is prepared, you can navigate to other sections to complete any other tasks. A confirmation email will be sent to the email address you identified under Settings as a notification when the export process is completed. Once your data is prepared, click on Export Responses. You can directly export raw data to Excel once your survey is prepared. You will not need to prepare data for your survey again unless you have received a new response for your survey, excluded a response, or made textual changes to your survey questions. On the \u2018Select Survey Questions\u2019 step, you may choose to select all or selected question for which you would like to export your raw data. Click […]<\/p>\n","protected":false},"author":26,"featured_media":0,"parent":0,"menu_order":264,"comment_status":"closed","ping_status":"closed","template":"sogo_new_design.php","meta":{"footnotes":""},"categories":[],"tags":[292,288,289],"yoast_head":"\nHow to Export Survey Data to Ms. Excel | Sogolytics<\/title>\n<meta name=\"description\" content=\"Under the Report tab, you analyze aggregate information about your survey responses. Follow the step-by-step guide to export survey data in Excel\" \/>\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\/export-data-to-ms-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Export Survey Data to Ms. Excel | Sogolytics\" \/>\n<meta property=\"og:description\" content=\"Under the Report tab, you analyze aggregate information about your survey responses. Follow the step-by-step guide to export survey data in Excel\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sogolytics.com\/help\/export-data-to-ms-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Sogolytics\" \/>\n<meta property=\"article:modified_time\" content=\"2022-04-15T07:18:05+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\/export-data-to-ms-excel\/\",\"url\":\"https:\/\/www.sogolytics.com\/help\/export-data-to-ms-excel\/\",\"name\":\"How to Export Survey Data to Ms. Excel | Sogolytics\",\"isPartOf\":{\"@id\":\"https:\/\/www.sogolytics.com\/help\/#website\"},\"datePublished\":\"2018-08-30T04:45:46+00:00\",\"dateModified\":\"2022-04-15T07:18:05+00:00\",\"description\":\"Under the Report tab, you analyze aggregate information about your survey responses. Follow the step-by-step guide to export survey data in Excel\",\"breadcrumb\":{\"@id\":\"https:\/\/www.sogolytics.com\/help\/export-data-to-ms-excel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sogolytics.com\/help\/export-data-to-ms-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sogolytics.com\/help\/export-data-to-ms-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sogolytics.com\/help\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Export Data to MS Excel\"}]},{\"@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 Export Survey Data to Ms. Excel | Sogolytics","description":"Under the Report tab, you analyze aggregate information about your survey responses. Follow the step-by-step guide to export survey data in Excel","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\/export-data-to-ms-excel\/","og_locale":"en_US","og_type":"article","og_title":"How to Export Survey Data to Ms. Excel | Sogolytics","og_description":"Under the Report tab, you analyze aggregate information about your survey responses. Follow the step-by-step guide to export survey data in Excel","og_url":"https:\/\/www.sogolytics.com\/help\/export-data-to-ms-excel\/","og_site_name":"Sogolytics","article_modified_time":"2022-04-15T07:18:05+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\/export-data-to-ms-excel\/","url":"https:\/\/www.sogolytics.com\/help\/export-data-to-ms-excel\/","name":"How to Export Survey Data to Ms. Excel | Sogolytics","isPartOf":{"@id":"https:\/\/www.sogolytics.com\/help\/#website"},"datePublished":"2018-08-30T04:45:46+00:00","dateModified":"2022-04-15T07:18:05+00:00","description":"Under the Report tab, you analyze aggregate information about your survey responses. Follow the step-by-step guide to export survey data in Excel","breadcrumb":{"@id":"https:\/\/www.sogolytics.com\/help\/export-data-to-ms-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sogolytics.com\/help\/export-data-to-ms-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sogolytics.com\/help\/export-data-to-ms-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sogolytics.com\/help\/"},{"@type":"ListItem","position":2,"name":"Export Data to MS Excel"}]},{"@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 Export Survey Data to Ms. Excel | Sogolytics","yoast_desc":"Under the Report tab, you analyze aggregate information about your survey responses. Follow the step-by-step guide to export survey data in Excel","rankmath_title":"Export Data to MS Excel","rankmath_desc":"Under the Report tab, you analyze aggregate information about your survey responses. To extract raw data, you can navigate to the Data tab and download\/export…"},"_links":{"self":[{"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/pages\/45826"}],"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=45826"}],"version-history":[{"count":6,"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/pages\/45826\/revisions"}],"predecessor-version":[{"id":47631,"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/pages\/45826\/revisions\/47631"}],"wp:attachment":[{"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/media?parent=45826"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/categories?post=45826"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/tags?post=45826"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}