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
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