Does it support GSTR-2A and GSTR-2B?

Yes. GSTR-2A-style downloads with sections like b2b, cdnr, and impg at the root are detected automatically, and so are GSTR-2B portal files wrapped as { chksum, data: { … } } with cpsumm, docdata, and itcsumm groups. The converter reads the gstin and return-period fields and builds one sheet per section.

Does it support GSTR-1 JSON?

Yes. A GSTR-1 outward-supplies JSON is recognised automatically from its GSTIN and return period, and each section - b2b, b2cl, b2cs, cdnr, exp, nil, hsn, and others - becomes its own sheet with one row per invoice or line item. The GSTIN and return period are repeated as context columns on every row, so each sheet is independently filterable.

Can I paste the full GSP API response?

Yes. If you have the raw JSON response from a GSP or the GST API, paste it as-is. The converter unwraps the nested data envelopes to find the actual GST document, so you do not have to strip the outer wrapper yourself.

Will my GSTINs and invoice numbers stay exact?

Yes. GSTINs, invoice numbers, and document numbers are preserved exactly - leading zeros stay intact and long numeric IDs are never shown in scientific notation or rounded. Date strings are kept verbatim, with no timezone shift or auto-formatting.

Is my data uploaded anywhere?

No. Conversion runs 100% client-side in your browser, so your GST JSON never leaves your device and we never receive or store a copy of it.

What about large or paginated 2B files?

Each file can be up to 15 MB, which covers typical monthly returns. The GST API splits very large 2B data into file parts (the fc field). The converter processes one file part per upload, so if your return came as several parts, convert each part and combine the resulting sheets in Excel.

Yes, it is completely free with no signup and no payment. Convert as many GST JSON files to Excel as you need.

Convert GST JSON to Excel (GSTR-1, 2A & 2B)

Last updated: 11 June 2026

Need a GST portal JSON file in a spreadsheet? Paste or upload it into the GST JSON to Excel converter online and download a clean .xlsx instantly. It handles GSTR-1, GSTR-2A, and GSTR-2B JSON to Excel automatically, it is free with no signup, and the conversion runs entirely in your browser - the file is never uploaded to any server.

How the GST JSON to Excel converter works

Download the JSON for your return from the GST portal (GSTR-2A or GSTR-2B), or copy the raw API response from your GSP - the converter unwraps the nested data envelopes for you.
Open the JSON to Excel converter and paste the JSON or upload the saved .json file.
Download the .xlsx - one sheet per GST section, ready to open in Excel, Google Sheets, or LibreOffice.

What you get

The converter recognises GST returns and lays them out the way you actually reconcile them, not as raw nested JSON:

One sheet per GST section. A GSTR-2B file produces sheets such as cpsumm b2b, docdata b2b, docdata cdnr, and docdata b2ba, plus a one-row itcsumm totals sheet. A GSTR-2A-style file turns each root section (b2b, cdnr, impg, …) into its own sheet. A GSTR-1 file is split the same way - b2b, b2cl, b2cs, cdnr, exp, nil, and hsn each become a sheet.
One row per invoice, credit note, or item. Supplier and invoice fields repeat down the item rows, so every row is independently filterable and pivotable - the real reconciliation format, not nested JSON crammed into one cell. See the JSON array to Excel guide for how rows and columns are mapped, and the nested JSON to Excel guide for how the supplier → invoice → item nesting is expanded.
Context columns on every row. Each row starts with the fields that identify the file - gstin, rtnprd or fp, gendt, fc, and version - whichever the file contains.
Numeric tax values. Amounts like cgst, sgst, igst, cess, txval, and val come through as real numeric cells you can sum and sort, not as text.
Original GSTN field names. Columns keep the schema keys (ctin, trdnm, inum, dt, txval, …) so the output lines up with the GSTN documentation - the converter does not rename columns to friendly labels.

Why this works for GST data

Tax data is unforgiving about exactness, and that is what makes the converter a better fit than pasting JSON into a sheet by hand. GSTINs, invoice numbers, and document numbers are preserved exactly - leading zeros stay intact and long numeric IDs are never rounded or shown in scientific notation. Date strings such as dt are kept verbatim, with no timezone shift and no automatic reformatting. And because conversion runs 100% in your browser, the file never leaves your device - which matters when the data is financial and tied to your business identity. It is free and needs no signup.

Frequently asked questions

Does it support GSTR-2A and GSTR-2B?: Yes. GSTR-2A-style downloads with sections like b2b, cdnr, and impg at the root are detected automatically, and so are GSTR-2B portal files wrapped as { chksum, data: { … } } with cpsumm, docdata, and itcsumm groups. The converter reads the gstin and return-period fields and builds one sheet per section.
Does it support GSTR-1 JSON?: Yes. A GSTR-1 outward-supplies JSON is recognised automatically from its GSTIN and return period, and each section - b2b, b2cl, b2cs, cdnr, exp, nil, hsn, and others - becomes its own sheet with one row per invoice or line item. The GSTIN and return period are repeated as context columns on every row, so each sheet is independently filterable.
Can I paste the full GSP API response?: Yes. If you have the raw JSON response from a GSP or the GST API, paste it as-is. The converter unwraps the nested data envelopes to find the actual GST document, so you do not have to strip the outer wrapper yourself.
Will my GSTINs and invoice numbers stay exact?: Yes. GSTINs, invoice numbers, and document numbers are preserved exactly - leading zeros stay intact and long numeric IDs are never shown in scientific notation or rounded. Date strings are kept verbatim, with no timezone shift or auto-formatting.
Is my data uploaded anywhere?: No. Conversion runs 100% client-side in your browser, so your GST JSON never leaves your device and we never receive or store a copy of it.
What about large or paginated 2B files?: Each file can be up to 15 MB, which covers typical monthly returns. The GST API splits very large 2B data into file parts (the fc field). The converter processes one file part per upload, so if your return came as several parts, convert each part and combine the resulting sheets in Excel.
Is this really free?: Yes, it is completely free with no signup and no payment. Convert as many GST JSON files to Excel as you need.

Related guides

See all guides or the FAQ.

Convert your GST JSON to Excel →