Popular Posts

Tuesday, 18 September 2012

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. Tally.ERP 9 allows the user to select the required format before exporting the data and based on the format selected the user needs to specify the resolution, page size and formatting.
Tally.ERP 9 also allows you to export the data in non-editable formats such as JPEG and PDF formats. The JPEG format has the with dual facility, where the user can store the file in printable format or as an image.

ASCII (Comma Delimited)

By selecting the ASCII (Comma Delimited) format, the user can export all the reports or data from Tally.ERP 9. The data exported is converted to plain text separated with commas and stored in a file with the extension .txt. This file format is widely used for emailing and used for importing data into another company using Tally.ERP 9

Excel Spreadsheet

The user can export data and reports generated in Tally.ERP 9 to Excel by selecting the Excel (Spreadsheet) format. The report or data is put in columns and the file is saved with the extension .xls. Tally.ERP 9 also gives the user an option to export data with formatting and background colour as it appears in Tally.ERP 9. The user can set the formatting and background colour in the Report Generation screen. The Excel file can be emailed as an attachment and also used to generate graphs for better presentation.
Note: Export to Excel is compatible with Microsoft Office 97 or higher versions only.
Tally.ERP 9 exports the data faster when Excel (Spreadsheet) Formatting is set to No

HTML (Web Publishing)

On selecting the HTML (Web Publishing) format, Tally.ERP 9 exports the data in HTML format retaining the colours and formatting. The file name has an extension .htm, It can be sent as an attachment and read using an internet browser. It is recommended to choose a higher resolution for better quality output.

JPEG (Image)

On selecting this format the specified report is exported as an image file which is stored with an extension .jpg in the specified folder. The image file generated is non-editable, platform independent and supports the highest level of compression. The user needs to specify the paper orientation and paper size, opting to store the report on a User defined or customised paper size, the user is required to specify the page width and height in millimeters. This image file can be mailed as an attachment to a recipient, viewed using an image viewer and printed.

PDF (Portable Document Format)

The report is converted to a portable data format document which is independent of the application software, hardware and operating system. This document can be viewed using the Adobe Acrobat Reader commonly known as the PDF Reader. On exporting the data using PDF format, the file is stored in the specified location and assigned the extension .pdf. While configuring the system to export data to PDF it is necessary for the user to specify the paper orientation and paper size. On opting to store the report with User defined or customised paper dimensions, the user is required to specify the page width and height in millimeters. This PDF file can be mailed as an attachment to the desired recipient and viewed using the Adobe Acrobat reader or PDF reader.

XML (data interchange)

Extensible Markup Language (XML) is an extension of HTML. Using XML, data can be imported by other systems. An XML file from Tally.ERP 9 has an XML envelope and formatted with XML tags to enable import into other systems. The destination system requires re-formatting of XSLT (XML Style Sheets) based on the inherent style used in Tally before importing the data. When two systems are running different versions of Tally, XML data can be directly imported using the import menu option, without re-formatting.
Note :Data stored in Tally 7.2 can be exported to Tally 9 or Tally.ERP 9. However data stored in Tally 9 or Tally.ERP cannot be exported to Tally 7.2.
The exported files an any of the selected format are stored in C:\Tally.ERP 9 for Windows XP and C:\Program Files\ Tally.ERP9 for Windows 7 operating system.


  1. Thanks for Help.
    If want import Excel Data to Tally Try this software with easy help - www.xl.nikash.in

  2. Mazenet, Authorized Five Star Sales and Service Partner for, Tally in coimbatore
    Tally Accounting Software
    is popular for all businesses.