export tally to excel

Page no : 2

Bablu Kumar Jha (Accounts Manager) (266 Points)
Replied 11 December 2008

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

Basic Salary

CONVEYANCE

OTHER,

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

Upgrade to CAclubindia Pro. Subscribe Now!

(Guest)

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

sonika kaushik (Accountant ) (148 Points)
Replied 13 June 2009

i'm using tally 7.2

what should i do to export data to excel format

even can i use alt +p+alt+p

Apurva Chandra Sarkar (Auditor) (28 Points)
Replied 02 September 2010

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

Devraj (Accountant) (23 Points)
Replied 19 October 2010

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

Upgrade to CAclubindia Pro. Subscribe Now!

DHEERAJ AGARWAL (ACCOUNTANT) (21 Points)
Replied 02 February 2016

Where it goes after Exporting

250939 (accountant) (26 Points)
Replied 10 October 2017

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

AND I WANT TO CONVERT IT TO .XLS

250939 (accountant) (26 Points)
Replied 10 October 2017

WHAT IS THE FORMAT

IS THIS .EXP OR .XLS

Paul Wilson (Marketer) (24 Points)
Replied 15 January 2021

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