Tally 7.2 data to Excel

38591 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
Featured 18 July 2026
CA Articleship

apricus india

Mumbai

CA Inter

View Details
Company
22 June 2026
Accountant

Global Image Technologies Private Limited

New Delhi

MBA

View Details
Company
ARTICLESHIP 27 June 2026
Article

SNCO

Mumbai

CA Inter

View Details
Company
ARTICLESHIP 15 July 2026
CA Articles

Kinjal H Shah & Co.

Mumbai

CA Foundation

View Details
Company
11 July 2026
CA semi qualified

Vakilsearch.com

Chennai

CA Inter

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

SKAA & Associates

New Delhi

CA Inter

View Details
Company
25 June 2026
Accounts & Taxation Executive

Dindukurthy & Associates

Hyderabad

MBA

View Details
Company
Featured 16 July 2026
Semi Qualified Company Secretary

Vakilsearch.com

Chennai

CS

View Details