Convert GST JSON to Excel (GSTR-1, 2A, 2B)
Upload your GST portal JSON file and get a clean Excel workbook with one sheet per section (B2B, CDNR, IMPG, and more). Each invoice becomes a row with supplier GSTIN, trade name, invoice number, date, taxable value, CGST, SGST, IGST, and cess. Context fields (your GSTIN, return period, generation date) appear on every row for easy filtering. This converter handles bare GSTR-2A files, portal GSTR-2B downloads, and full GSP API response envelopes. Everything runs in your browser: your tax data never leaves your device.
Drag and drop your file here
or click to browse. Accepts .json up to 50 MB.
Your data never leaves your browser. Example: gstr2b_112024.json
How accurate is this? This converter parses your file using deterministic rules (no AI or guessing). The output matches the source data exactly. If you notice any issue, please report it using the link below.
How to Export and Convert GST Return (JSON) Data
- 1
Download from the GST Portal
Log in to gst.gov.in, navigate to Returns, select the period, and download the JSON file for GSTR-2A, 2B, or 1.
- 2
Or get it from your GSP
If you use a GST Suvidha Provider (GSP), export the API response as a JSON file. The converter handles the nested data/data/data envelope automatically.
- 3
Upload the file here
Drag and drop or click to select your .json file. The converter auto-detects the GST format.
- 4
Review the preview
Check supplier names, invoice numbers, and tax amounts.
- 5
Download your workbook
Click "Download XLSX" to get an Excel file with one sheet per section.
Frequently Asked Questions
- Does it support GSTR-2A and GSTR-2B?
- Yes. The converter auto-detects both formats by looking for the gstin field and GST section keys (b2b, cdnr, impg, etc.). It creates one sheet per section with flattened invoice rows.
- Does it support GSTR-1 JSON?
- Yes. GSTR-1 JSON files use the same section structure (b2b, b2cl, b2cs, etc.) and are handled the same way.
- Can I paste the full GSP API response?
- Yes. The converter unwraps nested envelopes like {"code": 200, "data": {"data": {"data": {...}}}} automatically, digging through up to 4 levels to find the GST document.
- Will my GSTINs and invoice numbers stay exact?
- Yes. GSTINs, invoice numbers, and other alphanumeric identifiers are written as text cells. No rounding, no scientific notation, no leading-zero stripping.
- Is my data uploaded anywhere?
- No. The conversion runs 100% in your browser using JavaScript. Your tax data never leaves your device. You can disconnect from the internet and the tool still works.
- What about large or paginated 2B files?
- The converter supports files up to 50 MB. For paginated returns, convert each page separately.
- Is this really free?
- Yes. Completely free, no signup, no limits on conversions.
Related Converters
This tool is not affiliated with or endorsed by GST Return (JSON) or its parent company. All trademarks belong to their respective owners.