Map excel and import in Tally ERP 9

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 9 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.