Tally 7.2 data to Excel

38370 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
10 June 2026
Senior Account Executive

JDS Advisory LLP

Ahmedabad

CA Inter

View Details
Company
Featured 24 June 2026
HEAD - AUDIT AND TAXATION

A R JADHAV AND ASSOCIATES

Mumbai

CA Inter

View Details
Company
ARTICLESHIP 20 June 2026
Articleship

RB KESHRI & CO

Mumbai

B.Com

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

SKAA & Associates

New Delhi

CA Inter

View Details
Company
20 June 2026
Assistant Accounts Manager

Fintax Professionals

Gurgaon

CA Inter

View Details
Company
24 June 2026
Chartered Accountant

CA Darshita Shah & Co

Nadiad

CA

View Details
Company
09 June 2026
Accounts Associate

S Madan and CO

New Delhi

Graduate (Any)

View Details
Company
24 June 2026
Chartered Accountant - GST & Direct Tax

APL

Mumbai

CA

View Details