Tally 2 Excel — Trusted
With the release of Tally Prime 4.0 (and future versions), the process is becoming smarter. New features include:
| Problem | Solution | | :--- | :--- | | (green triangle in Excel) | Use =VALUE(A1) or export as XML, then open in Excel. | | Dates appear as numbers (e.g., 44123) | Format column as Date (short date). | | Multi-line addresses merge into one cell | Use Tally Excel Add-in or third-party tool with row-per-line option. | | Cannot export voucher splits (e.g., one invoice with 10 stock items) | Native export flattens it; use third-party tool with “explode entries” setting. | | Excel crashes on large export | Export in chunks (e.g., 3 months at a time) or use Tally ODBC with Power Query. |
Download our free "Tally 2 Excel Macro Template" (available in the resource section below) to automate the cleaning of Cr/Dr signs and date formatting in under 5 seconds.
: Highlighted as a solution for hassle-free data conversion , it is favored for its simplicity in moving masters and vouchers without manual entry. tally 2 excel
Tally is an excellent accounting software that offers a range of features to manage financial transactions, inventory, and payroll. However, there are situations where exporting data to Excel becomes necessary:
While there is no single software product officially titled "Tally 2 Excel," several third-party utilities and built-in features fulfill this specific function. These tools are primarily reviewed for their ability to eliminate manual data entry by automating the export/import process between (ERP 9 or Prime) and Microsoft Excel . Top-Rated Third-Party Utilities
Formatting Mess: Tally exports often include merged cells and blank rows. Use Excel’s "Find & Select > Go To Special > Blanks" to quickly clean up the sheet. With the release of Tally Prime 4
Creating dashboards that refresh with one click. Requirements: Tally must be running on the server (or locally). This method requires technical know-how.
Method 2: Using ODBC for Live Data Sync (Best for Real-Time Reporting)
Tally will generate the file and automatically open it in Excel. | | Multi-line addresses merge into one cell
Doing the same export every Monday morning? Automate it.
: Experts on YouTube demonstrate that users can export any report (Balance Sheets, Day Books) directly to Excel by selecting a company and using the shortcut Alt + E .