How to import data from excel to Tally?

  1. Start Tally ERP and Open a Company.
  2. Start udiMagic software
  3. Select the option Excel to Tally
  4. Select the option Import data into Tally
  5. Click the Browse button and select any Standard Excel template provided with udiMagic converter
  6. Click the Start button

udiMagic processes the excel data and imports it into Tally. To view the data imported in Tally ERP, use the option Gateway of Tally > Display > Daybook.

Software Specifications

  • Name : udiMagic
  • Category : Business Application
  • Sub-Category : Data Converter for Tally ERP 9
  • Version : Version 9.0 Release 1.5
  • Release Date :
  • Release Notes : Template modifications
  • Download URL : https://www.rtslink.com/img/udiMagicDemo.zip
  • File Size : 6 MB
  • File Name : udiMagicSetup.exe
  • Operating System : Windows XP  •  Windows 7  •  Windows 8  •  Windows 10
  • Publisher :
  • Copyright year : 2008
  • Description : Excel to Tally Import utility
  • Screen Snapshot : udiMagic Excel to Tally
  • Average User Rating 4.8
  • Total votes 5

Licensing and Pricing

  • Licensing : Free to try
  • Trial period : 30 days
  • Trial limitations : 5 records
  • Product Id : Standard (12 months subscription)
  • Currency : INR
  • Price (Excl. GST): 6000

To use the software after the trial period, you must buy a licensed copy by paying the requisite charges.

Refer the buy page for price in USD and for prices of other udiMagic variants.

Software requirements

a. Windows XP or higher;
b. Excel 2003 or higher;
c. Tally 6.3 or higher

User Ratings

UMA MOTORS PVT LTD
2018-02-16 [Ratings : 5 out of 5]

BEETLE MOTORS LTD
2018-01-25 [Ratings : 4 out of 5]

SINGHAL AUTO PARTS
2018-01-10 [Ratings : 5 out of 5]

AANYA TECHNOLOGIES
2017-12-31 [Ratings : 5 out of 5]

SHREEJI ACCOUNTS
2017-12-28 [Ratings : 5 out of 5]


Demo Videos


Faith is the bird that feels the light and sings when the dawn is still dark.
Rabindranath Tagore

What makes udiMagic unique ? Learn more.