How to Export Tally data To Excel format?

Hello everyone,

I am looking for an efficient way to export data from Tally (Prime / ERP 9) into Excel sheet format. Specifically, I need each voucher or master entry in a separate row, with all its fields (like ledger name, date, amount, cost center, stock items, etc.) in separate columns.

Is there a straightforward method or a reliable utility that can achieve this without manual copying? Any step-by-step guidance or recommended tools would be highly appreciated.

Thanks in advance!

Replies (5)
Quick Summary
Tally data can be exported to Excel either via built-in export or using third-party utilities. Each voucher, ledger, stock item, and cost center can be extracted into row-wise Excel format with detailed fields for reporting, analysis, and reconciliation without manual copying.

If you are looking for an easy and reliable way to export data from Tally to Excel, you can use an Excel-based utility instead of manual export or ODBC.

Key Benefits of Tally to XLTOOL Excel Export Utility:

  1. Voucher Transaction Export – All sales, purchase, payment, receipt, and journal vouchers in Excel.
  2. Master Ledger Export – Ledgers with name, group, GST, PAN, address, opening balance, etc.
  3. Master Stock Items Export – Stock items with quantity, unit, rate, and stock group.
  4. Cost Center & Department Export – All allocations included.
  5. Row-Wise & Column-Wise Format – Each entry in a row; fields in separate columns.
  6. Supports All Tally Versions – Tally Prime, Tally ERP 9, and older versions.
  7. Unlimited Data Export – No restriction on records or companies.
  8. One-Click Export – Simple, fast, and requires no technical knowledge.
  9. Time-Saving & Error-Free – Eliminates manual work and mistakes.
  10. Ready for Reporting & Analysis – Exported Excel can be used for PivotTables, charts, and reports.

You can download and try the utility here:
๐Ÿ‘‰ Download XLTOOL Tally to Excel Utility

If you are looking for an easy and reliable way to export data from Tally to Excel, you can use an Excel-based utility instead of manual export or ODBC.

Key Benefits of Tally to XLTOOL Excel Export Utility:

  1. Voucher Transaction Export – All sales, purchase, payment, receipt, and journal vouchers in Excel.
  2. Master Ledger Export – Ledgers with name, group, GST, PAN, address, opening balance, etc.
  3. Master Stock Items Export – Stock items with quantity, unit, rate, and stock group.
  4. Cost Center & Department Export – All allocations included.
  5. Row-Wise & Column-Wise Format – Each entry in a row; fields in separate columns.
  6. Supports All Tally Versions – Tally Prime, Tally ERP 9, and older versions.
  7. Unlimited Data Export – No restriction on records or companies.
  8. One-Click Export – Simple, fast, and requires no technical knowledge.
  9. Time-Saving & Error-Free – Eliminates manual work and mistakes.
  10. Ready for Reporting & Analysis – Exported Excel can be used for PivotTables, charts, and reports.

You can download and try the utility here:
๐Ÿ‘‰ Download XLTOOL Tally to Excel Utility - https://www.xltool.in/download

If you are looking for an easy and reliable way to export data from Tally to Excel, you can use an Excel-based utility instead of manual export or ODBC.

Key Benefits of Tally to XLTOOL Excel Export Utility:

Voucher Transaction Export – All sales, purchase, payment, receipt, and journal vouchers in Excel.
Master Ledger Export – Ledgers with name, group, GST, PAN, address, opening balance, etc.
Master Stock Items Export – Stock items with quantity, unit, rate, and stock group.
Cost Center & Department Export – All allocations included.
Row-Wise & Column-Wise Format – Each entry in a row; fields in separate columns.
Supports All Tally Versions – Tally Prime, Tally ERP 9, and older versions.
Unlimited Data Export – No restriction on records or companies.
One-Click Export – Simple, fast, and requires no technical knowledge.
Time-Saving & Error-Free – Eliminates manual work and mistakes.
Ready for Reporting & Analysis – Exported Excel can be used for PivotTables, charts, and reports.

You can download and try the utility here:
๐Ÿ‘‰ Download XLTOOL Tally to Excel - https://www.xltool.in/download

For a one-time export, use Tally’s Export option from the relevant voucher or master report and select Excel/Spreadsheet format. This is usually quickest, but standard reports may not place every voucher or master field—including cost centres and stock-item details—in separate columns. The exact layout depends on the report and fields required.

  • For a consistent, customised column-wise output, use a Tally definition (TDL) or a utility that reads Tally data and exports the required fields. Confirm it supports your Tally Prime/ERP 9 version and the voucher, ledger and inventory fields you need.
  • Voucher data can be one-to-many: a voucher may contain multiple ledgers, cost centres or stock items. Decide whether to use one row per voucher or one row per line item; the latter may repeat voucher-level details.
  • Test the export against a few vouchers, including those with multiple items or cost-centre allocations, before relying on it for reconciliation or reporting.

A well-designed Tally export workflow can make voucher and master data easier to reconcile and analyse in Excel. Manual extraction and reshaping are difficult to sustain; automation reduces repetitive work while keeping professional judgment in control. Our platform offers 2,000+ AI agents and 650+ integrations, covering only relevant workflows. For details on a workflow suited to your export needs, message us on WhatsApp at https://wa.me/message/3HVOZ7HIY4ESC1.

Exporting Tally data to Excel, row-wise:
• TallyPrime has a built-in export: open the report (Day Book, Ledger Vouchers, Stock Summary, List of Accounts), press Alt+E (Export), choose Excel (Spreadsheet) format and use Configure to include the details you need.
• For one row per entry with ledger, amount, cost centre and stock item in columns, open the Day Book, switch to the detailed view (Alt+F5) and enable inventory and cost-centre details in F12 (Configure) before exporting. Expect some reshaping, as one voucher can carry several ledger and item lines.
• For masters, export List of Accounts or Stock Summary to Excel; masters can also be exported in XML through Export > Masters for migration.
• For a repeatable, refreshable output, use Tally's ODBC connection: keep TallyPrime open with ODBC enabled, then in Excel use Data > Get Data > From ODBC to pull ledgers, vouchers and stock items into a table.
• Reconcile exported totals with the Trial Balance before using the data for audit or GST work.

 

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
10 November 2026
Direct Tax Manager

CAAQ CONSULTANCY PVT LTD

New Delhi

CA Final

View Details
Company
02 November 2026
Audit Executive

SRJP & Co LLP

Kochi

CA Inter

View Details
Company
13 November 2026
Chartered Accountant - Fresher

Neeraj Bhagat & Co

New Delhi

CA

View Details
Company
ARTICLESHIP 29 October 2026
Article Assistant (CA Inter / CMA Inter) - Thrissur

Varma Raja & Associates

Thrissur

CA Inter

View Details
Company
31 October 2026
Accountants

sankaran and krishnan

New Delhi

B.Com

View Details
Company
24 October 2026
CA Industrial Trainee

Fytomax Nutrition Private Limited

Aurangabad

CA Inter

View Details
Company
Featured ARTICLESHIP 28 October 2026
CA- Inter and Articles

N N V Satish & Co.,

Hyderabad

CA Inter

View Details
Company
ARTICLESHIP 07 November 2026
Article Assisstant

DPV & Associates

Chennai

CA Inter

View Details