Latest Updates


Excel Data to Tally

How can I transfer excel sheet data to tally in an easy way. I want to transfer stock item from excel to tally. No need to use other softwares for this purpose. Please giver the answer for this mater. I am waiting for your reply. Thanks in advance.

Reghukumar Konni from India

1. First of all you have to configure date format in control panel. It must be DD/MM/YYYY

just go to start menu, then go to control panel, then go to regional and language option and then go to regional option customized, then go to date, then short date format and then DD/MM/YYYY ok.

2. Now, configure Tally.ERP 9

Open the company

open gateway of tally, then go to F12 configure and then go to advance configure

Tally Acting as : Both

Enable ODBC Server : Yes

Master export setting

Open gateway of Tally, then go to display, then go to list of accounts

Excel file should be the format of tally voucher entry


Cr. Account and Cr. Amount

Dr. Account and Dr. Amount



VCH No. : Write Voucher no.

Ref. No. Ref. no. of sales or purchase

Now, import in Tally. Just check the utility of excel to tally in tallysolution company website.

If you do not know the import, you can learn at here.

Share This:

Vinod Kumar ( Educator )

Vinod Kumar ( Educator ) is founder of this website

No Comment to " Excel Data to Tally "

  • To add an Emoticons Show Icons
  • To add code Use [pre]code here[/pre]
  • To add an Image Use [img]IMAGE-URL-HERE[/img]
  • To add Youtube video just paste a video link like http://www.youtube.com/watch?v=0x_gnfpL3RM