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
>check created stock items

For Download Excel Utility

Click Here


  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

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

    pls do needful.


  3. send me excel tally conveter excel sheet

  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

  5. Thanks for your excel files Where can I put alias

  6. sir i am unable to import data in to tally as it is asking for Voucher number pls help