Free GSTR-1 Excel to JSON Converter Online
Upload your Tally, Busy, or ERP-exported GSTR-1 Excel file and get a GST portal-ready JSON file — formatted to the latest V3.2 GSTN specification. Supports all 21 sections including B2B, B2C Large, B2C Small, CDN, Exports, HSN Summary, and Document Summary.
Generate GSTR-1 JSON
Upload your software Excel export and we'll generate a GST portal-compatible JSON file for you
Form Submitted Successfully!
Thank you! Please check your email — we've sent your GSTR-1 JSON file.
How to Convert GSTR-1 Excel to JSON Using This Tool
Converting your GSTR-1 Excel file to a GST portal-compatible JSON file is a 4-step process. No software installation required — unlike the GST Offline Utility Tool, this works directly in your browser.
Export Your GSTR-1 Data as Excel
Open your accounting software and export your GSTR-1 report as an Excel file (.xlsx or .xls).
In Tally Prime: Gateway of Tally → Display More Reports → GST Reports → GSTR-1 → Export as Excel. In Busy: Reports → GST Reports → GSTR-1 → Export to Excel. In ERP Group: Reports → GST Reports → GSTR-1 → Click "Export as Excel."Make sure your export covers the full filing period and includes all required sheets: b2b, sez, de, b2ba, b2cl, b2cla, b2cs, b2csa, cdnr, cdnra, cdnur, cdnura, exp, at, exemp, hsn(b2b), hsn(b2c), and docs.
Upload Your Excel File
Drag and drop your GSTR-1 Excel file into the upload area above, or click to browse. The tool accepts both .xlsx and .xls formats. Maximum file size: 10 MB.
Select Sections & Filing Options
Choose which GSTR-1 sections to include in your JSON output. By default, the most common sections — B2B/SEZ/DE, B2C Large, B2C Small, CDN Registered, CDN Unregistered, Exports, Exempted/Nil/Non-GST, HSN Summary, and Document Summary — are pre-selected.
Select your Return Type (Monthly or Quarterly under QRMP) and Filing Type (Original or Revised).
Generate & Download Your JSON
Click "Generate GSTR-1 JSON." The tool validates your data, maps each Excel sheet to the corresponding GSTN JSON schema (V3.2 format), and generates a portal-ready JSON file delivered to your email within 60 seconds.
Upload this JSON file directly to the GST portal at gst.gov.in → Returns → GSTR-1 → Prepare Offline → Upload.
Export From Any Accounting Software — We Handle the Rest
Upload your GSTR-1 Excel export from Tally, Busy, Marg, or any ERP — our converter reads all standard sheet formats and generates portal-ready JSON.
Why Use ERP Group's GSTR-1 Converter Instead of the GST Offline Tool?
The GST Offline Utility Tool provided by GSTN is the official government tool for converting GSTR-1 Excel files to JSON. It works — but it has significant limitations that waste time for CAs, accountants, and business owners filing GST returns every month.
| Feature | GST Offline Tool | ERP Group |
|---|---|---|
|
Installation required
Download, install, keep updated
|
Yes (Windows) | No — browser |
|
The GST Offline Utility must be downloaded, installed on Windows, and updated every time GSTN releases a new version. If you are using an outdated version, your JSON file may be rejected by the portal. ERP Group's converter runs in the cloud — no installation, no version management, always updated to the latest V3.2 specification.
|
||
|
Auto-updates to latest GSTN format
V3.2 schema changes
|
Manual | Always current |
|
Every GSTN schema update requires you to manually download and install a new version of the Offline Tool. Miss an update and your JSON may be silently rejected. ERP Group always runs the latest V3.2 specification — nothing to check, nothing to download.
|
||
|
Handles 1,000+ invoice files
Large monthly filing volumes
|
Crashes | Stable |
|
Businesses with 500+ invoices per month regularly experience crashes, freezes, and memory errors with the GST Offline Tool. The ERP Group converter handles files with thousands of invoices without performance issues.
|
||
|
Error reporting
Finding & fixing file issues
|
Generic codes | Row-level |
|
When the Offline Tool encounters a formatting error in your Excel file — a missing GSTIN, an incorrect HSN code, or a tax amount mismatch — it displays a generic error code with no explanation. The ERP Group converter identifies the exact row, column, and issue, so you can fix it and re-upload.
|
||
|
Works on Mac / Linux / Mobile
Cross-platform access
|
||
|
The GST Offline Utility Tool runs only on Windows. If you use a MacBook or Linux machine, you cannot use the official tool at all. ERP Group's converter works on any device with a browser — Windows, Mac, Linux, Android, or iPad.
|
||
|
Cost
|
Free | Free |
|
Supports QRMP quarterly filing
|
||
|
V3.2 GSTN schema
|
If updated | Always |
All 21 GSTR-1 Sections Supported
This tool converts every section of the GSTR-1 return. Here is what each section contains and when it applies to your business.
B2B Invoices
Sec 4A, 4B, 4C, 6B, 6CAll invoices issued to registered buyers (businesses with a GSTIN). This is the most common section for B2B traders, manufacturers, and distributors. Includes taxable value, CGST, SGST, IGST, and cess breakdowns.
B2B Amended
Sec 4A, 4B AmendmentsCorrections to B2B invoices reported in earlier filing periods. Use this when you need to amend invoice numbers, dates, GSTIN, or tax amounts already filed in previous months.
B2C Large
Sec 5A, 5BInter-state invoices to unregistered buyers where the invoice value exceeds ₹2.5 lakh. Applicable to businesses selling high-value goods or services across state borders to end consumers.
B2C Large Amended
Sec 5A AmendmentsCorrections to B2C Large invoices reported in earlier filing periods.
B2C Small
Sec 7All other sales to unregistered buyers — both intra-state and inter-state invoices below ₹2.5 lakh. Reported as a consolidated state-wise summary, not invoice-by-invoice.
B2C Small Amended
Sec 7 AmendmentsB2C Small supplies reported in earlier filing periods.
Credit/Debit Notes — Registered
Sec 9BCredit notes and debit notes issued to registered buyers. Includes the original invoice reference, reason for the note, and adjusted tax amounts.
Credit/Debit Notes — Unregistered
Sec 9CCredit notes and debit notes issued to unregistered buyers. Reported with state-wise consolidation similar to B2C Small.
Exports
Sec 6AAll export invoices — with payment of IGST or under Letter of Undertaking (LUT)/bond. Includes shipping bill number, port code, and export type.
Advance Tax Received
Sec 11A(1), 11A(2)Advance payments received for which an invoice has not yet been issued. GST must be paid on advances received in the month they are received.
Advance Adjustment
Sec 11B(1), 11B(2)Adjustment of GST paid on advances against invoices issued in the current or subsequent periods.
Exempted / Nil / Non-GST
Sec 8A, 8B, 8C, 8DSupplies that are exempt from GST, nil-rated, or non-GST supplies. Reported as inter-state and intra-state consolidated values.
HSN Summary
Sec 12Summary of outward supplies by HSN code. Mandatory for businesses with turnover above ₹5 crore (6-digit HSN). Businesses with turnover between ₹1.5 crore and ₹5 crore must report 4-digit HSN codes.
Document Summary
Sec 13Summary of all documents issued during the period — invoices, credit notes, debit notes, delivery challans, and revised invoices. Includes serial number ranges and cancellation details.
B2B Invoices
Sec 4A, 4B, 4C, 6B, 6CAll invoices issued to registered buyers. Includes taxable value, CGST, SGST, IGST, and cess breakdowns.
B2C Large
Sec 5A, 5BInter-state invoices to unregistered buyers where invoice value exceeds ₹2.5 lakh.
B2C Small
Sec 7All other sales to unregistered buyers — consolidated state-wise summary.
Exports
Sec 6AAll export invoices — with IGST or under LUT/bond. Includes shipping bill and port code.
Exempted / Nil / Non-GST
Sec 8A, 8B, 8C, 8DExempt, nil-rated, or non-GST supplies. Inter-state and intra-state consolidated.
CDN — Registered
Sec 9BCredit/debit notes to registered buyers. Includes original invoice reference and adjusted tax.
CDN — Unregistered
Sec 9CCredit/debit notes to unregistered buyers. State-wise consolidation similar to B2C Small.
Advance Tax Received
Sec 11A(1), 11A(2)Advance payments received — GST must be paid in the month received.
Advance Adjustment
Sec 11B(1), 11B(2)Adjustment of advance GST against invoices issued in current/subsequent periods.
HSN Summary
Sec 12Summary by HSN code. 6-digit mandatory above ₹5 crore turnover.
Document Summary
Sec 13All documents issued — invoices, credit/debit notes, challans. Serial ranges and cancellations.
Who Uses This GSTR-1 Excel to JSON Converter?
Trusted by thousands of accountants and CA firms across India — 100+ files processed every day.
CA Firms Managing Multiple Clients
Chartered Accountants and tax practitioners managing 50–200 clients need to convert GSTR-1 Excel exports from each client's accounting software into JSON files for portal upload. With this converter, a CA can process a client's full-year GSTR-1 in one upload.
FMCG & Pharma Distributors
Distributors issuing 500–5,000+ invoices per month generate massive GSTR-1 Excel files. The GST Offline Tool frequently crashes on files this large. This converter handles high-volume files reliably and maps every invoice correctly to B2B, B2C, CDN, and HSN sections.
Small Business Owners
Business owners who manage their own GST filing using Tally or Excel spreadsheets need a quick way to convert their data into the JSON format the GST portal requires. This tool eliminates the need to install the GST Offline Utility and works from any device — including a mobile phone.
Multi-Branch Businesses
Companies with multiple GSTINs across states need to generate separate GSTR-1 JSON files for each branch. This converter processes each GSTIN individually and ensures the JSON output matches the exact GSTIN and filing period selected.
Typical workflow: Client emails Tally GSTR-1 Excel → CA uploads to converter → Reviews summary → Downloads JSON → Uploads to GST portal → Files GSTR-1.
Frequently Asked Questions
Everything about converting GSTR-1 Excel files to JSON for the GST portal.
Tired of Manual GSTR-1 Filing Every Month?
This free converter solves one step of your GST compliance workflow — converting Excel to JSON. But if you are still exporting from Tally, manually checking HSN codes, and uploading JSON files to the portal every month, you are spending 2–3 days on a process that should take 10 minutes.
5,000+ businesses across India have eliminated manual GST filing with ERP Group.