Category: Free Tally tools

Free Tally tools

Extract Tally ERP 9 data to Microsoft Excel

  1. Start Tally ERP 9 and open your Company
  2. Start udiMagic FREE Edition v2.0
  3. Select option “Tally to Excel”
  4. Next, type the “SQL Statement” (see samples)
  5. Click the Start button
  6. Click the “View in Excel” button to open the Tally ERP 9 output in Excel

Tally to Excel

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.

Download the udiMagic Free Edition

Free Tally tools

Export Tally data to Excel | Free tool

How can I export Tally data into Excel ?

You can use Tally ODBC feature supported by Tally Accounting software to get data from Tally into Excel. Alternatively, you can use this FREE Tally to Excel utility to get Tally data into Excel.

Supported Tally versions : Tally.ERP 9, Tally 9, Tally 8.1, Tally 7.2, Tally 6.3

Remarks:-
Tally ODBC does not expose all the fields of all tables / objects in Tally. Hence, you will be able to retrieve only the first level fields (limited fields) from Tally database tables / objects.