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
ReplyDeleteThe 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
very nice
ReplyDeleteby clicking on click here, no link found for excel utility link below.
ReplyDeletepls do needful.
thanks
jsb
send me excel tally conveter excel sheet
ReplyDeletegood
ReplyDeletehi sir,,
ReplyDeleteAaj 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
great
ReplyDeleteThanks for your excel files Where can I put alias
ReplyDeletesir i am unable to import data in to tally as it is asking for Voucher number pls help
ReplyDeleteUTILITY KAHA SE DOWN LOAD KARNA HE
ReplyDelete