GSTR-2B JSON to Excel Free Converter - Download & Use Guide 2026

What is GSTR-2B and Why Convert to Excel?

GSTR-2B is an auto-generated statement available to registered taxpayers on the GST portal. It contains details of all inward supplies (purchases) and the Input Tax Credit (ITC) available for a tax period. Unlike GSTR-2A, GSTR-2B is static and doesn’t change after generation.

Converting GSTR-2B JSON files to Excel format allows you to:

Reconcile purchases with your purchase register
Validate ITC claims before filing GSTR-3B
Identify discrepancies between supplier filings and your records
Share data with accountants and auditors
Create reports and analysis using Excel formulas

Why Use a Free GSTR-2B JSON to Excel Converter?

Manual processing of GSTR-2B JSON files is impractical for several reasons:

Complex structure - Nested data with multiple sections (B2B, CDN, ISD, IMPG)
Large file sizes - Thousands of invoices make manual extraction impossible
Time-consuming - Hours of work vs. seconds with automated tools
Error-prone - Manual data entry leads to mistakes

Our free GSTR-2B to Excel converter solves all these issues by processing files instantly in your browser.

How to Convert GSTR-2B JSON to Excel Free

Step 1: Download GSTR-2B JSON from GST Portal

Login to the GST Portal (gst.gov.in)
Navigate to Returns Dashboard → Returns → GSTR-2B
Select the tax period (month/quarter)
Click on Download JSON button
Save the file to your computer

The downloaded file will be named something like GSTR2B_29AABCT1332L000_032024.json.

Step 2: Upload to Free Converter

Visit our GSTR-2B JSON to Excel converter
Click “Upload GST JSON File” or drag and drop your file
Tool automatically detects GSTR-2B format
Processing starts immediately (takes 2-10 seconds)

Step 3: Review Extracted Data

The converter displays a summary showing:

Total purchase invoices
Total ITC available (IGST + CGST + SGST)
Taxable value
Number of suppliers

Step 4: Download Excel File

Click “Download Excel” to get your formatted spreadsheet with:

B2B Sheet - All purchase invoices with GSTIN, invoice details, items, tax amounts
CDN Sheet - Credit and debit notes
ISD Sheet - Input Service Distributor invoices
IMPG Sheet - Import of goods with IGST paid

What Data Gets Extracted from GSTR-2B JSON?

Our free tool extracts all sections of GSTR-2B:

B2B (Business-to-Business Purchases)

Supplier GSTIN and trade name
Invoice number and date
Invoice value and taxable amount
HSN/SAC codes
IGST, CGST, SGST amounts
ITC eligibility status

CDN (Credit/Debit Notes)

Note number and date
Original invoice reference
Note value
Tax adjustments
ITC reversal/reclaim

ISD (Input Service Distributor)

ISD GSTIN
Document number and date
ITC distributed amount
Eligible ITC for the period

IMPG (Import of Goods)

Port code
Bill of entry number and date
Taxable value
IGST paid at import
ITC available

Benefits of Using Our Free GSTR-2B Converter

1. 100% Free - No Hidden Costs

✅ No registration required
✅ No subscription fees
✅ No file limits (up to 50MB)
✅ Unlimited conversions

2. Complete Privacy & Security

Your data never leaves your device:

Processing happens entirely in your browser
No server uploads
No data storage
GDPR compliant

3. Fast & Accurate

Instant processing (2-10 seconds)
Extracts 100% of invoice data
Maintains tax amount accuracy
Preserves all decimal precision

4. User-Friendly Excel Format

Clean column headers
Proper formatting
Filter-ready data
Sum formulas included

GSTR-2B vs GSTR-2A: Which JSON to Convert?

Feature	GSTR-2B	GSTR-2A
Nature	Static statement	Dynamic statement
Changes	No changes after generation	Updates continuously
Filing relevance	Used for GSTR-3B	Only for reference
ITC accuracy	More reliable	May have pending data
JSON availability	Monthly/Quarterly	Real-time

Recommendation: Always use GSTR-2B JSON for ITC claims and filing. Learn more about the difference between GSTR-2A and GSTR-2B.

Common Issues When Converting GSTR-2B JSON

”File Not Recognized” Error

Cause: Uploading GSTR-1 JSON instead of GSTR-2B

Solution: Verify you downloaded GSTR-2B from the correct section on GST portal. GSTR-2B files have a "data" section with "docdata" inside.

”No Invoices Found”

Cause: Empty GSTR-2B (no suppliers filed returns for that period)

Solution: This is normal if you had no purchases or if suppliers haven’t filed. Check a different tax period.

”Invalid JSON Format”

Cause: File corruption or incomplete download

Solution: Re-download from GST portal. Don’t edit the JSON manually.

Large File Takes Time

Cause: Thousands of purchase invoices

Solution: Be patient - our tool can handle files up to 50MB. Processing may take 10-15 seconds for very large files.

How to Use Converted Excel for ITC Reconciliation

Once you have the Excel file:

1. Match with Purchase Register

Compare invoice numbers, dates, and amounts with your purchase records to identify:

Invoices in GSTR-2B but not in your books
Invoices in your books but not in GSTR-2B

2. Verify ITC Eligibility

Check the ITC Eligible column in Excel:

“Y” = ITC can be claimed
“N” = ITC not available
Check rules for ineligible ITC

3. Calculate ITC for GSTR-3B

Use Excel SUM formulas to calculate total ITC:

=SUM(IGST_Column)
=SUM(CGST_Column)
=SUM(SGST_Column)

4. Identify Discrepancies

Look for:

Mismatched GSTIN
Incorrect tax rates
Invoice date vs. filing period mismatch
Duplicate entries

Free vs Paid GSTR-2B Converters: What’s the Difference?

Many paid tools offer similar features, but our free converter provides:

Feature	Our Free Tool	Paid Tools
Cost	Free forever	₹500-₹5000/month
Privacy	100% local processing	Upload to servers
File limits	Up to 50MB	Often 10-20MB
Speed	Instant (browser-based)	Depends on server load
Updates	Always latest	Version dependent

Tips for Working with GSTR-2B Excel Files

Save a backup - Keep the original JSON and Excel files
Use filters - Excel filters help analyze specific suppliers or periods
Pivot tables - Create summary reports by supplier or tax rate
Conditional formatting - Highlight high-value invoices or discrepancies
Cross-reference - Match with GSTR-1 data for complete reconciliation

Frequently Asked Questions

Is this GSTR-2B converter really free?

Yes, completely free with no registration, no trials, and no hidden charges. We believe GST compliance tools should be accessible to all businesses.

How many files can I convert?

Unlimited. Convert as many GSTR-2B JSON files as you need, for any tax period.

Can I convert GSTR-1 files with this tool?

Yes! Our converter automatically detects whether you uploaded GSTR-1, GSTR-2B, or GSTR-2A and processes accordingly.

Will my data be stored or shared?

No. All processing happens in your browser using JavaScript. Your files never leave your computer.

What if I have a very large GSTR-2B file?

Our tool handles files up to 50MB. If your file is larger, contact us for enterprise solutions.

Can I use this on mobile?

Yes, the tool works on mobile browsers, but we recommend desktop for better Excel viewing experience.

Alternative Methods to Convert GSTR-2B JSON

While our free online tool is the easiest option, here are alternatives:

1. Excel Power Query

Excel’s built-in Power Query can import JSON, but requires:

Technical knowledge of JSON structure
Manual mapping of nested data
Time-consuming setup

2. Python Scripts

Developers can write Python scripts using pandas library, but this requires:

Programming skills
Python environment setup
Maintenance for format changes

3. Desktop Software

Some accounting software includes JSON import features, but often:

Limited to specific software
Expensive licenses required
May not extract all fields

Verdict: Our free online converter is the fastest and easiest option for most users.

Conclusion

Converting GSTR-2B JSON to Excel is essential for efficient ITC reconciliation and GST compliance. Our free GSTR-2B to Excel converter provides:

✅ Instant conversion (2-10 seconds)
✅ 100% free with no registration
✅ Complete data extraction (B2B, CDN, ISD, IMPG)
✅ Total privacy (no uploads)
✅ Accurate ITC calculations
✅ User-friendly Excel format

Ready to convert? Upload your GSTR-2B JSON file now →

Related Guides: