Export data from Tally.ERP 9 in Excel Format
Last Updated on
Tally ERP 9 has a wonderful option to export data’s from Software to some another format for the use of data’s
- To create some extra report that tally erp 9 does not have
- For sending an attachment in emails
- To upload files in another websites like e-filing of return.
- For publishing in a website like a page you are reading.
- To import data’s in another company of Tally ERP 9.
Currently Tally Allow us to export in Seven standard formats.ASCII (Comma delimited), Excel (Spreadsheet), HTML (web-publishing), JPEG(Image), PDF (Portable Document Format), XML (data interchange) SDF (using SDF Utility).
Here in this Lesson we will learn how to export Tally Data into Excel Format.
Let’s Export the daybook of ABC Ltd from 01-04-2016 to 31-05-2016
Go to Gateway of Tally>Display>Day book
Click on Export Button at the top of the screen. or use short cut key for Export Alt+E.
Language: Default ( All language)
Format: Excel ( Spread Sheet)
Export Location: Type the location of the file to be exported default location is C:\Program Files\Tally.ERP9, You can change it something like C:\Users\Ayana\Desktop to get the file on desktop.
Output File Name: Default file name is associated with the name of report, here Daybook.xlsx. You can change the File name if required. We can name it something like ‘name.xlsx’. The file extension must be xlsx.
Output Sheet Name: This is the name of excel sheet, the data to be exported.Normally excel open with sheet1, sheet2,sheet3, you can give name of your choice.
Updating Existing file: This is useful when you have already exported a file with same name in the same location.Then the existing file will be updated. No new file will be created.
Open Exported File: This will open the excel file immediately after exporting
You can bring some additional information like Data in detailed format,Voucher Numbers, Narrations,bill-wise details,cost center details,Inventory details by activating these options provided in the export screen.
Now click on export button or press enter,The file will be exported to your computer where you have mentioned the location.
Here is a typical daybook exported in tally erp 9.
Data’s can be exported to Jpeg,pdf , csv & xls also, we will discuss those functions in next sessions.