GST JSON to Excel converter

What is a Gst Json To Excel?

Convert Complex Government GST JSON to Multi-Sheet Excel Workbooks

Indian GST taxpayers, chartered accountants, and ERP operations frequently download JSON files from the NIC E-Invoice Portal and the GSTN Common Portal (GSTR-1, GSTR-2B). Because these JSON payloads contain deeply nested object trees (such as b2b[].inv[].itms[]), standard spreadsheet applications like Microsoft Excel and Google Sheets cannot open or analyze them directly.

DevDeskApp flattens nested tax JSON payloads into clean, multi-sheet .xlsx workbooks with separate Invoices Summary and Itemized Line Details tabs, ready for audit reconciliation.

Supported GST Document Formats

  • NIC E-Invoice (v1.03 & v1.1): Decodes 64-character IRN, Ack No, Seller GSTIN, Buyer GSTIN, HSN/SAC codes, Taxable values, CGST, SGST, IGST, and Total Invoice Value.
  • GSTR-1 B2B Invoices: Flattens nested B2B invoice arrays into tabular rows containing Counterparty GSTIN (CTIN), Invoice Number, Invoice Date, POS, Reverse Charge flag, and tax amounts.
  • GSTR-2B Auto-Drafted ITC: Parses counterparty filing status, ITC eligibility flags, and monthly input tax credit amounts.
  • E-Way Bill System: Converts E-Way Bill JSON files with vehicle number, trans distance, and transporter ID into readable tables.

Practical Reconciliation Example

Consider a GSTR-1 JSON file containing 2 B2B invoices with 18% IGST:

  • Input JSON: { "gstin": "27AAAAA0000A1Z5", "b2b": [{ "ctin": "29BBBBB1111B1Z2", "inv": [{ "inum": "INV-101", "val": 1180, "itms": [{ "itm_det": { "rt": 18, "txval": 1000, "iamt": 180 } }] }] }] }
  • Excel Output Tab 1 (Invoices): INV-101 | 20-09-2026 | 27AAAAA0000A1Z5 | 29BBBBB1111B1Z2 | Taxable: 1,000 | Total: 1,180
  • Excel Output Tab 2 (Line Items): INV-101 | Item #1 | HSN: 998314 | Rate: 18% | Taxable: 1,000 | IGST: 180 | CGST: 0 | SGST: 0

Financial Privacy: Zero Server Transfers

Financial records and GSTIN tax details are strictly confidential. Our tool executes 100% in your browser using SheetJS (xlsx). Your turnover figures and customer invoice lists are never transmitted to any third-party server.

Related Tools & Tax Resources

Frequently Asked Questions: GST E-Invoice & GSTR-1 to Excel Conversion

Why can Microsoft Excel not open GSTR-1 or E-Invoice JSON files directly?

Government GST JSON files use nested hierarchical arrays where one invoice can contain multiple tax rate line items (e.g. 5%, 12%, 18%). Standard Excel CSV imports cannot flatten these multi-level arrays and result in corrupted or unreadable cells.

Is my company financial and turnover data safe when using this tool?

Yes, 100%. All parsing, calculation, and Excel workbook construction occurs locally in your client browser memory. No data is sent across the internet, ensuring total confidentiality for internal tax audits.

Does the exported Excel file contain multiple sheets?

Yes. The generated .xlsx file contains two structured sheets: "Invoices" (one row per document with buyer, seller, and total values) and "Line Items" (one row per HSN/item code with tax rate breakdown).

Can I upload files generated from Tally, Busy, or ClearTax?

Yes. Any JSON file conforming to the official GSTN GSTR-1 schema or NIC E-Invoice schema (whether exported by TallyPrime, Busy, SAP, Zoho Books, or ClearTax) is supported.

What is the maximum JSON file size supported?

Because the tool runs directly in your 64-bit browser engine, it comfortably parses large GST JSON payloads up to 50 MB (containing tens of thousands of invoices) in seconds.

Does it support E-Way Bill JSON files?

Yes. E-Way Bill JSON downloads containing Part-A and Part-B vehicle details are automatically identified and formatted into clean Excel columns.

You May Also Need