Tally add-ons

How to Export Data from Tally to Excel?

Bulk Invoice Printing in Tally

Are you looking for a solution to export data from Tally to Excel?

For many reasons you might need to export Item masters and Ledger masters data from Tally to Excel.

Follow the steps below to export data from Tally to Excel without any technical knowledge or third-party tools ;

  1. Download Tally to Excel add-on from here
  2. Enable the Tally to Excel add-on in the required company from which you want to export the data
  3. You will now see Tally to Excel menu on the Gateway of Tally
  4. You will now see Item master and Ledger master Tally to Excel options
  5. Once the Item or Ledger master report is loaded, click on ALT+E: Export button to export the data in excel
  6. Before you export, configure and set file format as Excel

Click Here to Download Sample Exported File Format

You can also export data from Tally to Excel using ODBC method available in Excel but it requires bit technical knowledge, supported drivers and related components.


Leave a Reply

Your email address will not be published. Required fields are marked *