banner_ad

Linking Tally to Excel

Softwares 3479 views 4 replies

Does anybody know about linking Tally data to MS Excel ?
Like linking Tally Balance Sheet with Excel file in such a way that whenever we change the data in Tally it will automatiocally updated in MS Excel file.

Replies (4)

It is very easy in Tally 9 you you have the data in tally 7.2 than you have to convert it tally 9 first and than MS Excle.

Export to Excel With new release now you would get one more options while exporting data. One added format option is Excel format. If you export in this format then file would be saved in xls format. More over if you put Excel formating option to Yes then tally would automatically format the data in presentable format. Tally would automatically bold the headlines and main fields for you and format data in a good way. Take a look at excel snapshot of balance sheet exported from Tally.

The special thing here is that you can do the calculation on any amount figure or any row or column, which was earlier not possible. The only drawback which i could find was that amount figures are not right aligned which is must for numbers for easy calculation, although you can do it by selecting the amount figures and putting them right aligned.

Faster then ever
Few more features added in rel 2.0 are faster way to convert data from tally 7.2 to Tally 9.0 and faster and more efficient rewrite feature. Reports related to VAT and other statutory would not take more time now.

Yes you can automatically update your Excel data whenever you make any entry in Tally!!!!!!! Please check this link /forum/details.asp?mod_id=164686&offset=4

Thanks 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.


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
03 May 2026
Senior Chartered Accountant

Nirmal Jain & Co

New Delhi

CA

View Details
Company
ARTICLESHIP 27 May 2026
CA Article Trainee

Rahul Dang & Associates-Chartered Accountants

Pune

CA Inter

View Details
Company
27 May 2026
Audit Assitant

Virender K Gupta and Co

New Delhi

B.Com

View Details
Company
ARTICLESHIP 17 May 2026
CA Article /Trainee

Malik Sunil & co

New Delhi

CA Foundation

View Details
Company
11 May 2026
Post office

Post office

Anakapalle

Others

View Details
Company
ARTICLESHIP 15 May 2026
ARTICLE ASSISTANT, TRAINEE AND PAID ASSISTANT

YOGESH KAPOOR AND ASSOCIATES

New Delhi

B.Com

View Details
Company
24 May 2026
Accounts & Tax Executive

PARAS KHURANA AND CO

New Delhi

B.Com

View Details
Company
14 May 2026
Financial Analyst - Remote Finance Expert

HiringBridge

Ahmedabad

CA

View Details