Import data into Tally Prime 7.0, quickly and easily

udiMagic is an application that helps you import data into Tally Prime, quickly and easily. It supports a wide range of pre-designed Excel templates with Tally GST features.

  • Works with Tally Prime
  • Supports a wide range of templates
  • You can carry udiMagic in a USB Flash drive [travel license] and use it on any Computer with any Tally version
  • You can also map your excel sheet to one of the Standard excel templates or simply create a new template using the free online Template Builder tool.

Excel to Tally import software — udiMagic

How does udiMagic work?

If you are new to udiMagic converter, this is the right place to start. Follow these step-by-step instructions to import excel data in Tally.

Install udiMagic

Installing udiMagic is quite easy and simple. Let's get started.

1. Download the latest version of udiMagic software
2. Run the setup to install

Upon successful installation, you shall get udiMagic shortcut on the desktop.

Create a Company in Tally

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

1. Open Tally Software
2. Select option : Create Company
3. Enter the Company Name as 'UDIMagic DEMO'
4. Enter the other Company details as required
5. Press Ctrl+A to save Company
6. Next, minimize Tally Software
Import data from Excel to Tally

Let's now import the Excel data into Tally Software.

1. Start udiMagic software
2. Select option : Excel to Tally
3. Select option : Import data into Tally
4.Select Excel File : Any XLS template
(Select any template provided with udiMagic)
5. Click the Start button

To view the data imported in Tally, use the option Gateway of Tally >> Display >> Daybook

1. Before starting udiMagic, ensure that Tally Software is running and a Company is open.
2. To upload data into Tally Software, use the 'Standard Excel templates' provided in c:\udiMagicDemo folder.
3. Refer the notes given in each template.

Why udiMagic?

For over a decade, individuals and businesses have been using udiMagic to import data into Tally. It is simple yet quite powerful. It supports several features viz Point of Sales (POS); Cess based on Quantity; State-tax and UT tax; Multiple Cost Centres; Cost Categories; Multiple Bill-by-Bill References (BYB); Creating New Templates using Mapping; BOM (Bill of Materials) etc. Try using it and you will love it.

Import Excel data into Tally Prime using udiMagic – GST-ready with wide range of Excel templates
udiMagic is a now GST ready. Import all vouchers, masters data in Tally Prime using a wide range of Excel templates.
Auto-creation of ledgers and stock item masters before importing vouchers into Tally with udiMagic
Ledgers, StockItem masters are automatically created before importing the vouchers in Tally.
udiMagic Travel License activated on a USB Flash drive for use on any computer with any Tally version
Activate udiMagic on a USB Flash drive and use it on any Computer. See FAQ points 3 and 20.
udiMagic Excel to Tally software available on rental basis
Available on Rental basis
Import 5000 records from Excel to Tally in 5 minutes using udiMagic software
Import 5000 records from Excel to Tally in 5 minutes using udiMagic software.
No need to surrender udiMagic license – hassle-free license transfer between computers
No need to surrender udiMagic license. No more hassles.
Plug udiMagic USB flash drive into any computer and start importing Excel data into Tally instantly
Simply plug-in the USB flash drive in another computer and start using udiMagic software.
Import financial data without inventory into Tally using udiMagic Excel to Tally software
Imports only Financial data (without inventory) into Tally.
udiMagic license automatically delivered by email within seconds of purchase
udiMagic license is automatically sent by email within few seconds.

Unique Features

Features that make udiMagic stand apart for Excel to Tally imports.

Under the hood
Debug Mode

See what's happening behind the scenes while Excel data is imported into Tally.

Travel License
USB Flash Drive

Carry udiMagic in a USB Flash drive and use it on any Computer or with any Tally version.

Simple yet powerful
UNDO Any Import

Undo any Excel to Tally import — even weeks or months later.

Multi-lingual
Unicode Support

Import data in English, Arabic, or any Unicode language into Tally.

Improved Performance
In-Memory Computing

~97% faster Excel to Tally imports vs. udiMagic v3.0 — 5,000 records in under 5 minutes.

Robust
Wide Template Library

Excel templates for all Tally voucher types, including Sales/Receipts with multi-references for E-commerce.

Extensible
Custom Excel Templates

Map your own Excel sheet to a udiMagic template using the free online Template Builder tool.

Global Help List
Live Ledger Lookup in Excel

Press ~ in Excel or Word to pull Ledger or StockItem lists directly from Tally while building your import sheet.

Automation
One-Click & Batch Processing

Enable Auto-run for one-click imports, or use Batch Processing to import from hundreds of Excel sheets into Tally in a single operation.

What Our Customers Say on Google

4.8 · 93 reviews

Excellent software for exporting Tally data to Excel. User-friendly, accurate, and time-saving. Great support from the developer.

Siddhant Engineering
June 15, 2026

Amazing tool to do bulk upload from excel to tally. Well priced and we are using it now for over 5-6 years. In fact its way better than tally's own …

KITCHEN MART
Feb. 4, 2024

We are very much happy after using UDI Magic Excel to Tally Software for creating bulk sales and purchase vouchers. Their software really helped us in error free uploading of …

Azonic Infotech Private Limited
Feb. 27, 2019

Very good product, really helpful to manage large data entry at one click. Also it is compatible with GST norms of accounting using tally. It saves lots of time in …

CA. PRATIK Doshi
May 10, 2019

The response time and the support is excellent and unmatched! Highly recommended.

Imtiaz M
Feb. 13, 2025

software is very good and useful

Anant Inamdar
Aug. 14, 2024

Superb software and support staff is very helpful

DINESH JAIN
Oct. 3, 2025

Thanks to udimagic, also support tally on AWS

Arya tvs
June 25, 2026

Service and support is excellent

manoj choudhary
May 20, 2026

Very good software, with this reduced data entry time to zero level and helping support team, they clear your doubt very patiently. Very Nice Team

NEEL ARORA
March 15, 2019

Very friendly user. in any time any doubts they are easy so solve the problem. templates are easy format for understood any one.

prasanna kumari
Dec. 12, 2023