{"id":182,"date":"2017-01-20T08:37:22","date_gmt":"2017-01-20T08:37:22","guid":{"rendered":"http:\/\/ibutton2excel.com\/?page_id=182"},"modified":"2017-01-26T04:33:33","modified_gmt":"2017-01-26T04:33:33","slug":"exporting-data-excel","status":"publish","type":"page","link":"https:\/\/ibutton2excel.com\/documentation\/exporting-data-excel\/","title":{"rendered":"Exporting Data to Excel"},"content":{"rendered":"<div class=\"wpb-content-wrapper\">[vc_row][vc_column][mk_image src=&#8221;http:\/\/ibutton2excel.com\/wp-content\/uploads\/2017\/01\/sceenshot-for-export-page.png&#8221; image_size=&#8221;full&#8221; align=&#8221;center&#8221;][vc_column_text]Once one or many records have been downloaded you can easily export them to Microsoft Excel. The first step is to click on the &#8220;Save to Workbook&#8221; button on the main toolbar.[\/vc_column_text][mk_image src=&#8221;http:\/\/ibutton2excel.com\/wp-content\/uploads\/2017\/01\/save-to-workbook-button.png&#8221;][vc_column_text]A dialog box like the one below will pop up. This allows you to specify some parameters for the Excel spreadsheet including the filename and path, worksheet name, the first data column and row, and it lets you specify if you want the serial number and tag fields to be included. Once you are happy click the &#8220;Export&#8221; (or &#8220;Export &amp; Open&#8221;) button. The excel file will then be written to disk.<\/p>\n[\/vc_column_text][mk_image src=&#8221;http:\/\/ibutton2excel.com\/wp-content\/uploads\/2017\/01\/export-dialog.png&#8221; image_size=&#8221;full&#8221; align=&#8221;center&#8221;][vc_column_text]If &#8220;Export &amp; Open&#8221; was clicked this will automatically open Excel for you to view your data.<\/p>\n[\/vc_column_text][mk_image src=&#8221;http:\/\/ibutton2excel.com\/wp-content\/uploads\/2017\/01\/export-excel-screenshot.png&#8221; image_size=&#8221;full&#8221; align=&#8221;center&#8221;][\/vc_column][\/vc_row][vc_row][vc_column][\/vc_column][\/vc_row]\n<\/div>","protected":false},"excerpt":{"rendered":"<p>[vc_row][vc_column][mk_image src=&#8221;http:\/\/ibutton2excel.com\/wp-content\/uploads\/2017\/01\/sceenshot-for-export-page.png&#8221; image_size=&#8221;full&#8221; align=&#8221;center&#8221;][vc_column_text]Once one or many records have been downloaded you can easily export them to Microsoft Excel. The first step is to click on the &#8220;Save to Workbook&#8221; button on the main toolbar.[\/vc_column_text][mk_image src=&#8221;http:\/\/ibutton2excel.com\/wp-content\/uploads\/2017\/01\/save-to-workbook-button.png&#8221;][vc_column_text]A dialog box like the one below will pop up. This allows you to specify some parameters for the Excel [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":86,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-182","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Exporting Data to Excel &#8211; iButton2Excel<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/ibutton2excel.com\/documentation\/exporting-data-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Exporting Data to Excel &#8211; iButton2Excel\" \/>\n<meta property=\"og:description\" content=\"[vc_row][vc_column][mk_image src=&#8221;http:\/\/ibutton2excel.com\/wp-content\/uploads\/2017\/01\/sceenshot-for-export-page.png&#8221; image_size=&#8221;full&#8221; align=&#8221;center&#8221;][vc_column_text]Once one or many records have been downloaded you can easily export them to Microsoft Excel. The first step is to click on the &#8220;Save to Workbook&#8221; button on the main toolbar.[\/vc_column_text][mk_image src=&#8221;http:\/\/ibutton2excel.com\/wp-content\/uploads\/2017\/01\/save-to-workbook-button.png&#8221;][vc_column_text]A dialog box like the one below will pop up. This allows you to specify some parameters for the Excel [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ibutton2excel.com\/documentation\/exporting-data-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"iButton2Excel\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ibutton2excel\/\" \/>\n<meta property=\"article:modified_time\" content=\"2017-01-26T04:33:33+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ibutton2excel.com\/documentation\/exporting-data-excel\/\",\"url\":\"https:\/\/ibutton2excel.com\/documentation\/exporting-data-excel\/\",\"name\":\"Exporting Data to Excel &#8211; iButton2Excel\",\"isPartOf\":{\"@id\":\"https:\/\/ibutton2excel.com\/#website\"},\"datePublished\":\"2017-01-20T08:37:22+00:00\",\"dateModified\":\"2017-01-26T04:33:33+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/ibutton2excel.com\/documentation\/exporting-data-excel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/ibutton2excel.com\/documentation\/exporting-data-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/ibutton2excel.com\/documentation\/exporting-data-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/ibutton2excel.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Documentation\",\"item\":\"https:\/\/ibutton2excel.com\/documentation\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Exporting Data to Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/ibutton2excel.com\/#website\",\"url\":\"https:\/\/ibutton2excel.com\/\",\"name\":\"iButton2Excel\",\"description\":\"A powerful iButton data downloader\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/ibutton2excel.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Exporting Data to Excel &#8211; iButton2Excel","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:\/\/ibutton2excel.com\/documentation\/exporting-data-excel\/","og_locale":"en_US","og_type":"article","og_title":"Exporting Data to Excel &#8211; iButton2Excel","og_description":"[vc_row][vc_column][mk_image src=&#8221;http:\/\/ibutton2excel.com\/wp-content\/uploads\/2017\/01\/sceenshot-for-export-page.png&#8221; image_size=&#8221;full&#8221; align=&#8221;center&#8221;][vc_column_text]Once one or many records have been downloaded you can easily export them to Microsoft Excel. The first step is to click on the &#8220;Save to Workbook&#8221; button on the main toolbar.[\/vc_column_text][mk_image src=&#8221;http:\/\/ibutton2excel.com\/wp-content\/uploads\/2017\/01\/save-to-workbook-button.png&#8221;][vc_column_text]A dialog box like the one below will pop up. This allows you to specify some parameters for the Excel [&hellip;]","og_url":"https:\/\/ibutton2excel.com\/documentation\/exporting-data-excel\/","og_site_name":"iButton2Excel","article_publisher":"https:\/\/www.facebook.com\/ibutton2excel\/","article_modified_time":"2017-01-26T04:33:33+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/ibutton2excel.com\/documentation\/exporting-data-excel\/","url":"https:\/\/ibutton2excel.com\/documentation\/exporting-data-excel\/","name":"Exporting Data to Excel &#8211; iButton2Excel","isPartOf":{"@id":"https:\/\/ibutton2excel.com\/#website"},"datePublished":"2017-01-20T08:37:22+00:00","dateModified":"2017-01-26T04:33:33+00:00","breadcrumb":{"@id":"https:\/\/ibutton2excel.com\/documentation\/exporting-data-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ibutton2excel.com\/documentation\/exporting-data-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/ibutton2excel.com\/documentation\/exporting-data-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/ibutton2excel.com\/"},{"@type":"ListItem","position":2,"name":"Documentation","item":"https:\/\/ibutton2excel.com\/documentation\/"},{"@type":"ListItem","position":3,"name":"Exporting Data to Excel"}]},{"@type":"WebSite","@id":"https:\/\/ibutton2excel.com\/#website","url":"https:\/\/ibutton2excel.com\/","name":"iButton2Excel","description":"A powerful iButton data downloader","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ibutton2excel.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/ibutton2excel.com\/wp-json\/wp\/v2\/pages\/182","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ibutton2excel.com\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/ibutton2excel.com\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/ibutton2excel.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ibutton2excel.com\/wp-json\/wp\/v2\/comments?post=182"}],"version-history":[{"count":4,"href":"https:\/\/ibutton2excel.com\/wp-json\/wp\/v2\/pages\/182\/revisions"}],"predecessor-version":[{"id":248,"href":"https:\/\/ibutton2excel.com\/wp-json\/wp\/v2\/pages\/182\/revisions\/248"}],"up":[{"embeddable":true,"href":"https:\/\/ibutton2excel.com\/wp-json\/wp\/v2\/pages\/86"}],"wp:attachment":[{"href":"https:\/\/ibutton2excel.com\/wp-json\/wp\/v2\/media?parent=182"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}