How to Tally Import from Excel

How do we import data from excel to tally? Is possible to import data in Tally without any TDL and XML generator utility. Please provide suitable explanation.

Thanks in advance.

Replies (5)
Quick Summary
Data can be imported into Tally from Excel, but usually not directly without TDL/XML or third-party tools. Tally supports import of masters and vouchers via XML using Import option. For Excel-to-Tally conversion, external utilities or converters are commonly used.

There are many ways to import bank statements, vouchers and masters in Tally. Also there are different banks having different statement formats. You have to use third party tool utility to import Bank statements, vouchers and masters in Tally 9,  ERP, Prime, from Excel or PDF.

You can use this Free Utility Click - www.nikash.in  |  www.xltally.in  |  www.xltool.in

How to import data in Tally -

Voucher and Master in the XML format can be imported into Tally using the Import Vouchers and Master option. You can import vouchers from one company to another in Tally. Some of the scenarios are:

  • Importing data from third-party applications
  • Migrating to a later release
  • Data corruption/loss

How to import Masters and Transactions in Tally -

  1. Press Alt+O (Import) / Go to Import Option
  2. Select Masters / Voucher Option
  3. Select the Path of XML file
  4. Enter the File Name
  5. Press OK to Import
Importing masters from tally is EASY.

Electronic Invoicing is an  https://etechups.com/ electronic authentication mechanism under GST. 2. Under the mechanism, all the B2B invoices generated.

Tally Excel Import Tool with Cost Centre dowloaded free

Current TallyPrime releases (from Release 4.0) import masters and vouchers directly from any Excel file through Import > Masters or Transactions with a built-in column-mapping template, so no TDL or XML utility is needed; Tally.ERP 9 and older TallyPrime versions still need the XML route or a third-party tool.

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
ARTICLESHIP 23 October 2026
CA Articleship / Article Assistant

M N Rao & Associates LLP

Vijayawada

CA Inter

View Details
Company
ARTICLESHIP 25 October 2026
Article Intern (CA Articleship)

Arpan Bohra & Co

Hyderabad

CA Inter

View Details
Company
24 October 2026
CA Industrial Trainee

Fytomax Nutrition Private Limited

Aurangabad

CA Inter

View Details
Company
23 October 2026
Sr. Accountant

SANKARAN & KRISHNAN

New Delhi

B.Com

View Details
Company
Featured 07 November 2026
Paid Assisstant

DPV & Associates

Chennai

CA Inter

View Details
Company
10 November 2026
Direct Tax Manager

CAAQ CONSULTANCY PVT LTD

New Delhi

CA Final

View Details
Company
13 November 2026
Accountant

New Mobile India

Muzaffarpur

B.Com

View Details
Company
31 October 2026
Accountants

sankaran and krishnan

New Delhi

B.Com

View Details