IndianBusinessTools

GST & Tax

GSTR-1 JSON Viewer and Excel Converter

Open a GSTR-1 JSON file and read it as tables: B2B, B2C, credit notes, HSN and more. Download it as Excel.

Your file is read in your own browser. It is never uploaded.

Or paste the JSON instead

Which files work

  • A GSTR-1 JSON made by your accounting or billing software.
  • A JSON made by our Amazon MTR to GSTR-1 JSON tool.
  • The file you download from the GST portal under GSTR-1 → Prepare Offline → Download. It comes as a .zip file. Open it first and pick the .json file inside.

What you see

  • The GSTIN and return period, with a check that the GSTIN is written correctly.
  • A summary with the value and tax of each table, and the total tax on outward supplies (Tables 4, 5, 7 and 9B). Credit notes are taken away. GSTR-3B takes these figures from your GSTR-1, so this is a quick check before you file it.
  • Each table in rows: B2B invoices (4), B2C large (5), B2C others (7), 0% sales (8), credit and debit notes (9B), HSN summary (12), documents issued (13) and e-commerce sales (14).
  • An Excel file with one sheet for each table.

Exports, advances and amendments are not shown yet. If your file has them, the page says so and leaves them out of the totals. It only reads your file. It never changes it.

To learn what each part of the file means, such as b2b, b2cs or txval, read How to open a GSTR-1 JSON file.

Frequently asked questions

Is my GSTR-1 file uploaded anywhere?

No. Your browser reads the file on your own computer, and makes the Excel file there too. Nothing from the file is sent to us or to anyone else.

How is this different from the GST Offline Tool?

The GST Returns Offline Tool has to be installed on a Windows computer. This page works in any browser, on a Mac or a phone too, and needs no install. It only shows and exports the file. To change the return, use the Offline Tool or the GST portal.

Why is Table 14 not in the total tax?

Table 14 shows how much of your sales went through e-commerce operators like Amazon or Flipkart. Those same sales are already in Table 4, 5 or 7. Adding Table 14 as well would count them twice.

Can I open a GSTR-2B or GSTR-3B JSON here?

No. This page reads GSTR-1 only. GSTR-2B and GSTR-3B files have a different layout. If you open one, the page will say it found no GSTR-1 tables.

My file is big. Will it work?

Files up to 25 MB work. The GST portal splits big returns into several files of about 5 MB each, so open them one at a time. Long tables show their first 300 rows on screen. The Excel file has every row.

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

Related tools