Back to Tools Open GSTR 1 JSON → Excel
GSTR 2B Bank Statement Sales / Purchase Job Work + TDS GSTR 1 JSON GST2B Recon
GSTR 1 TOOL GUIDE

GSTR 1 JSON / ZIP → Excel Converter

Easily convert your official GSTR-1 JSON or ZIP download from the GST Portal into a clean, structured multi-sheet Excel workbook with B2B, HSN, and Document Issue summaries.

Input: .json / .zip Output: Multi-sheet .xlsx No unzipping needed

Step 1: Download GSTR-1 from GST Portal

  1. Log in to the official GST Portal (gst.gov.in).
  2. Navigate to Return Dashboard and select the Financial Year and Return Period (Month/Quarter).
  3. Under Details of outward supplies of goods or services (GSTR-1), click Download.
  4. Click Generate JSON File to Download. Once generated, click the link to download the .zip file.

Step 2: Convert using VinTax

  1. Open the GSTR 1 JSON → Excel tool on VinTax.
  2. Drag and drop your downloaded .zip file (or extracted .json file) into the upload box.
  3. Click the green Convert GSTR 1 to Excel button.
  4. The file is processed instantly on the server and your formatted .xlsx workbook downloads automatically.

Generated Excel Sheets Overview

Sheet Name Contents & Fields Primary Use
Meta Return Period, GSTIN, Legal Trade Name, Gross Turnover Filing verification & taxpayer identification
B2B Receiver GSTIN, Invoice No., Date, Value, POS, Reverse Charge, Tax Rate %, Taxable Value, IGST, CGST, SGST, Cess Sales register reconciliation with Books / Tally
B2BA Original & Amended invoice numbers, revised dates, differential tax amounts Tracking amendments made to prior invoices
HSN HSN / SAC Code, Description, UQC (Unit), Total Qty, Total Value, Taxable, Tax breakdown Table 12 HSN summary checking & audit compliance
Doc_Issue Doc type (Invoices, Credit Notes, Debit Notes), From-To serial range, Total issued, Cancelled Table 13 document register reconciliation

Tips & Best Practices

Direct ZIP Upload: You do not need to extract the ZIP file manually. VinTax automatically unpacks the archive in memory, finds the JSON file, and parses it safely.
Numeric Precision: All amounts (taxable, IGST, CGST, SGST) are rounded to 2 decimal places and formatted as true Excel numbers, so formulas like SUM() work immediately.
Launch GSTR 1 JSON → Excel Now