{"id":254,"date":"2018-10-15T18:47:42","date_gmt":"2018-10-15T13:17:42","guid":{"rendered":"https:\/\/www.rtslink.com\/tally-erp\/?p=254"},"modified":"2018-10-15T18:47:42","modified_gmt":"2018-10-15T13:17:42","slug":"extract-tally-erp-9-data-to-excel-using-free-tool","status":"publish","type":"post","link":"https:\/\/www.rtslink.com\/tally-erp\/2018\/10\/extract-tally-erp-9-data-to-excel-using-free-tool\/","title":{"rendered":"Extract Tally ERP 9 data to Microsoft Excel"},"content":{"rendered":"<ol>\n<li>Start Tally ERP 9 and open your Company<\/li>\n<li>Start udiMagic FREE Edition v2.0<\/li>\n<li>Select option &#8220;Tally to Excel&#8221;<\/li>\n<li>Next, type the &#8220;SQL Statement&#8221; (see <a href=\"https:\/\/www.rtslink.com\/free-tally-utilities\/udimagic-free-edition\/\" target=\"_blank\" rel=\"noopener\">samples<\/a>)<\/li>\n<li>Click the Start button<\/li>\n<li>Click the &#8220;View in Excel&#8221; button to open the Tally ERP 9 output in Excel<\/li>\n<\/ol>\n<p><strong>Tally to Excel<\/strong><\/p>\n<p><span style=\"display: inline !important; float: none; background-color: transparent; color: #333333; font-family: 'Helvetica Neue',Helvetica,Arial,sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px;\">The Tally to Excel feature enables you to export data from Tally ERP 9 to MS-Excel. Though, Tally ERP 9 has inbuilt support to export data into MS-Excel format, this functionality is primarily restricted to export of Tally Reports and NOT raw data or selective raw-data. Contrary to this, udiMagic Free Edition allows you to retrieve selective raw-data using SQL-SELECT statements. <\/span><\/p>\n<p><a href=\"https:\/\/www.rtslink.com\/free-tally-utilities\/udimagic-free-edition\/\" target=\"_blank\" rel=\"noopener\">Download the udiMagic Free Edition<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Start Tally ERP 9 and open your Company Start udiMagic FREE Edition v2.0 Select option &#8220;Tally to Excel&#8221; Next, type the &#8220;SQL Statement&#8221; (see samples) Click the Start button Click the &#8220;View in Excel&#8221; button to open the Tally ERP 9 output in Excel Tally to Excel The Tally to Excel feature enables you to<\/p>\n<div><a class=\"btn-filled btn\" href=\"https:\/\/www.rtslink.com\/tally-erp\/2018\/10\/extract-tally-erp-9-data-to-excel-using-free-tool\/\" title=\"Extract Tally ERP 9 data to Microsoft Excel\">Read More<\/a><\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[31],"tags":[],"class_list":["post-254","post","type-post","status-publish","format-standard","hentry","category-free-tally-tools"],"_links":{"self":[{"href":"https:\/\/www.rtslink.com\/tally-erp\/wp-json\/wp\/v2\/posts\/254","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rtslink.com\/tally-erp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rtslink.com\/tally-erp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rtslink.com\/tally-erp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rtslink.com\/tally-erp\/wp-json\/wp\/v2\/comments?post=254"}],"version-history":[{"count":1,"href":"https:\/\/www.rtslink.com\/tally-erp\/wp-json\/wp\/v2\/posts\/254\/revisions"}],"predecessor-version":[{"id":255,"href":"https:\/\/www.rtslink.com\/tally-erp\/wp-json\/wp\/v2\/posts\/254\/revisions\/255"}],"wp:attachment":[{"href":"https:\/\/www.rtslink.com\/tally-erp\/wp-json\/wp\/v2\/media?parent=254"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rtslink.com\/tally-erp\/wp-json\/wp\/v2\/categories?post=254"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rtslink.com\/tally-erp\/wp-json\/wp\/v2\/tags?post=254"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}