GSTR-3B JSON to Excel Converter
Convert GSTR-3B summary JSON to structured Excel — free, browser-only
Upload a GSTR-3B JSON from GSTN and get a clean Excel showing outward supply totals, ITC available, exempt/nil/non-GST supplies, and tax payment details. Or upload Excel to reconstruct JSON.
3B filing wasting your finance team’s week?
We auto-prep 3B from your books, validate liability, and file before the 20th. ₹999/mo flat.
What is a GSTR-3B JSON to Excel Converter?
GSTR-3B is the monthly self-declared summary return every GST-registered business files with GSTN. Unlike GSTR-1/2 which capture invoice-level data, GSTR-3B is a summary: outward taxable supplies (Table 3.1), inter-state supplies (3.2), eligible ITC (Table 4), inward exempt/nil/non-GST supplies (Table 5), and tax paid (Table 6). The JSON for this return is structured as summary objects, not invoice lists.
This converter handles the GSTR-3B-specific schema correctly — it does not try to process it as an invoice list. Each summary table becomes its own Excel sheet: sec_3_1 (outward), inter_sup (inter-state), itc_elg (ITC), inward_sup (exempt), intr_ltfee (interest/late fee), and tx_pmt (tax payment). This makes it easy to verify summary figures before submission.
All conversion runs in your browser. GSTN data including your GSTIN, taxable values, and ITC figures never leave your device.
Why use this GSTR-3B JSON to Excel Converter
Built for Indians, by Indians. Every number, every formula, every slab — tuned to FY 2026-27 reality.
Summary-table Excel
Each GSTR-3B table (3.1, 3.2, 4, 5, 5.1, 6.1) becomes a separate Excel sheet with labelled columns.
Bidirectional
Convert JSON to Excel for review, or upload the Excel back to get a reconstructed GSTR-3B JSON.
3B-aware schema
Correctly handles GSTR-3B's summary structure — no invoice flattening applied. Summary values are preserved as-is.
Private by design
All processing in your browser. No server, no upload, no account required.
Using the GSTR-3B JSON to Excel Converter in 4 steps
No onboarding, no signup. Answer three fields and the numbers update live.
Upload GSTR-3B JSON or Excel
Drag or browse for a .json (GSTN format) or .xlsx (previously converted). XLSM files from the GSTN offline utility are also accepted.
Parse and inspect sections
Click "Parse files". Section pills appear — 3.1, ITC, Tax Payment etc. Click each to preview the summary values.
Verify totals
Cross-check the outward supply totals in Table 3.1 against your GSTR-1 figures, and the ITC in Table 4 against your GSTR-2A/2B.
Download
Download all tables as a multi-sheet Excel, or download the reconstructed JSON for your records.
Tips to get the most out of it
Always reconcile Table 3.1 (outward supplies) in 3B against the total output in GSTR-1 before filing — divergences create GSTN mismatch notices.
Table 4 ITC in 3B should match the ITC visible in GSTR-2B for the same period. Use the GSTR-2B Reconciliation tool on this site to verify before entering values.
Interest and late fee (Table 5.1) is auto-computed by GSTN — use the Excel output to verify the calculation matches your own records before paying.
For Table 6.1 (tax payment), check that cash and ITC utilisation totals match the ledger balances in your GST portal. Excess ITC utilisation in 3B beyond what is available triggers demand notices.
Keep the Excel output for each period as a record. Name files by GSTIN and period: 29ABCDE-3B-032026.xlsx.
Real-world scenarios
How Indians actually use this converter — concrete inputs, concrete outcomes.
Pre-filing verification by CA
CA uploads client's GSTR-3B JSON, downloads the Excel, checks Table 3.1 total taxable value against GSTR-1 report from the ERP. Finds a ₹50,000 discrepancy — traces to one invoice missed in the 3B draft.
ITC claim validation
Finance manager uses 3B converter to extract Table 4 ITC values, compares against auto-populated GSTR-2B figure for the same month. Confirms claim is within eligible limit before filing.
Multi-period comparison
Accounts team downloads 3B Excels for 12 months, merges the Table 3.1 sheets in Excel to build a monthly outward supply trend chart for management review.
Frequently Asked Questions
Still have a question? Our team replies within a business day.
GSTR-1 and GSTR-2 capture invoice-level data in nested arrays. GSTR-3B is a summary return — it has aggregate figures in named objects per table (3.1, 4, 6.1 etc.) rather than invoice lists. This converter handles both shapes correctly.
sup_details (Table 3.1), inter_sup (3.2), itc_elg (Table 4), inward_sup (Table 5), intr_ltfee (Table 5.1), tx_pmt (Table 6.1). All standard GSTR-3B summary tables.
You can edit the Excel and download the reconstructed JSON, but this is for review purposes only. Direct portal filing requires the GSTN offline utility or a certified ERP integration.
Yes. The .xlsm format (macro-enabled Excel) from the GSTN offline tool is accepted and parsed the same as .xlsx.
The 3B converter helps you compile monthly summaries to prepare GSTR-9 figures. Export all 12 months, merge in Excel, and use the totals to fill GSTR-9 tables.
Yes. All conversion happens in your browser using JavaScript. No GSTN data — your GSTIN, tax values, ITC figures — is sent to any server.
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