Tally 7.2 data to Excel

38598 views 9 replies

Dear Experts,

          can any one pls tell me about changing procedure of Tally 7.2 data into Excel.........

 

Thanks in adv

 

PRASAD

Replies (9)

Export whith File Extn. name (abc.csv) then it can open in excel

Thank you Mr Ram for ur reply....................

but i cant understanding ur reply i want to change Tally 7.2 Balance sheet  into Excel format can you explain in points wise ( data converting points step by step ).........

 

Thank you

 

PRASAD 

the man know about computer file name and its extenention name can understand ask to your tally operetor. or go to institute. its a long process.

Thank you........

 

PRASAD

first go on blance sheet display then do export from that page then a page come exporting page choose format asccii command then save it by giving name(balance sheet)the page save where ur tally is installed 

second step then open excel sheet  and open the file which one u saved select the folder of tally and whn u fnd the file choose  fily of typeee..... all files*then that file comes and open that file

third then text import wizard comes then do next select delimetre and then do next u will export it

 what kind Data, U can Import Data From Tally to Excel,

1 open tally. (Select company)

2 open excel 

3 go to Data Menu -----> Import External Data -----> Import Data -----> My Data Source -----> Select TallyODBC -----> Open -----> Then Select What u want to Import

Please Reply me

Originally posted by :ysd prasad
 

Hi,

One easy way to Export data from Tally 7.2 is to use Export Command (Alt+E), Click Format and Choose HTML, give a File name with location, and Export.  Go to the Exported File Location in the Windows Explorer, rename the file with XLS Extention (FileName.xls), click the file to open in Excel.  You can also give an XLS extention at the time of Exporting it self.  To make the figures Excel Compatible, use REPLACE Command to remove Commas (,).  For easier working with data, you can use Ctrl+A and remove the Fill Colour, as also uncheck 'Wrap Text' and 'Merge Cell' in Format, Cells, Alignment Menu.  Once this is done, you can work in the same Worksheet or copy the data to any other worksheet.  Don't forget to save it as an Excel Work Sheet.

CA. Prakash Dugar

"

goog thread

Thank You for sharing.
Download XLTOOL Excel To Tally FREE 100% version. 
Import All Vouchers and Masters in Tally PRime, ERP 9, Tally 7.2
Also Export Tally data to Excel.
Source: www.xltool.in.

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
ARTICLESHIP 16 July 2026
Article Assistant

G A R U D & Associates

New Delhi

CA Inter

View Details
Company
ARTICLESHIP 27 June 2026
CA Articled Trainee And Paid Assistant

SKAA & Associates

New Delhi

CA Inter

View Details
Company
ARTICLESHIP 08 July 2026
Article internship

AJAY SINGH AND CO LLP

Thane

CA Final

View Details
Company
21 July 2026
Chartered Accountant

Keshri & Associates

Thiruvananthapuram

CA

View Details
Company
ARTICLESHIP 16 July 2026
Article Assistant

Sahil Agarwal & Company

Mumbai

CA Inter

View Details
Company
ARTICLESHIP 11 July 2026
Article

SNCO

Mumbai

CA Inter

View Details
Company
14 July 2026
Senior Executive/ Manager

H S SHARMA AND CO

Pune

CA Final

View Details
Company
06 July 2026
Senior Accountant

Arvindkumar Maniar & Co.

Rajkot

CA

View Details