IndianBusinessTools
← Blog

How to Open a GSTR-1 JSON File and Read It in Excel

16 November 2026 · 6 min read

Drop your GSTR-1 JSON and see every table in rows, with the total tax, then download it as Excel

Open JSON

When you prepare GSTR-1 in software, or download it from the GST portal, you often get a JSON file. JSON is a plain-text format that computers read easily. People do not. A small return can be one very long line of brackets and codes.

This guide shows what is inside the file, how to open it, and what to check before you upload it. To see your own file as tables, use our GSTR-1 JSON Viewer. It reads the file in your browser and never uploads it.

Where a GSTR-1 JSON comes from

You usually get one in one of these ways:

Why you should open it

Three ways to open it

WayGoodNot so good
GST Returns Offline ToolOfficial. Can also change the return.Must be installed on a Windows computer.
A text editor or browserNothing to install.Very hard to read. Easy to break the file by mistake.
Our GSTR-1 JSON ViewerWorks on any computer or phone. Shows plain tables and totals. Excel download.Only reads the file. It cannot change it.

If you only need to read or check the file, the viewer is the quickest. If you need to change the return, use the Offline Tool or the GST portal.

What the parts of the file mean

A GSTR-1 JSON has a few keys at the top, then one section for each table of the form.

The top of the file

KeyMeaningExample
gstinYour GSTIN27AAPFU0939F1ZV
fpReturn period, as MMYYYY102026 is October 2026
version, hashUsed by the portal. You can ignore them.GST3.1.2

The sections

KeyGSTR-1 tableWhat it holds
b2bTable 4Invoices to buyers with a GSTIN
b2clTable 5Invoices to another state above ₹1 lakh, buyer without a GSTIN
expTable 6AExports
b2csTable 7All other sales to buyers without a GSTIN, added up by state and rate
nilTable 8Nil rated, exempt and non-GST sales
b2ba, b2cla, cdnraTable 9A, 9CChanges to invoices and notes of earlier months
cdnr, cdnurTable 9BCredit and debit notes, to registered and unregistered buyers
b2csaTable 10Changes to Table 7 of earlier months
at, txpdTable 11Advances received, and advances adjusted
hsnTable 12HSN summary, with a B2B part (hsn_b2b) and a B2C part (hsn_b2c)
doc_issueTable 13Invoice and note numbers you used, and how many were cancelled
supecoTable 14Sales through e-commerce operators like Amazon

A file only has the sections you used. If you had no exports, there is no exp.

The amounts

The same short names are used everywhere in the file:

KeyMeaning
ctinBuyer's GSTIN
inum, idt, valInvoice number, date, and full invoice value
posPlace of supply, as a state code: 27 is Maharashtra, 29 is Karnataka
rtGST rate
txvalTaxable value (before GST)
iamt, camt, samt, csamtIGST, CGST, SGST, and cess

A worked example

Here is one B2B invoice, as it looks in the file:

"b2b": [{
  "ctin": "29AAPFU0939F1ZR",
  "inv": [{
    "inum": "INV-101", "idt": "05-10-2026", "val": 59000, "pos": "29",
    "itms": [{ "num": 1, "itm_det": { "rt": 18, "txval": 50000, "iamt": 9000 } }]
  }]
}]

Read it like this:

The GSTR-1 JSON Viewer shows this as one row in the Table 4 list. It adds up all tables, takes credit notes away, and shows the total tax.

What to check before you upload

  1. GSTIN: it must be yours, in capital letters. The portal accepts the file only for the GSTIN you log in with.
  2. Return period: fp must be the month you are filing.
  3. Totals: compare the taxable value and tax of each table with your sales register.
  4. Credit notes: check they are in Table 9B, and are not counted as sales.
  5. HSN summary: the Table 12 total should be close to the total of your sales tables.
  6. Table 14: if you sell on Amazon or Flipkart, check it against the TCS amounts the operator reports.
  7. Table 13: check the invoice numbers and the cancelled count.

If you change the JSON by hand, one missing comma or bracket breaks the whole file. Open it in the viewer again after the change. If the file is broken, it tells you.

Summary

Sources

We wrote this from the GSTR-1 form and the JSON layout used by the portal, as we understood them in November 2026. The portal does not publish a full guide to every JSON key, and it can change the layout. Please check the latest on the GST portal and ask your CA for your case. This is not legal advice.

Frequently asked questions

Can I open a GSTR-1 JSON file in Excel directly?

Not in a useful way. Excel can load JSON with Power Query, but a GSTR-1 file has tables inside tables, such as invoices inside each buyer and items inside each invoice. You get many nested columns. A GSTR-1 viewer turns it into one plain sheet per table.

Is it safe to open my GSTR-1 file on a website?

Only if the file stays on your computer. Our GSTR-1 JSON Viewer reads the file in your own browser and does not upload it. Before you use any other site, check what it says about uploads. Your GSTR-1 has your buyers' GSTINs and your sales.

What does fp mean in a GSTR-1 JSON?

fp is the return period, written as month and year: MMYYYY. For example, 102026 means October 2026. If it is wrong, the portal will not accept the file for the month you are filing.

Why do the totals in my JSON not match GSTR-3B?

GSTR-3B takes your sales tax from GSTR-1. A difference usually comes from credit notes, amendments to earlier months, or advances. Check Table 9B (credit notes) and the amendment tables first.

Found a mistake, or want a tool we don’t have? Tell us — we read every message.