How to Import Data from Excel to Tally

Manually entering hundreds of invoices or ledger entries into Tally is a recipe for headaches and data entry mistakes. If your data already lives in an Excel sheet, there's a much faster way to get it into your accounting software. This tutorial will walk you through exactly how to prepare your Excel file and import it into Tally, saving you hours of tedious work.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Bother Importing Data from Excel to Tally?

Moving data from Excel to Tally isn't just a fancy trick, it's a practical solution to common business challenges. For most, it boils down to three key benefits: speed, accuracy, and efficiency.

• Bulk Data Entry: Imagine you have a month's worth of sales data from an e-commerce platform, a list of expenses tracked by a remote team, or journal entries from a complex project. Entering these one by one is not only slow but drains your focus from more important work. An import process handles thousands of entries in minutes.
• Reduced Manual Errors: Every manual keystroke is an opportunity for a typo - a wrong number, a misspelled ledger name, or an incorrect date. These small mistakes can lead to major reconciliation problems later. Importing data directly from a properly formatted source sheet drastically reduces the risk of human error.
• System Migration: When switching from another accounting software or an older bookkeeping system, you'll often get your historical data as an Excel export. Importing this data is the only feasible way to bring your Tally books up to date without starting from scratch.

In short, if you're dealing with anything more than a handful of transactions, learning to import from Excel is a skill that pays back your time investment tenfold.

Preparing Your Excel File: The Most Important Step

Tally is very particular about the format of the data it accepts. You can't just take any random spreadsheet and expect it to work. The success of your import hinges almost entirely on how well you prepare your Excel file. Spend 90% of your effort here to avoid 99% of potential errors.

Think of it like giving a librarian a list of books to find. If your list is a mess with jumbled titles and no author names, the librarian won't be able to help. But if you provide a clean, organized list, you'll get your books in no time. Your Excel file is that list, and Tally is the librarian.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 1: Create a Tally-Compatible Template

The column headers in your Excel sheet must correspond to the data fields inside Tally. The easiest way to get started is by building a template for the specific type of voucher you want to import, like Sales, Purchase, Receipt, or Payment vouchers.

Here’s an example template for importing Sales Invoices. Create a new Excel sheet with these exact column headers:

• Voucher Date
• Voucher Type Name
• Party Ledger Name
• Sales Ledger Name
• Item Name
• Billed Qty
• Rate
• Amount

Each row in this spreadsheet will represent a single item within a sales invoice. For invoices with multiple items, you'll have multiple rows with the same Voucher Date and Party Ledger Name.

For financial entries like Journal Vouchers, your template would look different, focusing on debits and credits:

• Date
• Voucher Type
• Ledger Name (Debit)
• Amount (Debit)
• Ledger Name (Credit)
• Amount (Credit)
• Narration

Step 2: Clean and Format Your Data Meticulously

Once your template is set up, it's time to populate it with your data and clean it up. Pay close attention to these rules:

• No Merged Cells: Tally can't read merged cells. Go through your sheet and ensure no cells are merged.
• Consistent Date Format: Use a consistent, simple date format like DD-MM-YYYY or DD/MM/YYYY. Select the entire date column in Excel, right-click, choose "Format Cells," and set the appropriate date format to apply it uniformly.
• Exact Ledger Names: This is critical. The names in the Party Ledger Name and Sales Ledger Name columns must exactly match the ledger names already present in your Tally company data. "Adani Enterprises" is not the same as "Adani Ent.". They are also case-sensitive. If a ledger doesn't exist in Tally, you must create it before you can import transactions linked to it.
• Clean Numbers: For columns like Rate, Amount, or Billed Qty, make sure they are formatted as numbers. Remove any currency symbols (like $, ₹, or £) and commas.
• Save a Backup: Before proceeding, always save a copy of your original, cleaned Excel file. This is your safety net if anything goes wrong during the import.

Method 1: Using a TDL Add-on to Import Excel Data (The Easy Way)

While Tally has a native import function that works with XML files, the most common and user-friendly method for direct Excel import involves using a TDL (Tally Definition Language) file. TDLs are small scripts or add-ons that enhance Tally's functionality, and many powerful import tools are built as TDLs.

This method is recommended for most users as it simplifies the process and bypasses the need to convert your file to another format.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 1: Obtain an "Excel to Tally" Import TDL

Many third-party developers offer Excel import TDLs. You can find them with a quick online search for phrases like "Excel to Tally import TDL" or "Tally data import utility." Some are free, while more advanced ones are paid. Find one that explicitly states it supports the type of vouchers you need to import (e.g., sales, journal entries).

Step 2: Load the TDL File in TallyPrime

Once you have your .tcp or .tdl file, you need to load it into Tally. The process is straightforward:

1. Save the TDL file somewhere easily accessible on your computer.
2. Right-click the TDL file and select "Properties." In the security tab, copy the full file path from the "Object name" field.
3. Open TallyPrime and open the company you want to import data into.
4. From any screen, press F1 (Help) &gt, TDLs & Add-ons.
5. The TDL Management screen will open. Press F4 (Manage Local TDLs).
6. In the "List of TDLs to preload," set the "Load selected TDLs on startup" option to "Yes".
7. In the next line, paste the TDL file path you copied earlier and press Enter.
8. Press Enter again to accept the configuration. The TDL is now loaded.

You may need to restart Tally for the add-on to appear. Check the TDLs & Add-ons screen to confirm it shows as "Loaded."

Step 3: Use the New Import Feature

The TDL file will add a new menu option in Tally, typically at the Gateway of Tally. It might be named "Import from Excel," "Excel Import," or something similar.

1. Navigate to this new menu option.
2. The add-on will guide you through the process, which usually involves:
3. Review the settings and start the import. The utility will read your Excel file and create the vouchers in Tally.

Step 4: Verify the Imported Data

Don't assume everything worked perfectly. Go to the Day Book in Tally (Gateway of Tally &gt, Display More Reports &gt, Day Book) and change the period to cover the dates of your imported vouchers. Open a few transactions to ensure all the details - party name, items, amounts, and dates - are correct.

Method 2: Using Tally's Default XML Import (For Advanced Users)

If you prefer not to use third-party add-ons, you can use Tally's built-in import feature. The catch? It only works with properly formatted XML files. This means you must convert your Excel file into a Tally-compliant XML format first, which adds a technical step to the process.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 1: Convert Your Excel File to XML

This is the biggest hurdle. You have a few options, each with its own pros and cons:

• Use a Conversion Utility: Software exists specifically for converting Excel sheets into Tally XML format. This is often the most reliable way to create a valid XML file.
• Online Converters: Several websites offer free Excel to Tally XML conversion. Use these with caution, especially if your data is sensitive, as you are uploading your company's financial information to a third-party server.
• VBA Macro: For those with strong Excel and coding skills, you can write a VBA script within Excel to generate the XML output directly. This is the most customizable but also the most complex option.

The XML file needs to follow Tally's schema, with tags like <VOUCHER>, <DATE>, and <LEDGERNAME> that wrap your data. A good conversion tool handles this formatting for you.

Step 2: Import the XML File in Tally

Once you have the final .xml file:

1. Place the XML file in your Tally default folder (you can find this path under F1: Help &gt, About &gt, Data File Location). Placing it here makes it easier for Tally to find.
2. In Tally, go to the Gateway of Tally and press Alt + O (Import).
3. Select what you are importing: Masters (like ledgers or stock items) or Transactions (vouchers).
4. In the File to Import (XML) field, type the name of your XML file (e.g., sales_data.xml).
5. Specify the path where the file is located if it's not in the default folder.
6. Press Enter to begin the import.

Tally will process the file. Any errors encountered during the import will be logged in a file called tally.imp, which you can find in the Tally folder. Open this text file to troubleshoot issues like missing ledgers or incorrect data formats.

Troubleshooting Common Import Errors

Even with careful preparation, you might run into bumps. Here are solutions to the most common errors:

• Error: "Ledger 'Example Customer' does not exist." Solution: The ledger name in your Excel file is either misspelled or doesn't exist in Tally. Open your Tally company and verify the exact name. Remember, it's case-sensitive. Create any missing ledgers before importing.
• Error: "Date format is incorrect." Solution: Your date column likely has inconsistent formatting or contains text. In Excel, format the entire column as DD-MM-YYYY and ensure every cell conforms to it.
• Error: Debit and credit amounts do not match. Solution: For every transaction (especially journal entries), the total debit amount must precisely equal the total credit amount. Review your source file and find the voucher causing the imbalance.
• Error: The import fails without a specific reason. Solution: Open the tally.imp file in your Tally installation directory. It provides a detailed log that can pinpoint the exact row or data point causing the failure, giving you a clear direction for what to fix.

Final Thoughts

Importing data from Excel to Tally can transform your accounting workflow from a manual grind into an efficient, automated process. The key is in diligent preparation of your source file. For most users, using a dedicated TDL add-on is the simplest and most effective path to success, directly connecting the two programs without complex file conversions.

While mastering data transfers between tools like Excel and Tally streamlines your accounting, combining performance data from all your other platforms presents a similar challenge. Here at Graphed, we built a solution for that. Instead of exporting CSVs from Google Analytics, Shopify, and social media ads, we let you connect them all in seconds. You can ask questions in plain English - like "Which marketing campaigns drove the most sales last month?" - and get instant, AI-powered dashboards, saving you hours of manual report building.