GSTR-1 JSON to Excel Converter
Turn your GSTR-1 JSON into a clean, multi-sheet Excel file — one sheet per section (B2B, B2CL, B2CS, HSN, documents issued, table 14) — free and instant.
The JSON your accounting software or the GST portal produces is built for machines, not for review — a wall of nested brackets is not something you can scan for a mistake before filing. Converting it to Excel puts every section (outward supplies to registered persons, large invoices, consumer sales, HSN summary, the serial ranges of documents issued) into its own readable sheet, so you can actually check the numbers, sort by state or rate, or hand it to an accountant who does not want to read raw JSON.
How it works: the converter reads whichever sections your specific file actually contains — it does not assume every GSTR-1 has every table filled in — and builds one sheet per section it finds, named to match.
Frequently Asked Questions
Which GSTR-1 JSON sections does this convert?
Every section present in your file — B2B, B2CL, B2CS, CDNR, HSN summary, documents issued, and supplies through e-commerce operators (table 14) — each becomes its own Excel sheet, named after the section. Sections your file does not contain are simply skipped rather than shown empty.
Is my GSTR-1 JSON uploaded to a server?
No. The file is read and converted entirely inside your browser using JavaScript. It is never transmitted anywhere, which matters given this file contains your GSTIN and sales data.
Can I upload a ZIP file instead of the raw JSON?
Yes. If you upload a .zip, the first .json file found inside it is read automatically — you do not need to extract it yourself first.
Does this work for JSON exported from any GST software, not just the government portal?
Yes. The converter reads whatever section names and fields are actually present in your file rather than assuming one fixed schema, so JSON exported from the GST offline tool, the portal itself, or third-party GST software all convert correctly.
Will nested or complex fields be lost in the Excel output?
No field is dropped. Simple values become their own column; where a field itself contains a nested object or list (uncommon in GSTR-1 JSON but not impossible), that cell shows its raw content as text rather than being silently discarded.