Tally to excel

Dear Reena,

The above suggestion will work only if you are using Tally 9.0 or above. If you are using any lower version the feature is not present in Tally.

go to export menu click it will ask export documents .  you type which account you want  profit and loss or balance sheet . please give the file name . please give options you want.

i can agreewith pavan kumar,

sambasivarao @ basixindia.com

IN CERTAIN TALLY 7.2 THERE IS NO OPTION OF EXCEL

ASCII HTML  XML & SDF FORMAT OPTION R AVAILABLE SO WHT ABT EXCEL

Dear Reena,

First mention which version Tally you are using. If you are using Tally with version lower than 9, then you need to first use "Merge and Centre" Icon in Excel tool bar.

By using condition formulae eg "if" you can juggle the data and can get data in excel format in presentable manner.

rgds,

nitesh salian

I M USING 7.2 VERSION

HW I USE MERGE & CENTER  ICON & WHICH CONDITION FORMULE USE ?

Mr. Jignesh

Export the Balance Sheet Or P & L in HTML format.

Now open Microsoft Excel ---> Go to File Menu ---> Open and select the path where you have stored the said .html file.

You may require some formatting in the said file.

saumil shah

dear reena,

when you are in balance sheet or profit and loss a/c,

just prss alt+e and then in th e options it will ask u whether you want formatting or not just do yes n u will get formated balance sheet and profit and loss a/c

Hi all

you can export  file to excel in all version, while using 9.0 one can directly export to excel whereas in old version following step has to following. (eg 7.2 )

1.  click  export option

2. select format ASCII

3. give ur own file name with extension .xls and save.

4. open blank excel file and locate you file in tally folder (usally in c:\tally7.2)

5. select delimited  option from pop up screen > click next

6.click tab and comma box appear on the top and below you will find the preview of that report.

click finish and  format as per your requirement.

Jagadish

Originally posted by : reena jain
	hi friends kindly let me know how can we convert a tally balance sheet or p&l to excel without losing its format. when i tried i was not in actual format. thanks reena jain

Press Alt'E" automaticall its appears export dilouge box then give file and ext. i.e html format only and then select yes, all data has been exported. find file tally folder destination. Go to Tally icon clik right button then select properties it's shows property box then you have to select find target now you will get exported file directy u can open.