GSTR-1 JSON to Excel Converter
Convert GSTR-1 JSON to multi-sheet Excel — free, browser-only
Upload a GSTN GSTR-1 JSON file and download a structured multi-sheet Excel, or upload the Excel back to recreate the JSON. Every section (b2b, cdnr, cdnur, exp, hsn, docs) becomes its own sheet.
Doing this every month? Automate it.
Our compliance team handles GSTR-1 prep, validation, and filing for ₹999/mo. Switch in a day.
What is a GSTR-1 JSON to Excel Converter?
GSTR-1 is the monthly or quarterly outward supply return every GST-registered business must file with GSTN. The portal exports data in a nested JSON format that is hard to read in Excel — and many ERPs produce flat Excel files that need to be converted to JSON before uploading. Switching formats manually is error-prone and time-consuming.
This free converter handles the full GSTR-1 schema: B2B invoices, B2C large/small, credit/debit notes (registered and unregistered), exports, advances, HSN summary, and documents issued. JSON is flattened into one Excel sheet per section; upload that Excel back and get a reconstructed JSON skeleton ready for portal upload.
Everything runs in your browser using JavaScript. Your GSTN data — GST numbers, invoice amounts, dates — never leaves your device. Refresh the tab and it's gone.
Why use this GSTR-1 JSON to Excel Converter
Built for Indians, by Indians. Every number, every formula, every slab — tuned to FY 2026-27 reality.
Multi-sheet Excel output
Every GSTR-1 section (b2b, cdnr, exp, hsn, docs…) becomes a separate sheet in one .xlsx file — easy to navigate in Excel.
Bidirectional conversion
JSON → Excel and Excel → JSON. Upload the downloaded Excel back to get a reconstructed GSTN-compatible JSON.
Supplier-grouped rows
GSTN nests B2B invoices by supplier GSTIN. The converter flattens these into individual rows so each invoice has its own line.
Section filter + search
Switch between sections with one click. Filter rows by any field — GSTIN, invoice number, amount, date.
100% private
All parsing and file generation runs locally in your browser. No upload, no server, no sign-in.
Load sample
Click "Load sample" to try the converter with a realistic GSTR-1 JSON before uploading your own data.
Using the GSTR-1 JSON to Excel Converter in 4 steps
No onboarding, no signup. Answer three fields and the numbers update live.
Upload your GSTR-1 file
Drag and drop or click to browse. Accepts .json (GSTN format) or .xlsx (previously converted). Up to 15 MB.
Click "Parse files"
The converter reads the file, identifies sections, and displays a row count per section. Click any section pill to preview its rows.
Review the data
Use the section selector and filter box to check specific invoices. Look for any rows with blank critical fields.
Download
Click "Download Excel (all sections)" for a multi-sheet .xlsx, "Download JSON" to get a GSTN-compatible JSON, or "Download CSV" for the active section only.
Tips to get the most out of it
Always download and check the Excel before uploading JSON back to the portal — manual edits in Excel can introduce stray spaces or date format changes that break GSTN validation.
GSTR-1 JSON from GSTN uses nested structures (supplier GSTIN → invoice list). This converter flattens them into rows. When converting Excel back to JSON the nesting is not re-applied — use the output as a review document, not a direct portal upload.
Filter the b2b section by your top 10 suppliers by value to spot missing invoices quickly. Sort by txval descending in Excel after downloading.
For HSN summary rows, verify that the total taxable value in the HSN sheet matches the sum of invoice-level values. Discrepancies here trigger GSTN mismatch notices.
Keep the downloaded Excel as an audit trail for each filing period. Name files with the GSTIN and return period, e.g., 29ABCDE-GSTR1-032026.xlsx.
Real-world scenarios
How Indians actually use this converter — concrete inputs, concrete outcomes.
CA reviewing client GSTR-1 before filing
CA downloads client's GSTR-1 JSON from the ERP. Uploads to converter, opens Excel, finds two B2B invoices where CGST+SGST don't add up to the tax rate applied. Corrects in ERP before portal upload.
Cross-checking outward supply totals
Finance manager converts GSTR-1 JSON to Excel, uses Excel pivot on the b2b sheet to total taxable value and GST by rate slab. Compares against internal sales ledger to catch any missing invoices.
Converting ERP export to GSTN format review
ERP exports GSTR-1 as a flat Excel. Team uploads to converter, reviews b2b and cdnr sections side-by-side, spots a credit note where supplier GSTIN was missing, corrects before filing.
Frequently Asked Questions
Still have a question? Our team replies within a business day.
The JSON download is a reconstructed skeleton useful for review, not a certified portal-upload file. For direct portal upload use the GSTN offline utility or your ERP's certified integration.
b2b, b2ba, b2cl, b2cla, b2cs, b2csa, cdnr, cdnra, cdnur, cdnura, exp, expa, at, ata, txpd, txpda, nil, hsn, docs. All standard GSTN invoice-list sections.
GSTN JSON nests invoices under the supplier GSTIN. The converter flattens this so each row has a ctin column with the supplier's GSTIN alongside the invoice fields.
Yes. Upload multiple GSTR-1 JSON files and they are merged section-by-section before display. Useful if your ERP splits large returns across multiple files.
No hard limit. The browser handles parsing. Very large returns (50,000+ rows) may take a few seconds but will complete. The 15 MB file-size cap is the only constraint.
No. All processing is in-browser JavaScript. Nothing is sent to any server. Close the tab and the data is gone entirely.
Want expert help beyond the converter? Talk to our team.
Our finance team helps Indian businesses and individuals plan investments, file taxes, and build wealth — without the jargon.
Book a free consultationLet's talk about your business.
Tell us what you're working on and where you want to go. We'll put together a plan. No obligation, no sales pitch.
- Free 30-minute call
- A plan built around your goals
- No obligation, no pressure
- Your own account manager