How to map your excel file and import it into Tally ERP 9?


Here's a video on how to map excel file and import it in Tally ERP 9

For reference, the steps are given underneath :

Steps to Map your Excel file

  1. Start udi-Magic converter
  2. Select the option Excel to Tally > Create a Custom template
  3. Select the files :
    • udi-Magic Standard Excel template
    • Your Excel file
  4. Map the columns
  5. Save the Mapping file


Steps to Import data into Tally

  1. Start Tally ERP and Open a Company.
  2. Start udi-Magic software.
  3. Select the option Excel to Tally > Import data into Tally.
  4. Select the files
    • Your Excel file
    • Xml file (Mapping file generated in the mapping process)
  5. Click the Start button.