Friday, 23 February 2018

Excel to Tally Part-4 | Export Item or inventory with GST Details & Balance into Tally

This is Part 4 of Excel to Tally series.




You will learn after this
> Export items from excel sheet to Tally
> Export items details from another software generated excel sheet to Tally


This is article will be very-very useful for those users who are currently using another software but now want to use tally for preparing their books.




Actually i am providing you a very special excel utility through this article that is completely developed by me. So download it below link @ end of this post.

Complete Procedure:-How to export items to tally

>download excel utility below given link end of this post.
>open excel file using password "aasansolution"     Note:-all characters are small and no space
>Enable macro or enable content by click on "enable content" button.
>fill data on export items sheet or copy data from another resources as per shown image


>enable developer tab



   right mouse click on File menu > select by clicking on customize the ribbon > go to popular tab > check mark on Show developer tab in the Ribbon


> click on developer menu >click on export button > then save XML file


> open XML generated file in internet explorer>copy path
>open Tally>Import Data >Masters>paste path of xml file>press enter
>done
>check created stock items

For Download Excel Utility




Click Here

6 comments:


  1. The great service in this blog and the nice technology is visible in this blog. I am really very happy for the nice approach is visible in this blog and thank you very much for using the nice technology in this blog
    Ms excel training in chennai

    ReplyDelete
  2. by clicking on click here, no link found for excel utility link below.


    pls do needful.

    thanks
    jsb

    ReplyDelete
  3. send me excel tally conveter excel sheet

    ReplyDelete
  4. hi sir,,
    Aaj Tak Jo bhi TDL apne servce ki unke ke bahot bahot shukriya,
    but sir bahi jo excel to tally tdl hai usmenin kutch prblm ho rahi mujhe data import karte samay but main solve kar nahin paa raha hoon kahan se help mil sakti hai

    ReplyDelete