LIVE GST Certification Course by CA Arun Chhajer begins 21st April. Register Now!!

Excel to tally data export utility

vijay alwal (student) (36 Points)

06 August 2011

hi raj can you update excel to tally data export utility

Reply
Follow
Share

18 Replies

CA R K SINGH (CA CS FINAL CMA INTER) (372 Points)
Replied 06 August 2011

Hi Vijay ,

I have already updated the excel to tally data export utility. I m further updating the utility. Plz download from the link below

/share_files/excel-to-tally-export-latest-version-786-2-40819.asp

1 Like

uthmaputiran (software engineer) (31 Points)
Replied 09 August 2011

Originally posted by : R K SINGH
	Hi Vijay , I have already updated the excel to tally data export utility. I m further updating the utility. Plz download from the link below /share_files/excel-to-tally-export-latest-version-786-2-40819.asp

Thanks for this useful sharing,....

kanagaraj (CHARTERED ACCOUNTANT) (793 Points)
Replied 25 October 2015

Dear Niki,

Is it a free software or only a trail version

kanagaraj (CHARTERED ACCOUNTANT) (793 Points)
Replied 25 October 2015

Dear R K

Thank u very much for sharing such a useful programe at free of cost.Even big shots running behind the money your work is highly commendable. Thank u very much once again

Neha Shah (B.Com) (48 Points)
Replied 28 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 from 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

Thank You..!

Sanjay Shinde (7 Points)
Replied 08 July 2017

i am usening this

but i am unable to import stock item from tally.

stock item not shown in selection box. while generating X M L file getting Error"LEDGER NAME AT CELL F3 IS INCORRECT OR YOU HAVEN'T CREATED & IMPORTED IT FROM TALLY. SEE Q.1 IN HELP SHEET TO KNOW HOW TO IMPORT LEDGER FROM "

please help me

1 Like

Geeta Karmani (Practising Whole time Cost Accountant) (39 Points)
Replied 01 October 2017

Dear Sir,

Thanks for such a utility. Please update the year drop down list in this from 1998 or before as we need to maintain accounts of last 20 years and your utility can help us a lot.

thanks in advance

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 (for attendance) provided with udi-Magic converter
Click the Start button

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

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

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

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

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

ajay (accountant) (22 Points)
Replied 09 December 2017

Hi Raj ,

I used utility software for a year.(excel_tally).Its too good.but rightnow I am facing problem due to cgst & sgst.(Two no of taxes).The utility is limited to FIVE Amount columns while Now due to gst I require SIX Amount columns.Is the utility modified for the same or in progress ? Can I add ONE Amount column in utility ?HOW ? It will be very helpful to me.

Pl. answer somebody.

Sabka malik ek.ham sab Uske bande.Thanx..

Ajay.