Become a Govt. Certified GST Practitioner in just 60 hrs. Register Now!

Excel to tally

Shubham Gaud (Not Doing.... Searching) (26 Points)

23 December 2016

I want to Import data Via Excel to Tally Can anyone provide Excel utility for Import?

Reply
Follow
Share

7 Replies

Neha Shah (B.Com) (48 Points)
Replied 25 December 2016

In XLtool there is very simple steps to import Excel data in Tally application.

Download the latest software at - www.xltally.in

Follow these steps for import vouchers Excel to Tally -

First enable ODBC port in Tally application.
Open one Tally application & open only one company.
In XLTOOL software fillup the data in appropriate voucher template.
Open MY MENU by F1 Key.
click START button.
Data will be imported in Tally.
If any errors occurred see the details on REPORT template.
Read software in-built HELP template for more details.
If any Error then you can get alert in software REPORT template.
Rectify the errors and process same steps.

Upgrade to CAclubindia Pro. Subscribe Now!

Dhaval Goradia (26 Points)
Replied 29 March 2017

Hi Shubham,

i hope your requirement is served.....if not than i would recommend to visit www.excel2tally.in....its really simple and easy to use from anywhere anytime.

sign up for 30 days free trial and check.

Shweta Softwares (Business) (115 Points)
Replied 19 November 2017

Import data from excel to Tally using udi-Magic Software.

Start Tally ERP and Open a Company.
Start udi-Magic software
Select the option Excel to Tally > Import data into Tally
Click the Browse button and select Standard Excel template provided with udi-Magic converter
Click the Start button

Download link : https://www.rtslink.com/downloads

For more information refer : https://www.udimagic.com

Sooraj C Kunnaru (Student) (31 Points)
Replied 16 October 2018

EXCEL MAGIC (Excel to Tally ERP 9) There is a utility to convert data from Excel to Tally, named Excel Magic. With this utility, about 10000 entries can be entered within half an hour. https://www.youtube.com/channel/UCF9wUXe7gVKCC0Kb-HqVSaQ (Madappalli Associates)

Attached File : 1273523 20181016214152 cover 01 01.jpg downloaded: 123 times

Adom Johnson (4 Points)
Replied 17 October 2018

I am using SAP for accounting. The document from SAP is a guideline with minimum system requirements. That is what is generally prescribed. But I could share what I know from my using SAP B1 on my laptop for many years now. As per my advice, you should use SAP. If you are using hp laptop and having an issue or you want to install SAP then simply contact hp customer care

Upgrade to CAclubindia Pro. Subscribe Now!

Sooraj C Kunnaru (Student) (31 Points)
Replied 18 October 2018

Attached File : 1273523 20181018090422 cover 01 01.jpg downloaded: 112 times

Roodita Gaikwad (Practice) (4526 Points)
Replied 26 April 2025

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.