Ad Free CAclubindia and Daily Updates on your Mobile. Subscribe Now!

Tally 7.2 data to Excel

ysd prasad (Accounts officer) (250 Points)

26 October 2009

Dear Experts,

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

Thanks in adv

PRASAD

Reply
Follow
Share

8 Replies

Ram Avtar Singh (Nagari Sultanpur U.P.Delhi) (14497 Points)
Replied 26 October 2009

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

Upgrade to CAclubindia Pro. Subscribe Now!

ysd prasad (Accounts officer) (250 Points)
Replied 27 October 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) (14497 Points)
Replied 28 October 2009

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)
Replied 02 November 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

Upgrade to CAclubindia Pro. Subscribe Now!

samip karpe (accounts assistance) (152 Points)
Replied 24 November 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 (CA) (666 Points)
Replied 11 December 2009

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

1 Like