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.
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.