Tally Data in Excel
Tally provides data or many reports in excel. New version of Tally9 and Tallyerp provide excel facility in tally by default. But before this version in Tally 5.4, Tally 6.3 or in Tally 7.2 (except Tally 4.5), there was a trick to use tally data/reports in Excel. Tally has many reports which can be used in excel. Name of some reports are given as under:
- List of Accounts
- Vouchers
- Day Book
- Trial Balance
- Profit & Loss Account
- Balance Sheet
- List of Sundry Debtors
- List of Sundry Credits
- List of Bank Loans
- List of Unsecured Loans
- Sales Register
- Purchase Register
- Journal Register
- Columner report
- Ledger Account
- Stock Register
- Group Summary
- Movement Analysis
- Ageing Analysis
- Physical Stock Register
- and Other so many reports.
Trick to use Tally Data/Report in Excel
Open your report in tally which you want to use in Excel. Export function will help you. There are so many formats in Tally like as HTML(Web Publishing) ,SDF(Fixed Width), XML (Data Interchange) and ASCII (Comma Delimited). For selecting one Press Alt+E and set below values :
Format : ASCII (Comma Delimited)
Output File Name : tally.csv
Extension code of output file name should be CSV(Comma Separater Value) as shown in below image:-
In this way Tally.csv file can be generated. It will available in your computer in Tally folder. Clink on this file, it will be opened in Excel. Now use Save As button to save the file in Excel and use as your desire.
- Compare Two or More Years Data in Tally.
- Expert Usage of Alternate Unit in Tally
- Bank Reconciliation in Tally in Group Company
- Free Cheque Printing Software/Function in Tally
- Export Tally Data in Excel.