Wednesday, 14 February 2018

Excel to tally data export Utility | Excel to Tally Series Part #2

Absolutely Free!!!

This is part second of My excel to tally video series.


Today I'm going to provide very famous excel utility that name is "Excel to Tally data Export Utility". This utility created by











I am very thankful to above mentioned developer for this file. Please donate above mentioned bank details.


How to Use It:-

Complete detail i provided in below YouTube video, So it's better if you watch this video.

>Download this file from given below link
>Enter Data in this file
>Press Generate Button, to create XMl File (Tally Understandable File)
>Go To Tally >Gateway Of Tally
>Import Data> Masters/Vouchers
>Enjoy!!

For Complete Info Watch This Video


For Download

Click Here

21 comments:

  1. Good Job........... Very helpful.

    ReplyDelete
  2. Hi. Your tool is very helpful but some times it show error first save excel file and delete existing xml and press button again

    ReplyDelete
  3. Replies
    1. XML File generated through this utility is not read by Tally and shows error "Eh this is not the XML File"

      Do you have any remedy for this

      Delete
    2. copy address by right clicking on xml file , then go to security, above u can see address . copy and paste it , it works then

      Delete
  4. Isme vouchar number ka column nahi work kar raha ????

    ReplyDelete
  5. Dear Sir,
    This is very useful Utility, but some missed in this utility,
    1. Column B Voucher No. not work, this column is hidden
    2. How to create another voucher type, like GST Invoice
    3. When Sales Import data in tally, it show as Voucher mode, I will see this as Invoice mode

    ReplyDelete
  6. how to do for multi groups ledgers

    ReplyDelete
  7. https://drive.google.com/open?id=1U1rHpthlEcxX3S_uL935MA2dhl7YJYpH

    ReplyDelete
  8. pls sir provide me file for import for more than 5 ledgers. thanks.
    my mail is irfankhan1264@gmail.com

    ReplyDelete
  9. PLS PROVIDE THE PASSWORD FOR VBA PROJECT BECAUSE MY TALLY IS CUSTOMIZED SO THIS EXCEL WONT WORK.
    PLS PROVIDE SOME SOLUTION.

    ReplyDelete
  10. AFTER PASTING XML FILE ADDRESS IN TALL IMPORT , IT IS SHOWING COULDNT OPEN FILE , SIR I OPENED THE FILE THRU MICROSOFT EDGE NOT INTERENT EXPLORER. IS INTERENT EXPLORER NECESSARY

    ReplyDelete
    Replies
    1. sir can use copy paste for pasting values from other excel file to this utility

      Delete
  11. Dear Sir

    Ur utility is really great.. 3 years ago only i tried to contact you but i couldn't.. i want to inform you that in MC vouchers ledgers are very limited, now a days we require minimum 8 to 10 ledgers to export data into tally.. pls provide ur no ill speak to you regarding this in detail... Ph: 9986377730 Email Id: laxman77730@gmail.com

    Thank You

    ReplyDelete
  12. after copying address of xml it shows could not open file, plz help

    ReplyDelete
  13. how to import data of address book price list whch i have in excel format which has to be imported in my tally erp

    ReplyDelete
  14. Sir, With Inventory details in purchase and sales transaction possible ?

    ReplyDelete