GSTR-1 Excel Template Format: Upload Tables & Offline Utility Guide
Tired of typing hundreds of invoices manually on the GST portal? Learn how to populate the official GSTR-1 Excel template and upload via the offline utility.
Comprehensive guide to GSTR-1 Excel format template. Learn how to fill B2B, B2C, HSN tables, convert to JSON using the offline utility, and avoid upload errors.
For small retail businesses issuing a few invoices a month, entering sales bills manually one-by-one on the government GST portal is manageable. But once your business scales to hundreds or thousands of B2B bills, credit notes, and multi-state dispatches, manual portal entry becomes an operational nightmare.
A single web session timeout can erase half an hour of tedious typing.
To solve this, the Goods and Services Tax Network (GSTN) provides the official GSTR-1 Excel Template & Offline Utility. By organizing your sales data into structured spreadsheet columns, you can convert thousands of invoices into an uploadable JSON file in seconds.
In this guide, we break down the exact structure of the GSTR-1 Excel format, explain each mandatory sheet, demonstrate how to convert Excel to JSON, and troubleshoot the most frequent upload validation errors.
⚡ Quick Answer (AEO / BLUF): The GSTR-1 Excel template contains dedicated worksheets: b2b (registered business sales), b2cl (large interstate consumer sales > ₹2.5L), b2cs (retail counter sales), and hsn (summary of supplies). Fill invoice numbers, dates, values, and tax rates without changing column headers, then import into the GST Offline Tool to generate your upload JSON.
Overview of the Official GSTR-1 Excel Workbook
The government GSTR-1 Excel template consists of specialized worksheet tabs corresponding to the legal tables of the return:
| Sheet Name | Legal Table in GSTR-1 | Data Captured |
|---|---|---|
| b2b | Table 4A, 4B, 4C, 6B, 6C | Invoices issued to registered taxpayers (having valid 15-digit GSTINs). |
| b2cl | Table 5A, 5B | Large consumer sales: Inter-state B2C invoices where invoice value > ₹2.5 Lakh. |
| b2cs | Table 7 | Small consumer sales: Intra-state sales and inter-state B2C sales under ₹2.5 Lakh (Consolidated by tax rate). |
| cdnr | Table 9B | Credit & Debit Notes issued to registered B2B buyers. |
| cdnur | Table 9B | Credit & Debit Notes issued to unregistered customers for inter-state high-value sales. |
| exp | Table 6A | Export sales (with or without payment of IGST, deemed exports). |
| hsn | Table 12 | Mandatory HSN-wise summary of outward supplies with quantity and tax rates. |
| docs | Table 13 | Summary of document serial numbers issued (Invoices, Challans, Credit Notes). |
Detailed Breakdown of Mandatory Columns in the "B2B" Sheet
The b2b worksheet is where most errors occur. Here is how each column must be populated:
- GSTIN/UIN of Recipient:
The buyer's valid 15-digit GSTIN. Must match government checksum rules (first 2 digits must be a valid state code). - Receiver Name:
Legal or trade name of the customer (optional, but helpful for record-keeping). - Invoice Number:
Consecutive serial number unique for the financial year. Allowed characters: alphanumeric, slash (/), and hyphen (-). Maximum 16 characters! - Invoice Date:
Must be formatted strictly asDD-MMM-YYYY(e.g.15-May-2027). Cannot be a future date! - Invoice Value:
Total gross invoice amount including all taxes (CGST + SGST + IGST + Cess). - Place of Supply (POS):
Must select the recipient's state code from the dropdown (e.g.,27-Maharashtra). This determines whether the transaction attracts CGST/SGST or IGST. - Reverse Charge:
SelectYif the supply attracts reverse charge (rare for standard sales); otherwise, enterN. - Applicable % of Tax Rate:
Standard transactions: leave blank or select default. - Invoice Type:
Choose Regular, SEZ with payment, SEZ without payment, or Deemed Export. - E-Commerce GSTIN:
If sold through Amazon/Flipkart, enter the marketplace operator's GSTIN; otherwise, leave blank. - Rate & Taxable Value:
Select the GST tax slab (e.g., 5%, 12%, 18%, 28%) and enter the pre-tax base amount.
How to Fill the "HSN" Summary (Table 12 Rules)
Since Notification No. 78/2020-Central Tax, reporting HSN codes in Table 12 is strictly enforced:
- Turnover up to ₹5 Crore: Minimum 4-digit HSN code mandatory for all B2B supplies.
- Turnover above ₹5 Crore: Minimum 6-digit HSN code mandatory for all outward supplies.
In the hsn worksheet:
- Enter HSN code;
- Enter short description of goods/services;
- Enter Unit Quantity Code (UQC) from the official dropdown (e.g.,
KGSfor kilograms,NOSfor numbers,MTRfor meters); - Enter Total Quantity, Total Taxable Value, and breakdown of Integrated, Central, and State Tax.
[!WARNING] The total taxable value and tax amounts entered in the hsn sheet must exactly equal the sum of all B2B, B2C, and Export sheets! If there is a mismatch of even ₹1, the portal will reject your JSON upload with an error.
Step-by-Step: Converting Excel to JSON Using the Offline Utility
- Download the Official Offline Tool:
Go to gst.gov.in > Downloads > Offline Tools > Returns Offline Tool. Install the software on your Windows computer. - Open the Utility:
Launch the GST Offline Tool application from your desktop. - Upload Your Filled Excel Workbook:
Under the New section:- Select Return as GSTR1;
- Enter your GSTIN, Financial Year, and Tax Period;
- Click Proceed.
- Import the File:
Click Import Files > Import Excel, browse to your populated GSTR-1 Excel workbook, and click Open. - Review Validation Status:
The tool scans every row. If all cells conform to schema rules, it displays a success message: "Data imported successfully". - Generate JSON File:
Click View Summary, then click Generate File. The tool exports a.jsonfile to your computer. - Upload to the GST Portal:
Log in togst.gov.in > Return Dashboard > GSTR-1 > Prepare Offline. Click Choose File, select the generated JSON file, and submit!
Top 3 Upload Errors & How to Fix Them
1. "Error in Schema / Invalid JSON Format"
- Cause: You modified, deleted, or rearranged columns in the official Excel template.
- Fix: Never touch the header rows! Always download a fresh, unedited template from the portal.
2. "Duplicate Invoice Number Found"
- Cause: Two rows in your B2B sheet share the exact same invoice number for different customers.
- Fix: In Excel, use
Conditional Formatting > Highlight Cells Rules > Duplicate Valueson the Invoice Number column to eliminate duplicates.
3. "Invalid Date Format"
- Cause: Excel converted dates into American format (
MM/DD/YYYY). - Fix: Select the entire date column, right-click, select Format Cells > Custom, and set format as
dd-mmm-yyyy.
Skip the Offline Tool Completely with SuperBiller
Why spend hours copying numbers from your sales software into an Excel sheet, fixing formula errors, and opening the sluggish offline utility?
With SuperBiller POS & Billing Software:
- Generate GST-compliant invoices at your counter with automated HSN lookups;
- When filing day arrives, click Direct GSTR-1 Export;
- SuperBiller instantly generates a 100% error-free JSON file validated against government schema;
- Upload directly to the portal with zero Excel intermediary headaches!
Related In-Depth Guides & Recommended Reading
Expand your tax compliance and store management knowledge with these related guides from our topic cluster:
- How to Download GSTR-1 & GSTR-3B Filed Returns from GST Portal – Essential compliance rules, practical calculations, and step-by-step guidance.
- How to Check Aggregate Annual Turnover in GST Portal Online – Essential compliance rules, practical calculations, and step-by-step guidance.
- GST Reconciliation Format in Excel: Free Download & Matching Guide – Essential compliance rules, practical calculations, and step-by-step guidance.
- How to Check Input Tax Credit (ITC) in GST Portal & GSTR-2B – Essential compliance rules, practical calculations, and step-by-step guidance.
Frequently Asked Questions (FAQ)
Where can I download the official GSTR-1 Excel template?
You can download the template directly from the official portal at gst.gov.in > Downloads > Offline Tools > GSTR-1 Offline Tool. The downloaded ZIP package contains both the executable application and the blank Excel template workbook.
What is the maximum number of invoices the GSTR-1 Excel template can process?
The Excel template can handle up to 19,000 invoice rows across all worksheets. If your business issues more than 19,000 invoices in a month, you must upload your data using multiple CSV files or through a direct GSP API integration like SuperBiller.
Can I rename the sheet tabs in the GSTR-1 Excel workbook?
No! The offline utility relies on exact worksheet names (b2b, b2cl, b2cs, hsn, etc.). If you rename or delete any sheet tab, the tool will throw a fatal parsing error and fail to read the file.
How are B2C sales below ₹2.5 Lakh reported in the Excel format?
Small B2C sales are not entered invoice-by-invoice. In the b2cs sheet, you enter consolidated totals grouped by State Code (Place of Supply) and applicable GST Tax Rate.
What should I enter in Place of Supply (POS) for local intra-state sales?
For sales within your own state, select your home state code from the dropdown. The system will automatically calculate Central Tax (CGST) and State Tax (SGST) in equal halves.
Can I upload multiple JSON files for the same GSTR-1 return?
Yes. If you upload a second JSON file containing new invoices, the portal will append them to your existing draft return. However, if an invoice number in the new file already exists on the portal, it will overwrite the previous record with the new values.
Regulatory References & Official Software Standards
For business accounting mandates, digital security standards, and statutory audit compliance, refer to the following official resources:
- Ministry of Corporate Affairs (MCA):
- MCA Company Law & Audit Trail Mandate — Statutory requirements for accounting software with un-editable audit logs
- Indian Computer Emergency Response Team (CERT-In):
- CERT-In Cybersecurity Guidelines — Best practices for enterprise data protection, ransomware prevention, and software integrity
- Ministry of Electronics and Information Technology (MeitY):
- Information Technology Act, 2000 Provisions — Legal implications of unlicensed/cracked software and data privacy compliance
- GST Common Portal (GSTN):
- GST Portal Technical Architecture — Official standards for GST invoicing, GSTR-1 JSON schema, and API integrations
- Ministry of MSME:
- Digital MSME Scheme — Cloud software adoption and digital business transformation guidelines
This guide is authored by the SuperBiller Tax & Retail Operations Desk and fact-checked against official Central Board of Indirect Taxes and Customs (CBIC) circulars, the CGST Act 2017 (Rule 46 & Section 31), and latest GST Council threshold updates. SuperBiller provides MSMEs with compliant billing technology, 80mm thermal printing, and automated tax workflows.
Ready to automate your GST Billing & 80mm POS?
Generate your first tax invoice in under 30 seconds. 100% offline-ready.