{"id":7740,"date":"2014-07-15T08:45:15","date_gmt":"2014-07-15T13:45:15","guid":{"rendered":"http:\/\/www.mrc-productivity.com\/docs\/?page_id=7740"},"modified":"2021-09-29T10:01:11","modified_gmt":"2021-09-29T15:01:11","slug":"exporting-retrieval-data-to-excel","status":"publish","type":"ht_kb","link":"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/exporting-retrieval-data-to-excel","title":{"rendered":"Exporting Retrieval Data to Excel"},"content":{"rendered":"\n<p>A common request from end users is the ability to export on-screen data to an Excel spreadsheet. Many m-Power templates support the ability to export to Excel and this document will cover how to enable this feature.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Video Walkthrough<\/h2>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"Export to Excel\" width=\"643\" height=\"362\" src=\"https:\/\/www.youtube.com\/embed\/JQSUPVNZq3o?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Configuration<\/h2>\n\n\n\n<p>From the &#8220;Customize&#8221; screen of the retrieval, click on &#8220;Edit Properties&#8221;. In the &#8220;Program Options&#8221; tab, find the property for &#8220;Allow Excel Export?&#8221; and set this to &#8216;Yes&#8217;. Save.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"900\" height=\"537\" src=\"https:\/\/www.mrc-productivity.com\/docs\/images\/enableExcel-900x537.png\" alt=\"\" class=\"wp-image-10913\" srcset=\"https:\/\/www.mrc-productivity.com\/docs\/images\/enableExcel-900x537.png 900w, https:\/\/www.mrc-productivity.com\/docs\/images\/enableExcel-300x179.png 300w, https:\/\/www.mrc-productivity.com\/docs\/images\/enableExcel-150x89.png 150w, https:\/\/www.mrc-productivity.com\/docs\/images\/enableExcel-768x458.png 768w, https:\/\/www.mrc-productivity.com\/docs\/images\/enableExcel-50x30.png 50w, https:\/\/www.mrc-productivity.com\/docs\/images\/enableExcel-60x36.png 60w, https:\/\/www.mrc-productivity.com\/docs\/images\/enableExcel-100x60.png 100w, https:\/\/www.mrc-productivity.com\/docs\/images\/enableExcel.png 1009w\" sizes=\"(max-width: 900px) 100vw, 900px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Runtime Usage<\/h2>\n\n\n\n<p>Once enabled, the runtime application will have a new &#8220;Export&#8221; button. Click this to select &#8220;Export to Excel&#8221;. Clicking this will generate an excel file.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"900\" height=\"386\" src=\"https:\/\/www.mrc-productivity.com\/docs\/images\/runtimeExcel-900x386.jpg\" alt=\"\" class=\"wp-image-10930\" srcset=\"https:\/\/www.mrc-productivity.com\/docs\/images\/runtimeExcel-900x386.jpg 900w, https:\/\/www.mrc-productivity.com\/docs\/images\/runtimeExcel-300x129.jpg 300w, https:\/\/www.mrc-productivity.com\/docs\/images\/runtimeExcel-150x64.jpg 150w, https:\/\/www.mrc-productivity.com\/docs\/images\/runtimeExcel-768x329.jpg 768w, https:\/\/www.mrc-productivity.com\/docs\/images\/runtimeExcel-50x21.jpg 50w, https:\/\/www.mrc-productivity.com\/docs\/images\/runtimeExcel-60x26.jpg 60w, https:\/\/www.mrc-productivity.com\/docs\/images\/runtimeExcel-100x43.jpg 100w, https:\/\/www.mrc-productivity.com\/docs\/images\/runtimeExcel.jpg 1056w\" sizes=\"(max-width: 900px) 100vw, 900px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-ht-blocks-messages wp-block-hb-message wp-block-hb-message--withicon is-style-alert\">Only data that is currently displaying on the screen will export to Excel. If needing to export all data, mrc recommends using the <a href=\"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/report-template\">report template<\/a> instead.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A common request from end users is the ability to export on-screen data to an Excel spreadsheet. Many m-Power templates support the ability to export to Excel and this document will cover how to enable this feature. Video Walkthrough Configuration From the &#8220;Customize&#8221; screen of the retrieval, click on &#8220;Edit&#8230;<\/p>\n","protected":false},"author":1,"comment_status":"closed","ping_status":"open","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[249],"ht-kb-tag":[],"class_list":["post-7740","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-retrieval"],"_links":{"self":[{"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb\/7740","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/comments?post=7740"}],"version-history":[{"count":10,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb\/7740\/revisions"}],"predecessor-version":[{"id":10931,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb\/7740\/revisions\/10931"}],"wp:attachment":[{"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/media?parent=7740"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb-category?post=7740"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb-tag?post=7740"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}