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