{"id":3258,"date":"2012-09-27T16:49:50","date_gmt":"2012-09-27T16:49:50","guid":{"rendered":"https:\/\/www.snapsurveys.com\/support-snap11\/?page_id=3258"},"modified":"2018-10-04T13:03:02","modified_gmt":"2018-10-04T12:03:02","slug":"exporting-data-snap-excel","status":"publish","type":"page","link":"https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/exporting-data-snap-excel\/","title":{"rendered":"Exporting Data from Snap to Excel"},"content":{"rendered":"<p>Exporting data from Snap into other applications such as Excel can be carried out in the steps below. The example used is based on the\u00a0<strong>snCrocodile<\/strong>\u00a0survey located in your Snap\u00a0<strong>Survey Overview<\/strong>\u00a0window.<\/p>\n<div>\n<h3>Step 1<\/h3>\n<p>Open the survey and click on the <strong>Data Entry<\/strong>\u00a0button <img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-21728\" src=\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2012\/10\/DataEntry.png\" alt=\"Data Entry\" width=\"24\" height=\"22\" \/>\u00a0to open the data entry window.<\/p>\n<\/div>\n<div>\n<h3>Step\u00a02<\/h3>\n<p>From the main toolbar select\u00a0<strong>File | Export<\/strong>. This will open the\u00a0<strong>Data Export<\/strong>\u00a0window.<\/p>\n<div><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-25015\" src=\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2017\/03\/DataExportWindow-v4.gif\" alt=\"DataExportWindow-v4\" width=\"397\" height=\"353\" srcset=\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2017\/03\/DataExportWindow-v4.gif 397w, https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2017\/03\/DataExportWindow-v4-150x133.gif 150w\" sizes=\"auto, (max-width: 397px) 100vw, 397px\" \/><\/div>\n<\/div>\n<div>\n<h3>Step\u00a03<\/h3>\n<p>Select\u00a0the following options:<\/p>\n<ul>\n<li><strong>Format dropdown list:<\/strong>\u00a0When exporting into Excel, select\u00a0<strong>Excel (CSV)<\/strong>.<\/li>\n<li><strong>Destination section:<\/strong>\u00a0Choose\u00a0<strong>File. Browse<\/strong>\u00a0to select the destination where your file will be saved. Snap will generate a file name which is derived from the survey name.<\/li>\n<li><strong>Export section:<\/strong>\u00a0If all questions and responses are to be exported, leave the\u00a0<strong>Filter<\/strong>\u00a0and <strong>Content<\/strong> blank. Otherwise specify which questions you require for example if questions 1 to 5 need to be exported, the following would be typed into Content:\u00a0<strong>Q1 to Q5<\/strong>. A\u00a0<strong>Filter<\/strong>\u00a0can also be applied (if necessary) e.g. for people aged under 18 the filter would be Q9=1.<\/li>\n<li><strong>Export Options:<\/strong>\u00a0Select\u00a0&#8216;Expand Multiples&#8217; only if you require multiple choice questions to be expanded into individual columns &#8211; that is one column per answer rather than one column per question.<br \/>\nSelect Code Labels if you wish to see the codes as labels rather than numerical values.<br \/>\nSelect &#8216;Label Row&#8217; if you wish to export the question text as a second header row in the CSV.<\/li>\n<\/ul>\n<\/div>\n<div>\n<h3>Step 4<\/h3>\n<p>Click\u00a0<strong>OK<\/strong>. You will see a count of the number of cases that has been exported in the Export dialog. Click &#8216;<strong>Done<\/strong>&#8216;.<\/p>\n<div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-25023\" src=\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2017\/03\/Export-v3.gif\" alt=\"Export\" width=\"210\" height=\"101\" srcset=\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2017\/03\/Export-v3.gif 210w, https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2017\/03\/Export-v3-150x72.gif 150w\" sizes=\"auto, (max-width: 210px) 100vw, 210px\" \/><\/p>\n<\/div>\n<\/div>\n<div>\n<h3>Step 5<\/h3>\n<p>Open Excel.<\/p>\n<\/div>\n<div>\n<h3>Step 6<\/h3>\n<p>Browse to locate your saved file. Ensure the files type is set to &#8216;<em>All files<\/em>&#8216; to allow you to browse files with extensions other than xls (Excel files).<\/p>\n<\/div>\n<div>\n<h3>Step 7<\/h3>\n<p>Open up the file and view the data.<\/p>\n<div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-21703\" src=\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2012\/09\/DBOutput-1.png\" alt=\"DBOutput\" width=\"836\" height=\"118\" srcset=\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2012\/09\/DBOutput-1.png 836w, https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2012\/09\/DBOutput-1-768x108.png 768w, https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2012\/09\/DBOutput-1-150x21.png 150w, https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2012\/09\/DBOutput-1-500x71.png 500w\" sizes=\"auto, (max-width: 836px) 100vw, 836px\" \/><\/p>\n<\/div>\n<\/div>\n<p>If there is a topic you would like a worksheet on, email to <a title=\"\" href=\"mailto:snapideas@snapsurveys.com\" target=\"_self\">snapideas@snapsurveys.com<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p><a class=\"ninja_pages_read_more\"  href=\"https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/exporting-data-snap-excel\/\"><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"parent":43,"menu_order":47,"comment_status":"open","ping_status":"closed","template":"page-templates\/child-page.php","meta":{"_acf_changed":false,"footnotes":""},"class_list":{"0":"post-3258","1":"page","2":"type-page","3":"status-publish","5":"search_category-support-hub"},"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Exporting Data from Snap to Excel - Snap Surveys<\/title>\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Exporting Data from Snap to Excel - Snap Surveys\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/exporting-data-snap-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Snap Surveys\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SnapSurveys\" \/>\n<meta property=\"article:modified_time\" content=\"2018-10-04T12:03:02+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@snapsurveys\" \/>\n<meta name=\"twitter:label1\" content=\"Estimated 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.snapsurveys.com\/support-snap11\/worksheets\/exporting-data-snap-excel\/\",\"url\":\"https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/exporting-data-snap-excel\/\",\"name\":\"Exporting Data from Snap to Excel - Snap Surveys\",\"isPartOf\":{\"@id\":\"https:\/\/www.snapsurveys.com\/support-snap11\/#website\"},\"datePublished\":\"2012-09-27T16:49:50+00:00\",\"dateModified\":\"2018-10-04T12:03:02+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/exporting-data-snap-excel\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/exporting-data-snap-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/exporting-data-snap-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.snapsurveys.com\/support-snap11\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Worksheets\",\"item\":\"https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Exporting Data from Snap to Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.snapsurveys.com\/support-snap11\/#website\",\"url\":\"https:\/\/www.snapsurveys.com\/support-snap11\/\",\"name\":\"Snap Surveys\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.snapsurveys.com\/support-snap11\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Exporting Data from Snap to Excel - Snap Surveys","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"en_GB","og_type":"article","og_title":"Exporting Data from Snap to Excel - Snap Surveys","og_url":"https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/exporting-data-snap-excel\/","og_site_name":"Snap Surveys","article_publisher":"https:\/\/www.facebook.com\/SnapSurveys","article_modified_time":"2018-10-04T12:03:02+00:00","twitter_card":"summary_large_image","twitter_site":"@snapsurveys","twitter_misc":{"Estimated reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/exporting-data-snap-excel\/","url":"https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/exporting-data-snap-excel\/","name":"Exporting Data from Snap to Excel - Snap Surveys","isPartOf":{"@id":"https:\/\/www.snapsurveys.com\/support-snap11\/#website"},"datePublished":"2012-09-27T16:49:50+00:00","dateModified":"2018-10-04T12:03:02+00:00","breadcrumb":{"@id":"https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/exporting-data-snap-excel\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/exporting-data-snap-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/exporting-data-snap-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.snapsurveys.com\/support-snap11\/"},{"@type":"ListItem","position":2,"name":"Worksheets","item":"https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/"},{"@type":"ListItem","position":3,"name":"Exporting Data from Snap to Excel"}]},{"@type":"WebSite","@id":"https:\/\/www.snapsurveys.com\/support-snap11\/#website","url":"https:\/\/www.snapsurveys.com\/support-snap11\/","name":"Snap Surveys","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.snapsurveys.com\/support-snap11\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"}]}},"_links":{"self":[{"href":"https:\/\/www.snapsurveys.com\/support-snap11\/wp-json\/wp\/v2\/pages\/3258","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.snapsurveys.com\/support-snap11\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.snapsurveys.com\/support-snap11\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.snapsurveys.com\/support-snap11\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.snapsurveys.com\/support-snap11\/wp-json\/wp\/v2\/comments?post=3258"}],"version-history":[{"count":10,"href":"https:\/\/www.snapsurveys.com\/support-snap11\/wp-json\/wp\/v2\/pages\/3258\/revisions"}],"predecessor-version":[{"id":25025,"href":"https:\/\/www.snapsurveys.com\/support-snap11\/wp-json\/wp\/v2\/pages\/3258\/revisions\/25025"}],"up":[{"embeddable":true,"href":"https:\/\/www.snapsurveys.com\/support-snap11\/wp-json\/wp\/v2\/pages\/43"}],"wp:attachment":[{"href":"https:\/\/www.snapsurveys.com\/support-snap11\/wp-json\/wp\/v2\/media?parent=3258"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}