export tally to excel

hi anybdy can tell me if my salary is 15000/- pm then how can we divided into following heads :

Basic Salary

HR

CONVEYANCE

OTHER,

How can we do, or wht % we adopt for spilt in above parts.

Hi!  Can anyone pls tell me how to export tally data into excel? I m using Tally 5.4

i'm using tally 7.2

what should i do to export data to excel format

even can i use alt +p+alt+p

alt + e works properly on every version of tally..

Dear Sonika,

Please first you should go to ledger pressing D -  A  -  L  and now pres Alt+E in Tally 7.2 version to export after then exportign form will be appear the go to formt tab and select HTML format then goto output file name i.e. Tally.htm rename the file Tally.xls after then press enter to export file.

if any query please email khan_idreesh @ rediffmail.com

Mik Sean

Where it goes after Exporting

ALT+P+ALT+P IS WORKING BUT THE FORMAT IS .EXP

AND I WANT TO CONVERT IT TO .XLS

WHAT IS THE FORMAT 

IS THIS .EXP OR .XLS

Follow the steps below to Export Data From Tally
Path: Go to Gateway of Tally -> Display -> Trail Balance -> click on Export

Click on export option in the above screen then the below screen will appear, here you have to select the format PDF/Excel/HTML etc.

Export Location: Select the path where you want to save export file. Based on requirement you have to enable other options.

If you want to change format from PDF to Excel, you can change in the above screen and the data will export from Tally to Excel.

And, you can enable other options based on requirement like, page size, page orientation, show opening balances, show transactions and show closing balances etc.

Go and check in export location whether the file was successfully saved or not.

I hope this helps!

Paul Wilson

If you are looking for a simple and efficient way to export data from Tally to Excel, you can try a dedicated utility instead of manual methods or ODBC.

The Tally to Excel Export Utility by XLTOOL allows one-click export of voucher transactions, ledgers, stock items, cost centers, and other master data directly into Excel. It supports all versions including Tally Prime, Tally ERP 9, and even older versions, with no limitation on data size or number of companies. This helps save significant time and reduces manual errors while preparing reports or analysis.

You can download and try the utility from here:
👉 Download XLTOOL Utility

It’s especially useful for accountants who regularly need structured Excel reports from Tally data.