Tally 7.2 data to Excel

Tally 37253 views 9 replies

ysd prasad

Accounts officer

250 Points Joined April 2009

Dear Experts,

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

Thanks in adv

PRASAD

Replies (9)

Ram Avtar Singh

Nagari Sultanpur U.P.Delhi

15155 Points Joined March 2007

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

ysd prasad

Accounts officer

250 Points Joined April 2009

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

Ram Avtar Singh

Nagari Sultanpur U.P.Delhi

15155 Points Joined March 2007

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.

ysd prasad

Accounts officer

250 Points Joined April 2009

Thank you........

PRASAD

Guest

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

samip karpe

accounts assistance

152 Points Joined June 2009

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

CA. Prakash Dugar

666 Points Joined July 2008

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

Guest

goog thread

Roodita Gaikwad

Practice

4668 Points Joined November 2024

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.