Follow the below steps to import Item Master Data from Excel to TallyPrime or Tally.ERP9.

  1. Login to your existing account or Signup a Free Account on
  2. Add a Company in which you want to import data, Company name should be the same as per the company name in Tally
  3. Download our Sample Item Master Template and fill your data in the respective columns
  4. Once your data is ready as per our template, upload and process the same
  5. Once data process is completed, you will get Tally XML for download
  6. Tally.ERP9 Users:  Open Tally > Open Tally Company > Import Data > Masters > Give the complete XML file path and press enter to import all your data to Tally.ERP9
  7. TallyPrime Users: Open Tally > Open Tally Company > Click on Import > Masters > Browse XML file and press enter to import all your data to TallyPrime

By following these steps you can practically import any number of masters in Tally without impacting your other data.

In case if your data is not imported as expected then please check the message displayed in the calculator panel or in Tally.IMP file, if you are unable to resolve the error, you may get in touch with our professional support executive on +91 7710010372 / 73 / 74 or drop an email on

Good Luck!

You might be interested in our other Products / Services

Most Preferred Data Import Utility for Online Sellers

Import any Online Portal Order-wise Sales, Returns & Settlement Data to Tally!

Most Preferred Job Portal for Accountants

Fastest Growing Job Portal for Accounting Community!

Payroll & Attendance Simplified for SME & Startups