Ad Free CAclubindia and Daily Updates on your Mobile. Subscribe Now!

export tally to excel

Pooja Chopda (Practising Chartered Accountant) (931 Points)

25 April 2008

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

Reply
Follow
Share

23 Replies

Sathyanarayana.B (Senior Executive- Finance) (49 Points)
Replied 25 April 2008

hi..you are using very old version of tally.

For export...do following steps.

Select ledger for export > press export tab >selct ASCII in first place> put file name.for eg. C:\\export> at last "yes"> open new excel sheet > file > open> file name place type"c:\\export">ok> selct " delimited" > next >select "comma"> next> finish...now ur data exported and save it in separate excel sheet.

Upgrade to CAclubindia Pro. Subscribe Now!

Pooja Chopda (Practising Chartered Accountant) (931 Points)
Replied 25 April 2008

but there is no export tab as such. I cudn't find it.

Sathyanarayana.B (Senior Executive- Finance) (49 Points)
Replied 25 April 2008

in every version of tally export tad is available. Just open one ledger account and see rightside above corner..u can see

CA. Dashrath Maheshwari (TaXpert) (15103 Points)
Replied 25 April 2008

Hi Pooja,

You are right, there is no export tab,

Follow this:

Go to the ledger or any thing which you want to export>>>

Now Press Alt+P+Alt+P (Combination of 4 Keys)

Export window will come and ask abt all MR. Sathyanarayana.B has told,

So simple, isn't it ??

**DM

Prasad R (CA Final) (2128 Points)
Replied 25 April 2008

hey pooja all u need to do is press alt and E key together. after pressing alt + E a window will open. the file will get automatically exported in xml format. for changing it into excel format all u need to do is to change the format .xml to .xls and u can see the file exported generally in C drive or in the place where tally icon is i.e i i mean where the tally software is stored.

u may feel free to revert wid any further query.

Regards

Prasad.R