There are 2 ways to do it..
You can export as text and import it back
to excel using the text file you created.
You can select HTML
and give the file name as eg-XYZ.xls
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.
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.
Consider exporting day-book.Go to day book press export button or use shot cut key Alt+E. Exporting screen will displayed.
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.
Press enter to accept screen. Day book is exported in to tally program folder. Check program folder for file daybook.csv,
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.
Hope this is helpful. Let us know if the issue is resolved.
*Rating and Comments are invited for this solution