excel to tally converter

Converter Excel to XML (Import data in Tally)

Follow the below steps to import Sales/ Purchase with Inventory Data to Tally Prime, Tally.ERP9 or Tally 9.

  • Add a Company in which you want to import data, Company name should be the same as per the company name in Tally
  • Download our Sample Excel Template and fill your data in the respective columns
  • Once your data is ready as per our template, upload and process the same
  • Once data process is completed, you will get Tally XML for download
  • Tally.ERP9 Users: Open Tally Company > Import Data > Vouchers > Give the complete XML file path and press enter to import all your data to Tally
  • TallyPrime Users: Open Tally Company > Click on Import Button > Transactions > Choose the XML file to be imported and press enter, all your sales data will be imported to Tally

By following these steps you can practically import any number masters in Tally without impacting your other data.
Follow the below steps to import Ledger Masters to Tally Prime, Tally.ERP9 or Tally 9.

  • Add a Company in which you want to import data, Company name should be the same as per the company name in Tally
  • Download our Sample Ledger Master Template and fill your data in the respective columns
  • Once your data is ready as per our template, upload and process the same
  • Once data process is completed, you will get Tally XML for download
  • 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
  • TallyPrime Users: Open Tally > Open Tally Company > Click on Import > Masters> Browse XML file and press enter to import all your data to TallyPrime

Upload Excel File (*.xlsx)

Note: I have confirm that only 100 entries imported