Exporting data from tally.- A quick Preview

What to Export ?
Tally has a facility to export its data to other applications like spreadsheets, word processing software and other database software. Export of data is provided mainly for summaries and statement reports like Trial Balance, Stock Summary, etc. You can export it to another company using Tally that will import it directly.

How to Export?
You can export all reports and statements. For this a separate export button is provided in right hand button bar. To do this go to any report e.g. day book you to export or any statement e.g. balance sheet. You would see export button on top right hand side on button bar. Press it and a screen would pop up with export related options.

The first option is format of data to be exported namely ASCII, HTML, SDF, and XML. Which ever application you are importing this data in would decide in which format you should export the data.
For statements like balance sheets and trial balance which we use to send and import file in word and excel etc. HTML format is good. We need minimum formatting in this format while using it in MS Word and MS Excel.
certain applications accept continuous data where we have defined field length. Then ASCII format is better.
For application which accept SDF and XML format these formats can be chosen.

Give a file name and the exported file is saved in the parent Tally directory on your computer. You can now use that file to import its contents into another program, send it as it is (say if it is HTML file) to a colleague or view it using a browser.

Your comments and suggestions are invited.

Shailendra Yadav

The Post is written with an aim to help Tally software users. You can consider subscribing all my post related to Tally by putting your email id in the box below and joining my email list. If you find the contents interesting then don't forget to share it with your friends.
You can also get professional help like Implementation of Tally in your business or Web Support on tally by asking a Quote.

Enter your email address:

Delivered by FeedBurner

32 responses:

  1. Anonymous1:19 AM

    exiting tally
    position 192000
    chars 128

    ReplyDelete
  2. You need to rewrite tally data by pressing Ctrl + Alt +R at F3 Company selsection menu menu

    ReplyDelete
  3. tally is the best soft ware for accounting.

    IN TALLY 7.2 A SHORTCUT KEY OF OPENING NEU ACCOUNT CTRL + M
    MANOJ KUMAR NGUPTA

    ReplyDelete
  4. Anonymous12:35 PM

    how to open the exported file of tally in to excel sheet?

    ReplyDelete
  5. anybody help me how to recover password from tally 5.4

    ReplyDelete
  6. Export and email options not working..

    thanks in advance

    ReplyDelete
  7. Anonymous5:41 PM

    could anybody guide me in designing crystal report with tally dsn

    ReplyDelete
  8. Anonymous11:33 AM

    Hello there

    If we wanted to export data transactions from Tally 6.3 to MYOB or Accountants Office - what would be the best format to export out of Tally.

    Thanks

    Barry Baker

    ReplyDelete
  9. Anonymous4:49 PM

    I need to access tally report using script or programming language for my application. How can I do that?

    ReplyDelete
  10. Anonymous3:45 PM

    would you tell me how many days it will take to an arabic,urdu version of tally

    ReplyDelete
  11. Anonymous3:46 PM

    Hi
    i m mirza

    want to ask you a question regarding tally arabic version how much time it will take to complete arabic version of tally we are waiting for it.

    ReplyDelete
  12. Anonymous6:10 PM

    ANY ONE PROVIDE ME THE DATA RECOVERY SOFTWARE IN TALLY 7.2

    VINOD JAIN

    ReplyDelete
  13. Hai
    am trying to export tallydata from tally with my own application using XML, but am unable to export invoices from tally.
    Can any one helpme plz

    thanks

    savindra

    ReplyDelete
  14. How to edit .tcp file in tally

    ReplyDelete
  15. how to issue stock in tally for production

    ReplyDelete
  16. i m using tally 5.4 , i want to export my balance sheet to excel , how can i do ?
    plz replz me imdly in my email id
    manasdash21@gmail.com

    ReplyDelete
  17. alpesh shah2:05 PM

    How to Export from tally 9.0 as sdf format

    ReplyDelete
  18. Anonymous1:15 PM

    I Want to Customers & Suppliers Address to be export in Tally 9 , Is it possible, Please Help me out in this.

    Regards
    Ashok

    ReplyDelete
  19. Any body also see the sollution of accounting problems in my website

    www.svtuition.blogspot.com

    ReplyDelete
  20. Anonymous12:15 AM

    can you synchronise tally data on 2 computers having 7.2 without internet? e.g. thru a data CD or USB pen drive.

    ReplyDelete
  21. how to use the import of Data under Import option

    ReplyDelete
  22. can i export in excel format with tally 7.2
    as in tally 9

    ReplyDelete
  23. i want to export costcenters to xml in tally 9. presently i am able to export every sost centers seperately. but, i need to take a consolidated cost center report. kindly help.

    Thnaks

    ReplyDelete
  24. Anonymous11:39 AM

    migration tool for 7.2 to 9 please email me althakar@gmail.com

    ReplyDelete
  25. Anonymous12:26 AM

    In version 6.3 of Tally how do I export Stock Transfer notes with their STN numbers?

    ReplyDelete
  26. Hi, I Need To ask.. that i want all the vouchers from A to B and just vouchers.. i have exported day book.. but import is not working.. Can anyone help me.

    ReplyDelete
  27. Kemparaju5:15 PM

    Hi, i'm Kemparaju,

    Can any body suggest me, is there any option to Export the Reports to Excel with Formula.

    ReplyDelete
  28. hi
    i have doubt, when i export the sales registry to the excel sheet, the dates are not displyed properly. only the first few dates of every month are displayed. For the rest its filled up with " EDUCATIONAL" . CAN any one please tell me the reason

    ReplyDelete
  29. http://mirror1.tallysolutions.com/Downloads/TDL%20Developer/Tally.ERP%209%20-%20Integration%20Capabilities.pdf

    Above Link to a PDF, explains about Import / Export Data from/into Tally.

    Rupesh Shah

    ReplyDelete
  30. Anonymous4:42 AM

    My name is George Silva I was browsing internet and found your blog. The author did a great job. I will subscribe to your RSS feeds. Thank you for your contribution. I am a web designer myself. And here some examples of the websites that I designed for loans canadian payday loans company.

    ReplyDelete
  31. Anonymous5:03 PM

    Can anyone please tell me how to export data from a POS application developed in Delphi to Tally 9 and vice versa. Please let me know if u know of any website where i could find a DLL/SDK/API etc for this.

    Thanks.

    ReplyDelete

 

Copyright @ 2013 ApniTally.

Designed by Templateiy &Site Developed abd Maintained By Cybertec Solutions