Convert GSTR JSON to Excel

GST returns are exported as JSON so they can be uploaded back to the portal, but JSON is hard to read by hand. The invoices are grouped under each counterparty GSTIN, and every invoice holds its own list of line items, so opening the file in a plain viewer is overwhelming. This converter rearranges that data into a tidy spreadsheet, so you can reconcile, audit and report without retyping anything.

• GSTR-1 - outward supplies (B2B, B2C Large, B2C Small, Credit/Debit Notes, Exports, HSN Summary, Documents Issued).
• GSTR-2A and GSTR-2B - inward supplies and purchase reconciliation.
• GSTR-3B - the summary return (outward and reverse-charge supplies, eligible ITC, exempt and non-GST inward supplies).

The return type is detected automatically from the file, so you do not need to tell the converter which form it is.

Each section of the return becomes its own sheet, with one row per invoice line and clear, human-readable column headers instead of the short JSON codes:

• A Summary sheet with the GSTIN, tax period and a record count per section.
• One sheet per section, for example B2B Invoices, B2C Large, B2C Small, Credit-Debit Notes, HSN Summary and Documents Issued.
• Readable headers such as Counterparty GSTIN, Invoice No, Invoice Date, Taxable Value, IGST, CGST, SGST/UTGST and Cess.
• Place of Supply shown with the state name (for example 33-Tamil Nadu), and codes such as Reverse Charge and Note Type spelled out.
• Amounts kept as numbers, so totals and formulas work immediately.

A small slice of a GSTR-1 JSON, where one B2B invoice has two line items at different tax rates:

"b2b": [
  {
    "ctin": "33AACHR0685N1ZU",
    "inv": [
      {
        "inum": "INV-0001",
        "idt": "15-06-2026",
        "val": 217040.74,
        "pos": "33",
        "itms": [
          { "num": 1, "itm_det": { "rt": 12, "txval": 193786.38, "iamt": 23254.37 } },
          { "num": 2, "itm_det": { "rt": 18, "txval": 50715.38, "iamt": 9128.77 } }
        ]
      }
    ]
  }
]

becomes two rows on the B2B Invoices sheet, each carrying the invoice details next to its own line:

Have a whole period or several GSTINs to process? Put the return files into a single .zip (or .tar.gz) and upload it - each file inside is converted to its own Excel workbook. Converting an archive of multiple files needs a free account, so sign up and confirm your email first. To convert a single return, just upload the .json directly.

Yes. Your tax files are sensitive, so every file uploaded to our service is encrypted and automatically deleted after 24 hours. Your data is never shared.

If you also work with the data in other formats, try our JSON to Excel and Excel to CSV converters.