| 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. |
Tally uses DD-MM-YYYY , while Excel prefers MM-DD-YYYY . tally 2 excel