GSTR-2A JSON to Excel Converter
Convert GSTR-2A JSON to multi-sheet Excel — free, browser-only
Upload a GSTR-2A JSON (auto-populated by GSTN from supplier filings) and download a structured multi-sheet Excel. Or upload an Excel to reconstruct the JSON. All in your browser.
2A reconciliation in 5 minutes, not 5 hours.
Upload purchase data, we match it line-by-line with 2A and email you a clean ITC report.
What is a GSTR-2A JSON to Excel Converter?
GSTR-2A is a dynamic read-only form auto-populated by GSTN from your suppliers' GSTR-1 filings. It shows all inward supplies (purchases) that your suppliers have declared against your GSTIN. This is the primary data source for verifying ITC eligibility — if an invoice is not in GSTR-2A, ITC may not be available.
The GSTR-2A JSON downloaded from the GSTN portal uses the same nested schema as GSTR-1 — invoices grouped by supplier GSTIN. This converter flattens those groups into individual rows across multiple Excel sheets, one per section, so your team can quickly audit which suppliers have filed and which have not.
This tool is often the first step before running the GSTR-2A Reconciliation tool (also on this site), which matches the 2A data against your purchase register to find missing or mismatched invoices.
Why use this GSTR-2A JSON to Excel Converter
Built for Indians, by Indians. Every number, every formula, every slab — tuned to FY 2026-27 reality.
Multi-sheet Excel
b2b, cdnr, cdnur, impg, imps and amendment sections each get their own Excel sheet with one row per invoice.
Flattened supplier rows
GSTN nests invoices under supplier GSTIN — each invoice becomes its own row with the ctin column preserved.
Section search
Filter rows by GSTIN, invoice number, date, or any amount field to locate specific transactions instantly.
Private
All processing in your browser. No upload, no server, no account required.
Using the GSTR-2A JSON to Excel Converter in 4 steps
No onboarding, no signup. Answer three fields and the numbers update live.
Download 2A JSON from GSTN portal
Log in to GST portal → Returns → View GSTR-2A → Download JSON. Save the file to your device.
Upload here
Drag and drop the JSON file or click to browse. Multiple files can be uploaded and merged.
Review sections
Click section pills to switch between b2b, cdnr, etc. Use the filter to search for specific suppliers or invoices.
Download Excel
Click "Download Excel (all sections)" to get a multi-sheet .xlsx. Use the GSTR-2A Reconciliation tool to match against your purchase register.
Tips to get the most out of it
Download GSTR-2A at least once per month after the 10th (when supplier GSTR-1 filings are due) to get the most current auto-populated data.
Check the _meta sheet in the downloaded Excel for your GSTIN and filing period to confirm you downloaded the right period's data.
Use the b2b section to count how many invoices each supplier has declared. Suppliers with significantly fewer invoices than your purchase records warrant a follow-up.
GSTR-2A includes IMPG (imports of goods from ICEGATE) and ISD credits — don't overlook these when calculating total ITC available.
After converting, run the GSTR-2A Reconciliation tool on this site to systematically match 2A data against your purchase register and generate a reconciliation report.
Real-world scenarios
How Indians actually use this converter — concrete inputs, concrete outcomes.
Monthly ITC audit
Finance team downloads GSTR-2A JSON on the 15th of each month, converts to Excel, pivots b2b by supplier GSTIN, and compares total invoice count against purchase register to identify non-filer suppliers.
Vendor compliance check
Procurement team extracts the GSTR-2A Excel b2b sheet and filters for key vendors. Any vendor with missing invoices gets a compliance email before the ITC window closes.
ITC eligibility verification
CA uses the converter to extract all GSTR-2A invoices above ₹1 lakh, cross-checks each against GST-registered vendor list, and flags any invoices from vendors whose registration has been cancelled.
Frequently Asked Questions
Still have a question? Our team replies within a business day.
GSTR-2A is dynamic — it updates every time a supplier files or amends their GSTR-1. GSTR-2B is a static monthly statement generated on the 14th of each month and does not change after that. GSTR-2B is the basis for ITC claims from FY 2021-22 onwards.
From FY 2021-22, ITC is restricted to 105% of eligible ITC as per GSTR-2B (not 2A). GSTR-2A is a dynamic reference; use GSTR-2B for actual ITC computation.
Suppliers who have not yet filed GSTR-1 for the period won't appear. GSTR-2A is auto-populated from supplier filings, so late or non-filers create gaps.
The downloaded Excel is a read-only reference. GSTR-2A is auto-populated by GSTN and cannot be edited by the recipient. Discrepancies must be resolved with the supplier.
No. This tool is a converter, not a portal integration. You must download the JSON from the GSTN portal yourself and upload it here for conversion.
Yes. All conversion is browser-side JavaScript. Nothing is sent to any server. The data is gone when you close the tab.
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