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.
Be GST Ready with ApniTally and Tally.ERP 9

Join over 5000 Subscribers! Please sign up to receive Updates.

Enter your email address:

Delivered by FeedBurner

34 responses:

Anonymous said...

exiting tally
position 192000
chars 128

TallyHelper said...

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

manoj said...

tally is the best soft ware for accounting.

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

Anonymous said...

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

tiky said...

anybody help me how to recover password from tally 5.4

Murugan said...

Export and email options not working..

thanks in advance

Anonymous said...

could anybody guide me in designing crystal report with tally dsn

Anonymous said...

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

Anonymous said...

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

Anonymous said...

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

Anonymous said...

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.

Anonymous said...

ANY ONE PROVIDE ME THE DATA RECOVERY SOFTWARE IN TALLY 7.2

VINOD JAIN

kanna said...

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

kanna said...

How to edit .tcp file in tally

dipin c h said...

how to issue stock in tally for production

Manas said...

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

alpesh shah said...

How to Export from tally 9.0 as sdf format

Anonymous said...

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

Regards
Ashok

vinod kumar said...

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

www.svtuition.blogspot.com

Anonymous said...

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

Roy said...

how to use the import of Data under Import option

ashu said...

can i export in excel format with tally 7.2
as in tally 9

Rumesh said...

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

Anonymous said...

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

Anonymous said...

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

Vinod Kumar said...

Educative tutorial

Yesha said...

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.

Kemparaju said...

Hi, i'm Kemparaju,

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

jo said...

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

Rupesh Shah said...

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

Anonymous said...

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.

Anonymous said...

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.

Unknown said...

i want to trans some one group entries from one company to another company is it possible in tally ?

Unknown said...

i want to trans some one group entries from one company to another company is it possible in tally ?

 

Copyright @ 2013 Apni Tally.

Designed by Templateiy &Site Developed abd Maintained By Cybertec Solutions