How to Export Tally to Excel

Export to Excel in Tally

Using the Export feature of Tally.ERP 9, you can export Tally.ERP 9 data to Excel. Data exported to Excel can be e-mailed as an attachment, used to generate graphs for better presentation and further analysis. Go to Gateway of Tally > Balance Sheet In the Balance sheet screen press E : Export. Select the required language from the list of Languages. Select a format from the list of Formats available. Press Enter to accept the default Output Filename. In case you want to save the file in another folder then type the desired path. Press Enter to accept the default Output Sheet Name. In case you are generating the same file for a second time, select Yes for the field Update Existing File. In case you want to format the contents of the file, then select Yes for the field Excel (Spreadsheet) formatting. Select Yes for the Field with Colour, if you want the background colour in the exported file. ..

Accept to export the Masters to an excel file. The exported file is saved in the default Tally.ERP 9 folder.