GSTR-2 JSON to Excel Converter
Convert GSTR-2 JSON to multi-sheet Excel — free, browser-only
Upload a GSTR-2 JSON and get a multi-sheet Excel with every inward supply section. Or upload the Excel back to reconstruct the JSON for review. All processing stays in your browser.
Stop reconciling 2A/2B in Excel.
We auto-match purchase register with GSTR-2A/2B and flag mismatches before you file. ₹999/mo.
What is a GSTR-2 JSON to Excel Converter?
GSTR-2 is the inward supply return that captures all purchases a GST-registered business makes in a tax period. While GSTR-2 filing was suspended after 2017, the underlying format remains in use for ITC reconciliation workflows and is still referenced by many accounting systems for internal reconciliation against GSTR-2A and 2B.
This converter handles the full GSTR-2 JSON schema including B2B invoices, credit/debit notes from registered and unregistered suppliers, imports of goods (IMPG), and imports of services (IMPS). Each section is flattened into its own Excel sheet, making large returns easy to review and audit.
Your data stays entirely in your browser. There is no server, no upload, and no sign-in. The tool uses the same GSTN schema awareness as the GSTR-1 converter so field names and nested structures are handled correctly.
Why use this GSTR-2 JSON to Excel Converter
Built for Indians, by Indians. Every number, every formula, every slab — tuned to FY 2026-27 reality.
Section-per-sheet Excel
b2b, cdnr, cdnur, impg, imps, and all amendment sections each become a separate Excel sheet.
JSON ↔ Excel both ways
Parse GSTN JSON to Excel for review, or upload the Excel back to get a reconstructed JSON document.
Row-level search
Filter any section by GSTIN, invoice number, amount or date to find specific transactions in seconds.
100% private
All file parsing and Excel generation runs locally in your browser. Nothing is sent to any server.
Using the GSTR-2 JSON to Excel Converter in 4 steps
No onboarding, no signup. Answer three fields and the numbers update live.
Upload GSTR-2 file
Drag and drop or browse for a .json or .xlsx file. Multi-file upload merges sections automatically.
Parse and review
Click "Parse files". Sections are listed as pills — click each to preview the rows in that section.
Filter if needed
Use the search box to filter rows by GSTIN, invoice number, or any other field.
Download your format
Download all sections as a multi-sheet .xlsx, download the reconstructed JSON, or export the active section as .csv.
Tips to get the most out of it
Use GSTR-2 JSON as a base for ITC reconciliation — compare it against your purchase register to verify every inward invoice is captured.
IMPG (imports of goods) rows come from ICEGATE, not from suppliers. Verify these against Bill of Entry numbers in your import documentation.
When reviewing B2B rows, cross-check the supplier GSTIN (ctin) against your vendor master to catch any GSTINs that have been cancelled or suspended.
For credit notes (cdnr), verify the original invoice number is captured correctly — mismatches here cause ITC reversal during GST audits.
Keep section-wise Excel files for each return period as part of your GST records. GSTN recommends retaining records for 6 years.
Real-world scenarios
How Indians actually use this converter — concrete inputs, concrete outcomes.
ITC verification before GSTR-3B filing
Accounts team converts GSTR-2 JSON to Excel, pivots the b2b sheet by supplier to total eligible ITC, then compares against the GSTR-3B ITC claim amount to ensure no over-claim.
Import duty and IGST reconciliation
Finance manager downloads the impg sheet from the converter, matches each row against Bill of Entry records to confirm IGST paid on imports matches what is captured in GSTR-2.
Spot-checking credit notes
CA uses the cdnr section in Excel to verify that all credit notes from major suppliers are dated within the same return period and have matching original invoice references.
Frequently Asked Questions
Still have a question? Our team replies within a business day.
GSTR-2 auto-population and mandatory filing was suspended in 2017. However, the JSON schema is still used internally by many accounting systems and for reconciliation with GSTR-2A/2B. This tool works with that schema.
b2b, b2ba, cdnr, cdnra, cdnur, cdnura, impg, imps, at, ata, txpd, txpda, itc, isd, nil, hsn — all standard GSTR-2 sections.
The converter works with the same schema but for dedicated 2A/2B functionality (including reconciliation with your purchase register) use the GSTR-2A Converter or GSTR-2B Converter tools on this site.
GSTN auto-populates IMPG (imports of goods) from ICEGATE (Indian Customs) data. These are not self-reported — they flow from Bill of Entry filings. You cannot edit these in GSTR-2 directly.
Yes. Files up to 15 MB are supported. Large returns with thousands of invoices process in a few seconds entirely in your browser.
Completely. All processing happens in your browser. No data is sent to any server. Close the tab and it's gone.
Want expert help beyond the converter? Talk to our team.
Our finance team helps Indian businesses and individuals plan investments, file taxes, and build wealth — without the jargon.
Book a free consultationLet's talk about your business.
Tell us what you're working on and where you want to go. We'll put together a plan. No obligation, no sales pitch.
- Free 30-minute call
- A plan built around your goals
- No obligation, no pressure
- Your own account manager