Accounting Data: Tally & GST Returns to Excel
Move accounting data between Tally, GST returns, and spreadsheets. Convert Tally XML and GSTR JSON to Excel for review, filing, and reconciliation.
Accounting data ends up locked in the wrong shape: vouchers sit inside Tally XML exports, and GST returns come off the portal as JSON. Neither is something you can total, filter, or hand to a colleague - so reviewing a period or reconciling a return means squinting at raw tags and braces.
The converter reads a Tally XML export or a GSTR JSON file and rebuilds it as rows and columns - one line per invoice or voucher, with GSTIN, invoice number, date, taxable value, and tax in their own cells. Ready for review, filing, and reconciliation in any spreadsheet.
From GST return JSON to a sheet you can reconcile
A short GSTR-1 B2B return with three invoices, and the same data shaped three different ways depending on what your next step needs.
GSTR-1 return (JSON)
{"gstin": "27AAAAA0000A1Z5","fp": "062026","b2b": [{"ctin": "29BBBBB1111B1Z6","inv": [{ "inum": "INV-001", "idt": "05-06-2026", "val": 11800.00,"itms": [{ "num": 1, "itm_det": { "rt": 18, "txval": 10000.00, "iamt": 1800.00 } }] },{ "inum": "INV-002", "idt": "12-06-2026", "val": 5900.00,"itms": [{ "num": 1, "itm_det": { "rt": 18, "txval": 5000.00, "iamt": 900.00 } }] }]},{"ctin": "24CCCCC2222C1Z7","inv": [{ "inum": "INV-003", "idt": "20-06-2026", "val": 4720.00,"itms": [{ "num": 1, "itm_det": { "rt": 18, "txval": 4000.00, "iamt": 720.00 } }] }]}]}
The same data, shaped several ways
One row per invoice (CSV)
| Supplier GSTIN | Counterparty GSTIN | Invoice No | Invoice Date | Rate % | Taxable Value | IGST | Invoice Value |
|---|---|---|---|---|---|---|---|
| 27AAAAA0000A1Z5 | 29BBBBB1111B1Z6 | INV-001 | 2026-06-05 | 18 | 10000.00 | 1800.00 | 11800.00 |
| 27AAAAA0000A1Z5 | 29BBBBB1111B1Z6 | INV-002 | 2026-06-12 | 18 | 5000.00 | 900.00 | 5900.00 |
| 27AAAAA0000A1Z5 | 24CCCCC2222C1Z7 | INV-003 | 2026-06-20 | 18 | 4000.00 | 720.00 | 4720.00 |
Every invoice on its own line with the taxable value and tax split out - the flat layout most spreadsheets and accounting imports expect.
Summary by counterparty (CSV)
| Counterparty GSTIN | Invoices | Taxable Value | IGST | Invoice Value |
|---|---|---|---|---|
| 29BBBBB1111B1Z6 | 2 | 15000.00 | 2700.00 | 17700.00 |
| 24CCCCC2222C1Z7 | 1 | 4000.00 | 720.00 | 4720.00 |
One line per party with totals rolled up - the view you use to reconcile a return against your ledger before filing.
Tally sales voucher (custom)
<VOUCHER VCHTYPE="Sales" ACTION="Create"><DATE>20260605</DATE><VOUCHERNUMBER>INV-001</VOUCHERNUMBER><PARTYGSTIN>29BBBBB1111B1Z6</PARTYGSTIN><LEDGERENTRIES.LIST><LEDGERNAME>Sales - IGST 18%</LEDGERNAME><AMOUNT>-10000.00</AMOUNT></LEDGERENTRIES.LIST><LEDGERENTRIES.LIST><LEDGERNAME>Output IGST</LEDGERNAME><AMOUNT>-1800.00</AMOUNT></LEDGERENTRIES.LIST></VOUCHER>
Need the data posted straight into your accounting system, or laid out for a different GST section - for example bank entries turned into Tally import XML, or postings mapped across systems? That is a custom converter built for your exact ledgers and chart of accounts.
Converters for this
Who uses this
Accountants
Pull a full period out of Tally or a GST return into a spreadsheet in seconds, review it, and reconcile against your ledgers - instead of reading raw XML and JSON.
Tax professionals
Turn GSTR-1, GSTR-2B, and other return files into clean sheets you can check, match against purchases, and share with clients before filing.
Bookkeepers
Move vouchers and invoices between Tally, spreadsheets, and other tools without retyping - keep every client on the same tidy layout.
Finance & business owners
See what a return or an export actually contains in plain columns, so you can sign off on the numbers without wrestling with the file format.
How it works
- 1
Upload the file
Add your Tally XML export or GST return JSON, or paste a link to it. No software to install and nothing to configure.
- 2
The records are rebuilt
The converter reads each invoice or voucher and lays it out as rows and columns - GSTIN, invoice number, date, taxable value, and tax each in their own cell.
- 3
Download and reconcile
Download Excel or CSV, check the totals against your books or the return summary, and file or post with confidence.
Frequently asked questions
How do I convert Tally XML to Excel?
Upload the Tally XML export and download an Excel or CSV file with one row per voucher - date, voucher number, party GSTIN, ledger, and amounts in separate columns. It reads the vouchers inside the file, so day books and full-period exports come back in the same clean layout.
How do I convert GSTR JSON to Excel?
Upload the GST return JSON downloaded from the portal, and download an Excel or CSV file with each invoice on its own line and the taxable value and tax split into columns. It works with the return files you already have, no reformatting first.
Can I convert a GSTR-1 JSON to Excel for review before filing?
Yes. A GSTR-1 JSON converts into a flat sheet - one row per B2B invoice plus rolled-up totals by counterparty - so you can review every line and match the totals against your books before you file.
Which GST return files can I turn into a spreadsheet?
Any GST return JSON that follows the standard portal structure - GSTR-1, GSTR-2B, and similar - converts into Excel or CSV. If your return has a section or layout you need shaped a specific way, that can be built as a custom converter.
Is my accounting data kept private?
Files are encrypted in transit, source files are deleted right after conversion, and results are removed automatically within 24 hours. Your invoices, GSTINs, and ledgers are never shared.
More conversion use cases
Bank Statements to Excel
Turn bank statements from any bank into clean Excel or CSV - dates, descriptions, and amounts in columns you can total and reconcile. No retyping.
ExploreInvoice & E-Invoice Data
Extract invoice and e-invoice data into Excel or CSV for accounts payable, reconciliation, and reporting - from XML, JSON, or PDF invoices.
ExploreFinancial & Transaction Data
Turn transaction exports, ledgers, and financial feeds into analysis-ready Excel or CSV - trusted by finance teams and banks for high-volume data.
ExploreXML to Spreadsheet
Turn business XML - exports, feeds, API payloads - into Excel or CSV, including large and deeply nested files, with control over how it is laid out.
ExploreJSON & API Data to Spreadsheet
Turn JSON files and API responses into Excel or CSV - flatten nested objects and arrays into the exact rows and columns you need for analysis.
ExploreEDI & B2B Data
Turn EDI and other B2B interchange data into readable Excel or CSV for orders, shipments, and invoices across logistics, retail, and healthcare.
ExploreE-Commerce & Product Feeds
Convert product, inventory, and catalog feeds between platforms and spreadsheets - remap columns and standardize formats for any marketplace.
ExploreNeed a variation of this?
Tell us your exact input and the output shape you need. We build a dedicated converter for it - usually within days, free with any paid plan.