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 (3)
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

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
20 September 2026
Semi Qualified CA

Navin & Associates

Mumbai

CA Inter

View Details
Company
26 September 2026
Chartered Accountant

pushpganga ventures

Pune

CA

View Details
Company
30 September 2026
Senior Accounts Executive

Codeboard Technology

Chennai

MBA

View Details
Company
09 September 2026
Chartered Accountant

Aviv Global Private Limited

Ahmedabad

CA

View Details
Company
ARTICLESHIP 28 September 2026
Junior Accountant

J S P M & Associates LLP

Pune

B.Com

View Details
Company
08 September 2026
Audit Executive

Thammana & Associates

Srikakulam

B.Com

View Details
Company
09 September 2026
SENIOR AUDITOR & ACCOUNTS MANAGER

Anupam Parashar & Co.

Ghaziabad

CA Final

View Details
Company
ARTICLESHIP 07 September 2026
Article/ Paid Assistant

Murali and Sumeet Chartered Accountant

Bengaluru

CA Foundation

View Details