How to Export Tally Data to Excel

Q: What is the shortcut to export Tally data to Excel?

In most TallyPrime versions, press **Ctrl+E** to export the current report, then choose Excel (.xlsx) as the format. **Alt+E** opens the wider export menu for masters, transactions and full data. Exact keys can vary by version — confirm in your own Tally installation.

Q: Why is my Tally Excel export slow or large?

Very large reports export faster as **CSV** than as.xlsx. Export to CSV, then open it in Excel and save as a workbook if you need formatting or formulas.

Last updated: 27 June 2026 · A practical, keystroke-level guide for TallyPrime users who live in spreadsheets.

To export Tally data to Excel, open any report or voucher in TallyPrime, press Ctrl+E (or Alt+E for the export menu in most TallyPrime versions), choose Excel (.xlsx) as the format, set the destination folder, and press E to export. You can do this for ledgers, day books, GST returns, stock summaries and almost any report. The exported file opens directly in Excel, ready to filter, pivot or reconcile.

Key takeaways

Ctrl+E exports the current report in most TallyPrime versions; Alt+E opens the broader export menu for masters, transactions and full data. Confirm in your own version as keystrokes can vary.
Excel (.xlsx) is a built-in export format in TallyPrime, alongside PDF, CSV, JSON, XML and HTML.
Almost any report exports — ledgers, trial balance, P&L, balance sheet, stock summary, GST returns (GSTR-1/3B) and the day book.
For large datasets, CSV exports faster than.xlsx; you can open the CSV in Excel afterwards.
Once in Excel, you can pivot, filter and reconcile — which is exactly why many owners end up doing most analysis in Excel anyway.
If every report ends up in Excel, an Excel-native tool removes the export round-trip entirely.

Fact box. TallyPrime can export company data — masters, transactions, vouchers, reports and GST returns — to Excel (.xlsx), CSV, PDF, JSON, XML and HTML. The export is configurable: you choose the format, the destination folder and the file name. (Source: TallyHelp export documentation, 2026 — verify against your installed version.)

How do I export a single report from Tally to Excel?

Open the report, press Ctrl+E, select Excel as the format, confirm the folder and file name, then press E to export. This is the fastest route for one-off exports like a single ledger or a month's day book. The exact keys below apply to most TallyPrime versions — confirm in your own installation if anything differs.

Open the report you want (for example, Gateway of Tally → Display More Reports → Account Books → Ledger).
Press Ctrl+E (Export → Current).
In the export screen, set File Format to Excel (Spreadsheet).
Press C (Configure) if you want to change which columns or details are included.
Check the export location (folder) and file name.
Press E to export. The.xlsx file is saved to the folder you chose.

Open the saved file in Excel and it behaves like any other workbook — sort, filter, add formulas or build a pivot table.

How do I export ledgers, GST returns and full data?

Use Alt+E (the export menu in most TallyPrime versions) when you want to export more than the current screen — such as all masters, all vouchers, or a GST return. The current-report shortcut handles one report; the export menu handles bulk and structured data.

What you want to export	Where to start in TallyPrime	Typical format
A single ledger	Open the ledger → Ctrl+E	Excel / PDF
Day book (all vouchers for a period)	Display More Reports → Day Book → Ctrl+E	Excel / CSV
Trial balance / P&L / Balance Sheet	Open the report → Ctrl+E	Excel
Stock summary	Stock Summary → Ctrl+E	Excel
GSTR-1 / GSTR-3B	GST Reports → open return → Ctrl+E	Excel / JSON
All masters or all vouchers	Alt+E → choose Masters / Transactions	Excel / XML

Fact box. For large exports, choosing CSV instead of.xlsx is noticeably faster in TallyPrime; you can open the resulting CSV in Excel and re-save it as a workbook if you need formulas or formatting. (Source: TallyHelp and Tally community guidance, 2026.)

What can I do once the data is in Excel?

Once exported, your Tally data is just rows and columns — you can filter, pivot, reconcile against bank statements or GST portal downloads, and build any report Tally doesn't offer. This is the real reason owners search for this: Excel is where the flexible analysis happens.

Common next steps in Excel:

Reconcile GSTR-2B (downloaded from the portal) against your purchase register.
Pivot sales by customer, item or HSN code.
Build an ageing report for receivables or payables.
Combine Tally data with data from other sources in one sheet.

The friction is that this is a one-way, manual export every time you need fresh numbers. Change a voucher in Tally and your Excel copy is instantly stale — you export again.

Is there a way to skip the export step entirely?

Yes — if most of your real work happens in Excel anyway, an Excel-native accounting and GST tool keeps the data in Excel from the start, so there is nothing to export. This is a different choice from Tally, not a Tally add-on: instead of recording in Tally and exporting to Excel, you record directly in Excel.

This suits owners who already keep half their records in spreadsheets and treat Tally as a system they export out of. It is not for businesses whose CA works entirely inside Tally or who need Tally's deep multi-user accounting. See our honest Tally alternative in Excel guide for who that fits.

How Ankeshan helps: Ankeshan keeps your invoices, ledgers and GST data inside Excel from the start — there's no Tally-to-Excel export step because the books already live in the spreadsheet, fully offline on your own PC. It's launching soon — join the waitlist.

Frequently asked questions

What is the shortcut to export Tally data to Excel? In most TallyPrime versions, press Ctrl+E to export the current report, then choose Excel (.xlsx) as the format. Alt+E opens the wider export menu for masters, transactions and full data. Exact keys can vary by version — confirm in your own Tally installation.

Can I export GST returns from Tally to Excel? Yes. Open GSTR-1 or GSTR-3B under GST Reports and press Ctrl+E. You can export to Excel for review, or to JSON for upload to the GST portal.

Why is my Tally Excel export slow or large? Very large reports export faster as CSV than as.xlsx. Export to CSV, then open it in Excel and save as a workbook if you need formatting or formulas.

Does exporting to Excel change my Tally data? No. Export is read-only — it creates a copy of the data in a new file. Your Tally company data is untouched.

Can I avoid re-exporting every time data changes? Not with export alone — each export is a snapshot. To keep data permanently in Excel, you'd use an Excel-native tool like Ankeshan instead of exporting out of Tally.

Sources

TallyPrime export documentation (help.tallysolutions.com), 2026 — keystrokes and formats may vary by version; verify in your own installation.
Ankeshan product positioning, 2026.

General information, not professional advice. Software steps and shortcuts change between versions — verify in your own Tally. Reviewed by a Chartered Accountant; last updated 27 June 2026.