Go Ad-Free on CAclubindia with Daily Mobile Updates. Subscribe Now!

Tally to excel

reena jain (CA ) (247 Points)

21 June 2010

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

Reply
Follow
Share

14 Replies

Krishan (Service) (633 Points)
Replied 21 June 2010

There is a option in tally in export for exporting it in excel ... do directly from that option...

Upgrade to CAclubindia Pro. Subscribe Now!

Shan Antony (Industrial Trainee) (243 Points)
Replied 21 June 2010

Press alt E or select 'export' from the button panel. Select d destination and format. Press enter. Now go to d destination which u gave. Open d excel file and do d necessary changes.

P K (Excel Developer) (130 Points)
Replied 21 June 2010

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.

Jayachandra Naidu (Accountant) (171 Points)
Replied 21 June 2010

Once you go to BS, selet the detailed on condended and Press Alt'E" automaticall its appears export dilouge box selct yes, all data hasbeen exported. To open this file you have to see like this ,if u don't know destination. Go to Tally icon clik right button then select properties it's shoes property box then you have to select find target now you will get exported file directy u can open. thank u

k suresh babu (employee) (90 Points)
Replied 21 June 2010

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.

Upgrade to CAclubindia Pro. Subscribe Now!

SAMBASIVARAO (Executive - Internal Audit) (122 Points)
Replied 21 June 2010

i can agreewith pavan kumar,

sambasivarao @ basixindia.com

(Guest)

u can export file but u cant maintain format ....and @ pavan for ur kind info. ....export option is also avbl in 7.2 also...

jignesh (MANAGER) (50 Points)
Replied 21 June 2010

IN CERTAIN TALLY 7.2 THERE IS NO OPTION OF EXCEL

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

Nitesh (service) (136 Points)
Replied 21 June 2010

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

jignesh (MANAGER) (50 Points)
Replied 21 June 2010

I M USING 7.2 VERSION

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

Upgrade to CAclubindia Pro. Subscribe Now!

Saumil Shah (Chartered Accountant) (127 Points)
Replied 21 June 2010

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

RUHI (ARTICLED STUDENT) (49 Points)
Replied 21 June 2010

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

Jagadish (FM) (184 Points)
Replied 21 June 2010

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

Sunil Talekar (Accountant) (21 Points)
Replied 24 June 2010

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.