A simple yet powerful tool to upload data from Excel to Tally ERP.


See how it works - Video

20+ Standard templates Works with Tally ERP 9 Release 5.4 UNDO anytime

First visit ? Start here

If you are new to udi-Magic, this is the right place to start.

1. Install udi-Magic

Installing udi-Magic is quite easy and simple. Let's get started.

  • #1. Download the latest version of udi-Magic
  • #2. Run the setup to install

Upon successfull installation, you shall get udi-Magic shortcut on the desktop.

2. Create A Company

To import data into Tally, you will need a Company. Let's create one.

  • #1. Open Tally ERP software
  • #2. Select option : Create Company
  • #3. Enter the CompanyName as 'UDIMagic DEMO'
  • #4. Enter the other Company details as required
  • #5. Press Ctrl+A to save Company
  • #6. Next, minimize the Tally application
For DEMO, it is advised that you import data into a NEW Company in Tally.

3. Import data Into Tally

Now, that we have installed udi-Magic and created a Company in Tally, let's begin.

  • #1. On your Computer, open udi-Magic application
  • #2. Select option : Excel to Tally
  • #3. Select option : Import data into Tally
  • #4. Select Excel File : << Std. template >>
  • (i.e. Any template provided with udi-Magic Software)
  • #5. Click the Start button to import data into Tally
To view the data imported in Tally, use option Gateway of Tally >> Display >> Daybook

1. Ensure that you start Tally.ERP and open a Company before starting udi-Magic.
2. To upload / import data into Tally, use the Standard Excel templates provided in c:\udi-MagicDemo folder.
3. For information on fields/columns, refer the notes given in each template.

What next ?

Having more questions. Have a look at the FAQs and How To's.