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.