Thursday, February 17, 2011

How to export data’s directly in excel format from tally 7.2 and Tally 8

Tally 9 allow you to export data’s directly in excel format. But you can’t do it in tally 7.2 and tally 8.
Here is a small tutorial for you exporting tally data’s from version 7.2 in excel file.
Consider exporting daybook.Go to day book press export button or use shot cut key Alt+E. Exporting screen will displayed.
tally export screen
Press Back space on your keyboard. And select Format as ASCII (comma delimited). Now give output File Name as Daybook.csv, now select some other option you want to export from the bottom of the screen.
tally export ready screen
Press enter to accept screen. Day book is exported in to tally program folder. Check program folder for file daybook.csv,
csv file
Double click on it, the file will open in excel program. If you want it in excel work sheet file, use the option Saveas, and save it in Microsoft excel workbook (*.xls) format.

3 Ads:

Post a Comment