Popular Posts

  • Basic Accounting
    Basic concept of accounting Accounting: It is an art of recording, classifying and summarizing in significant manner and in terms of mo...
  • Tally Shortcut Key's
    Function Key Combination Windows Functionality Availability F1 To select a company At all masters...
  • Basic Accounting For Tally
  • Accounting Policies
    DISCLOSURE OF ACCOUNTING POLICY                                                                   Accounting policies are the speci...
  • TDS (Tax Deducted at Source) - Tally.ERP 9
    Introduction TDS refers to Tax Deducted at Source . The concept of TDS was introduced in the Income Tax Act, 1961, with the objective ...
  • Export Formats Available In Tally.Erp9
    The Export functionality available in Tally.ERP 9 allows the user to export data or report in any one of the standard available formats. ...
  • F11: Audit Features
    The Auditor needs to set the following Tax Audit Rules and Payment Due dates for various clauses: Tax Audit Rules for Amounts ...
  • Tally Erp.9 Back up of data
    Back up of data can be carried out by executing the following steps: Go to Gateway of Tally > Press F3: Company Info or Press Alt+F...
  • Import Masters (how To import Data In Tally)
    Import Formats Tally.ERP 9 supports XML format to import data.  To Import Masters execute the following steps: Go to Gateway of Ta...
  • Schedule-VI Balance Sheet
    Schedule-VI Balance Sheet provides the representation of company's financial position at any point in time in the Schedule VI format ...

Tuesday, 18 September 2012

Export Tally to Excel

Using the Export feature 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
  1. In the Balance sheet screen click E : Export or press Alt+E.
  2. Select the required language from the list of Languages displayed.
  3. Select a format from the list of Formats displayed.
  4. By default, the exported file will be stored in C:\Program Files\Tally.ERP 9 for Windows 7 and C:\Tally.ERP 9 for Windows XP operating systems
  5. Press Enter to accept the default Output Filename or type the filename of your choice in order to save the file with a different name.
  6. Press Enter to accept the default Output Sheet Name.
  7. To update the existing file select Yes in Update Existing File.
  8. To format the contents of the file select Yes in Excel (Spreadsheet) formatting.
  9. Select Yes for the Field with Colour, to retain the background colour in the exported file.
  1. Accept to export the Balance Sheet to an excel file.
The exported file is saved in the default Tally.ERP9 or the specified folder, you can use this file for further analysis.
Posted by at

4 comments:

  1. Swan Partners7 May 2018 at 22:55

    Nice blog. Keep updating..
    Accounting Firms in Perth

    ReplyDelete
  2. Ajruddin Khatri14 November 2019 at 00:55

    Want to know more about Hardware course Bahrain

    ReplyDelete
  3. Anonymous6 April 2026 at 23:39

    XLTOOL solves this problem completely by providing a live, automatic, and structured Tally to Excel export solution. With advanced real-time sync and smart automation, each voucher is exported into a clean, one-row-one-entry Excel format with proper column-wise voucher and master headings, making it extremely easy to understand, filter, and analyze. This structured approach is ideal for professionals who want accurate and ready-to-use data without spending hours cleaning Excel files.
    Link - https://xltool.in/tally-to-excel-export

    ReplyDelete
  4. NITU7 April 2026 at 08:39

    XLTOOL makes Tally to Excel export effortless. It automatically syncs vouchers in real time into a clean, one-row-per-entry Excel format with proper column-wise headings for vouchers and masters. This structured export saves hours of manual cleanup, giving professionals accurate, ready-to-use data instantly.
    Check it out here: https://xltool.in/tally-to-excel-export

    ReplyDelete

Subscribe to: Post Comments (Atom)