JSON to CSV for GST Filing: GSTR-1, GSTR-2A, GSTR-2B

India's GST portal exports return data in JSON format. To view it in Excel or reconcile invoices, you need to convert that JSON to CSV first. The WildandFree JSON to CSV converter handles this entirely in your browser — your GST data is never uploaded to any server.

Here's how to convert GSTR-1, GSTR-2A, and GSTR-2B JSON files to CSV quickly.

Why GST Data Comes as JSON (and Why CSV Is Easier to Work With)

The GST portal and GSTN API return data in JSON because it's a standard data exchange format for APIs. JSON handles the nested, hierarchical structure of GST data well — invoice-level data nesting within supply type, which nests within GSTIN.

The problem: JSON is not human-readable in a spreadsheet. Accountants, CAs, and tax teams need the data in Excel or Google Sheets to reconcile invoices, check ITC claims, and prepare returns. CSV is the bridge between the portal's JSON output and the spreadsheet software your team uses daily.

Converting the JSON locally (in your browser) keeps your GSTIN data, invoice amounts, and vendor information off any third-party server. For sensitive financial data, this matters.

Step by Step: Convert GSTR JSON to CSV

1. Download your JSON from the GST portal — log in, go to your return (GSTR-1, GSTR-2A, or GSTR-2B), and download the data as JSON
2. Open the JSON file — open it in Notepad, VS Code, or any text editor
3. Copy the relevant array — GST JSON files typically have multiple sections. Find the section you need (e.g. b2b for B2B invoices, cdnr for credit notes) and copy the array of objects for that section
4. Paste into the converter — open the JSON to CSV converter and paste the array
5. Download the CSV — click Convert, then Download. The CSV is ready to open in Excel.

For the full return file, you may need to convert each section separately — the B2B invoices, HSN summary, and credit note sections are separate arrays in the JSON. Convert each one to get separate CSVs for each return section.

Sell Custom Apparel — We Handle Printing & Free Shipping

GSTR-2A and GSTR-2B — What the JSON Looks Like

GSTR-2A (auto-populated purchases) and GSTR-2B (ITC statement) JSON files have a similar structure: a top-level object with keys for different supply categories, each containing an array of records.

For invoice reconciliation, extract the b2b section which contains B2B supplier invoices. Each entry in the array includes GSTIN, invoice number, invoice date, taxable value, and tax amounts — exactly what you need for an ITC reconciliation in Excel.

After converting to CSV, common next steps in Excel:

• VLOOKUP or XLOOKUP to match GSTR-2B data against your purchase register
• Pivot tables to summarize ITC by supplier or by tax rate
• Conditional formatting to highlight mismatches between your records and the auto-populated data

Privacy: Why You Should Not Upload GST JSON to Cloud Converters

Your GST JSON files contain GSTIN numbers, vendor GSTINs, invoice amounts, and transaction details. Uploading this to a cloud converter means it passes through a third-party server — potentially stored temporarily or logged for debugging.

The browser converter processes your GST JSON entirely on your device. Nothing is sent to any server. When you close the tab, the data is gone. This is the appropriate handling for financial data under Indian privacy norms and any audit trail considerations.

This is the same reason the existing CSV to JSON for GST filing guide recommends the browser-based approach — any tax data conversion should stay local.

Frequently Asked Questions

Can I convert the full GSTR-1 JSON file at once?

The GSTR-1 JSON has multiple sections (b2b, b2cl, b2cs, cdnr, etc.) each as a separate array. The converter handles one array at a time — paste each section separately to get a CSV for each return section.

Does the tool work for GSTR-2B reconciliation?

Yes. Extract the b2b array from your GSTR-2B JSON, paste it into the converter, and download the CSV. You can then VLOOKUP this against your purchase register in Excel to identify missing or mismatched ITC claims.

Is my GST data safe in the browser converter?

Yes. The tool runs entirely in your browser using local compute. Your GSTIN, vendor details, and invoice amounts are never transmitted to any server. When you close the browser tab, nothing is retained.

What if the GST JSON has deeply nested structures the tool can't flatten?

GST JSON typically has one or two levels of nesting, which the dot notation flattening handles well. If you encounter a section with three or more nesting levels, extract the innermost array first — paste just that nested array rather than the full parent structure.