How to export data from tally to excel format in tally 6.3,tally7.2 nd tally 8.1

Exporting tally data in excel format is very important function we are looking for. Data’s in excel format is essential for a quick analysis of business results. Excel has unlimited options like using formulas, filtering, sorting data’s   and many more. Tally has limited options for data analysis. Fortunately latest versions of Tally 9 and ERP9 have the facility to export data’s directly in excel format. But in older version like tally 6.3, tally7.2, tally 8.1 do not have the facility of exporting  data’s in excel format. But there is an easier way to do this

There are two methods we are going to explain here. Earlier one is easier than latter. lets consider exporting day book of ABC LTD.

Gateway of tally » Display »Daybook

Press export button or use short cut key Alt + E a new screen will appear called report generation screen

tally export screen

Now press backspace to alter Format and output file name. change as below.

Format= ASCII (comma delimited)

output  file name  = Daybook.csv

export tally data in csv formatMake sure that format must be in ASCII and the extension of file name must be csv now press enter and accept the screen.

Go to tally program folder, if you do not go where it exists, right click on tally program icon, click on  properties, then click find target. tally program folder will open. there you can find a file called  Daybook.csv

comma seperated value fileOpen this file, data,s are displayed in columns and cells of  the excel sheet

excel sheet after exportingLets discuss the second method

Export the file in same manner and change the file extension name  as daybook.txt format should be ASCII (comma delimited).

Now open Microsoft excel, click on file, then click on open and locate the the text file we have exported in tally program folder

open filetext import wizard will appear.

text import wizard in excel

Make sure that data type is selected “Delimited“, then click on next button  to have second step of the text import wizard. in this stage select “comma” only under “Delimiters”

 

text import wizard step2

Click on finish, you will see all the data’s are imported in excel sheet.

 

 

3 Responses to “How to export data from tally to excel format in tally 6.3,tally7.2 nd tally 8.1”

  1. nishit shah says:

    hyyy !!! vary vary thnks fr this….. i was searching for it frm vry long time bt didn’t find proper solution… thnx for this… its working nd my search ends//////

  2. Muheed says:

    thank you.its very help full

  3. satish kumar p says:

    thank you, thank you vry much….

    its really helpfull to me…

Leave a Reply

© 2014 Accountinghead. All rights reserved. Site Admin · Entries RSS · Comments RSS
Powered by WordPress · Designed by Theme Junkie