https://help.tallysolutions.com/docs/te9rel64/Data_Management/DM_Outward_Connectivity.htm

Outward Connectivity

Using the outward connectivity feature of Tally.ERP 9, you can transfer data between programs without additional programming. The user can transfer data from Tally.ERP 9 to Microsoft Word or Excel.

Using the Outward Connectivity feature you can:

Generate Labels from ledger addresses stored in Tally.ERP 9

Create templates for reports, forms and plug in up-to-date data from Tally.ERP 9.

To know more click the link: Tally.ERP 9 ODBC with Microsoft Excel