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

32 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
    Replies
    1. Right.. I agree.. I'm also facing same problem.
      Have you received utility containing more than 6 ledgers??
      If yes please share it with me on kittur.amit@gmail.com

      Delete
  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
  15. WHILE ENTRY EVERY ROW SHOWING MISS MATCH BUT ACTUALLY THEIR IS NO MISSMATCH "DEBIT AND CREDIT AMOUNT NOT EQUAL IN ENTRY MADE ROW 3(CR.AMT,-DR,AMT=-1.45519152283) DR.AMT IS 86977.80 CR 73710 + CR 6633.90 CR 6633.90
    EVERY TIME GETTING SAME. I COULD NOT ABLE TO USE TELL ME THE SOULTION

    ReplyDelete
  16. download nahi ho raha hai sir

    ReplyDelete
  17. download nahi ho raha hai sir

    ReplyDelete
  18. SIR XML GENERATE AS PER OUR XLS FILE BUT NOT UPLOADED IN JAN 2020 IF ANY NEW EXCELL FILE IS AVALABLE KINDLY SEND on my mail or provide path girish0503@rediffmail.com

    ReplyDelete
  19. Please send me utility for more thn 5 ledger on diyasoni951@gmail.com

    ReplyDelete
  20. Password Not working, If anyone knows pls share

    ReplyDelete
  21. { Inconsistency in output quality: If the provider {you have chosen|you've chosen|you've selected|you have selected} is inexperienced and lacks consistency, {then it|it|this|that} {might lead to|could trigger|might trigger|may cause} problems {such as|for example|including|like} delayed submission of completed projects, processed files without accuracy and quality, inappropriate assignment of responsibilities, {lack of communication|no communication|poor communication} {and so|and thus|therefore|so} on| While the job profile {might seem|may appear|may seem|might appear} simple {it does|it will|it can|it lets you do} {in fact|actually|in reality|the truth is} {require a|need a|demand a|have to have a} certain {degree of|amount of|level of|a higher level} exactness {and an|as well as an|plus an|with an} eye for detail| My writing {is focused|is concentrated|is targeted|concentrates} {more on|more about|read more about|on} {the industry|the|a|that is a} {and quality of|and excellence of|superiority} work, not the worker| By continues monitoring the hurdles and solving it, {one can|it's possible to|you can|one can possibly} easily {increase the|boost the|raise the|improve the} productivity of business| Decline {in the|within the|inside the|inside} quality of service and delay {in the|within the|inside the|inside} execution and delivery of processes are some {of the|from the|with the|in the} risks involved, {besides the|aside from the|in addition to the|apart from the} risk {to the|towards the|for the|on the} security {of the|from the|with the|in the} data and privacy and cost-related risks| The {service provider|company|supplier|vendor} {should also|also needs to|must also|also need to} volunteer {a variety of|a number of|many different|various} profits concerning formulas {of data|of information|of knowledge|of internet data} transmission, turnaround etc}. { A lot of companies are fine with admitting this, but {others are|other medication is|other people are} {not so|not too|not|less than} sure, primarily {because this|as this|since this|simply because this} may put people {off the|from the|off of the|over} service| Such measures would {keep your|keep the|maintain your|maintain} sensitive documents from falling {into the|in to the|to the|in the} hands of unauthorized personnel| When you outsource {to an|for an|to a|with an} experienced BPO company, {they would|they'd|they might|they will} manage these risks professionally {as well as|in addition to|along with|and also} plan and implement appropriate {strategies to|ways of|ways to|methods to} avoid them in future| Outsourcing data entry is most helpful term {for all|for those|for many|for all those} these organizations| With the help of such information, {you can|you are able to|it is possible to|you'll be able to} {improve on|enhance|make improvements to} customer targeting| If you think {you are|you're|you might be|you happen to be} proficient enough in installing the payment processor {on your|in your|on your own|on the} website {on your|in your|on your own|on the} own, {you should not|you shouldn't|you ought not|it's not necassary to} hesitate doing it}. data entry per hour

    ReplyDelete