Saturday, December 25, 2010

How to save Tally Data in Excel

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.

Intense Debate Comments