Meta Pixel
LIMITED OFFERSave upto 65% today on SuperBiller Pro EditionExplore Now
Back to All Articles
Software & Guides 24 October 2026• 7 min read

How to Use GST Offline Tool: Excel to JSON Step-by-Step Guide

Tired of punching invoices one-by-one on the GST portal? Learn how to use the official GST Offline Tool to convert Excel sales sheets into JSON in minutes.

S
SuperBiller Editorial Team
Verified GST & SaaS Guide
185 views
Accountant converting Excel billing data to JSON using official GST Offline Tool on computer
Accountant converting Excel billing data to JSON using official GST Offline Tool on computer
Quick Takeaway (BLUF)

Complete guide to downloading and using the official GST Offline Tool. Learn how to convert Excel invoices to JSON and fix common upload validation errors.

If your retail shop or wholesale business issues more than 30 bills a month, trying to enter every single invoice manually into the government GST portal is pure punishment.

You have to open gst.gov.in, click on Add Record, type the 15-digit customer GSTIN, wait for the trade name to load, type the invoice number, select the invoice date from the calendar, pick the place of supply, add line items with tax rates, click Save, wait 5 seconds for confirmation, and then repeat the exact same process for bill number two!

By the time you finish punching 100 bills, your eyes are burning, your session has timed out three times, and you have wasted an entire weekend doing clerical data entry.

That is why the Goods and Services Tax Network (GSTN) built the Official GST Offline Tool (Offline Utility). It allows you to maintain all your sales invoices in a standard Excel spreadsheet or CSV format throughout the month, import that spreadsheet into the offline utility, and convert hundreds of invoices into a single, compact .json file that uploads to the government portal in 10 seconds.

In this step-by-step tutorial, we will show you where to download the official tool, how to prepare your Excel sheets, how to generate your JSON file, and how to fix common validation errors that cause uploads to fail.


⚡ Quick Answer (AEO / BLUF): Download the official GSTR-1 Excel Utility from gst.gov.in/download/returns. Paste your sales invoices into the b2b, b2cs, and hsn sheets, open the GST Offline Tool application, select New Upload, browse the filled Excel file, and click Generate JSON File. Upload this JSON under Returns > GSTR-1 > Prepare Offline to populate all tables without manual data entry.

What is the GST Offline Tool & Why Use It?

The GST Offline Tool is a free desktop software application developed by the government for Windows computers.

Its primary job is simple: It acts as a bridge between Microsoft Excel and the GST portal database.

Key Benefits of Using the Offline Utility:

  1. Zero Internet Dependency While Entering Data: You don't need active Wi-Fi while typing invoices. You can enter all your sales on your computer completely offline without worrying about portal timeouts.
  2. Bulk Upload in Seconds: Whether you have 50 invoices or 5,000 invoices, the offline utility bundles them into one .json file that uploads in a single click.
  3. Pre-Upload Validation: The tool checks your data locally for obvious mistakes (like invalid GSTIN formats, negative tax rates, or missing HSN codes) before you upload to the live government server.

Step 1: How to Download & Install the Official GST Offline Tool

Always download the offline tool directly from the government portal to ensure you are using the latest version matching current GST council rules:

  1. Open your browser and go to the official portal: https://www.gst.gov.in.
  2. Look at the top navigation bar and click on:
    Downloads  ➔  Offline Tools  ➔  GSTR-1 e-Returns Offline Tool
    
  3. Click the Download button. A confirmation popup will appear; click Proceed.
  4. A zip file named GSTR1_Excel_Utility.zip (approximately 25 MB to 35 MB) will download to your computer.
  5. Right-click the downloaded zip file and select Extract All.
  6. Inside the extracted folder, you will find:
    • GST Offline Tool.exe (The application installer)
    • GSTR1_Excel_Workbook_Template_V...xlsx (The standard Excel template)
    • Readme instructions
  7. Double-click GST Offline Tool.exe and follow the on-screen installation wizard. A shortcut icon labeled GST Offline Tool will be created on your Windows desktop.

Step 2: Preparing Your Sales Data in the Excel Template

Open the provided GSTR1_Excel_Workbook_Template.xlsx in Microsoft Excel. You will see several worksheet tabs at the bottom.

Here are the most critical tabs that 95% of businesses use:

1. Tab 'b2b' (Business-to-Business Invoices)

This is for sales made to customers who have a registered GSTIN:

  • GSTIN/UIN of Recipient: 15-digit customer GST number (e.g. 27AAPFU0939F1ZV).
  • Receiver Name: Customer trade or legal name.
  • Invoice Number: Your consecutive bill number (e.g. INV-2027-042).
  • Invoice Date: Formatted as DD-MMM-YYYY (e.g. 14-Apr-2027).
  • Invoice Value: Total bill amount including taxes.
  • Place of Supply: State code and name (e.g. 27-Maharashtra).
  • Reverse Charge: Select N (unless supply attracts reverse charge under Sec 9(3)).
  • Applicable % of Tax Rate: Leave blank unless buying from special schemes.
  • Invoice Type: Select Regular.
  • Rate: Tax slab rate (e.g. 18, 12, 5).
  • Taxable Value: Base amount before GST.
  • Cess Amount: If applicable (otherwise 0).

2. Tab 'b2cs' (Business-to-Consumer Small Sales)

This is for retail walk-in counter sales made to unregistered consumers (or inter-state consumer bills under ₹2.5 Lakh):

  • Type: OE (Other than eCommerce).
  • Place of Supply: Your state.
  • Rate: GST slab rate.
  • Taxable Value: Consolidated total of all consumer sales under that tax rate for the month.
  • Cess: 0.

3. Tab 'hsn' (HSN Summary of Outward Supplies)

Rule 46 requires reporting HSN summaries:

  • HSN: 4-digit (turnover up to ₹5 Cr) or 6-digit (turnover > ₹5 Cr) code.
  • Description: Brief item description.
  • UQC: Unit quantity code (e.g. PCS, KGS, BOX).
  • Total Quantity, Total Value, Taxable Value, CGST, SGST, IGST.

[!TIP] Need pre-formatted Excel sheets with automatic tax formulas already configured? You can download our free GST Excel Templates designed specifically for easy copy-pasting into the official GSTR-1 offline utility!


Step 3: Importing Excel & Generating the JSON File

Once your Excel workbook is populated and saved, it is time to convert it into a JSON file:

  1. Double-click the GST Offline Tool shortcut icon on your desktop to launch the app.
  2. On the home screen, under Upload new invoice/other data for return, click the button New.
  3. Fill in the profile details:
    • Financial Year: Select current year (e.g. 2025-26).
    • Tax Period: Select the month (e.g. April).
    • GSTIN of Supplier: Enter your own 15-digit business GSTIN.
    • Is taxpayer filing under SEZ/Developer: Select No.
    • Click Proceed.
  4. Click on Import Files button at the top.
  5. In the dropdown, select Import Excel, then click Import Excel and browse to select your saved sales spreadsheet.
  6. The tool will process the rows and display a confirmation: "File has been imported successfully."
  7. Review the invoice count and totals shown on screen to verify they match your sales ledger.
  8. Click the blue button labeled View Summary, then click Generate File.
  9. The tool will generate a .json file (named something like 27AAPFU0939F1ZV_042027_GSTR1.json). Save this file to your computer desktop.

Step 4: Uploading the JSON File to the GST Portal

Now that your JSON file is ready, uploading it to the live government portal takes less than 60 seconds:

  1. Login to https://www.gst.gov.in.
  2. Go to:
    Dashboard  ➔  Return Dashboard
    
  3. Select the Financial Year and Return Filing Period, then click Search.
  4. In the GSTR-1 tile, look at the two buttons: Prepare Online and Prepare Offline. Click on Prepare Offline.
  5. Under the Upload tab, click Choose File and select the .json file generated by the offline utility.
  6. The portal will display: "Your request has been received. Please check the status after some time."
  7. Refresh the page after 2 minutes. The status will update to Processed.
  8. Return to Prepare Online, review your summary, generate summary, and complete your filing using EVC OTP or DSC!

Common Offline Tool Errors & How to Fix Them

Here are the most frequent roadblocks when using the Excel-to-JSON utility:

1. "Invalid JSON Format / Error in Uploaded File"

  • Cause: The Excel template version you used is outdated, or you modified column header names.
  • Fix: Never change, rename, or reorder column titles in the government template. Always download a fresh template directly from the portal downloads section.

2. "Duplicate Invoice Number Found"

  • Cause: The exact same invoice serial number was entered twice in the B2B sheet, or used in a previous month.
  • Fix: Under GST rules, invoice serial numbers must be consecutive and unique for the financial year. Search your Excel sheet (Ctrl + F) for duplicate numbers and correct them.

3. "Invoice Date Cannot be Later Than Current Date"

  • Cause: Excel date formatting glitch. If your Windows date format is MM/DD/YYYY instead of DD/MM/YYYY, the tool misinterprets 4th May (04/05/2027) as 5th April.
  • Fix: Format all date cells in Excel explicitly as text or standard DD-MMM-YYYY (e.g. 12-Apr-2027).

Why Modern Merchants Are Moving Away from the Offline Tool

While the GST Offline Tool is a vast improvement over manual typing, it still has noticeable drawbacks:

  • You have to manually copy and paste numbers between your accounting register and the Excel template;
  • One accidental typo or merged cell breaks the entire JSON file generation;
  • It does not integrate with your retail counter barcode scanner or thermal printer.

This is why thousands of Indian retailers and distributors are switching to SuperBiller.

With SuperBiller:

  • Every bill you ring up at the cash counter automatically updates your live GST registers;
  • You get instant 80mm thermal receipts with exact UPI payment QR codes;
  • When the 11th of the month arrives, you click Export GSTR-1 and get a verified, pre-formatted file ready for your CA or the portal in one click!


Related In-Depth Guides & Recommended Reading

Expand your tax compliance and store management knowledge with these related guides from our topic cluster:

Frequently Asked Questions (FAQ)

Does the GST Offline Tool work on Mac or Linux?

The official .exe installer is designed for Windows (Windows 7 and above). To run it on a Mac, you need to use Windows virtualization software like Parallels Desktop, or use modern cloud-based billing software like SuperBiller that runs in any web browser on Mac, Windows, and Android.

What is the maximum number of invoices the offline tool can handle?

The Excel template can handle up to 19,000 invoice rows in a single workbook. If you have more than 19,000 invoices, you can import multiple CSV files sequentially into the offline tool before generating the final JSON.

Can I edit invoices after uploading the JSON file to the portal?

Yes! Uploading a JSON file does not permanently submit your return. It simply populates the draft tables in your portal dashboard. You can open GSTR-1 > Prepare Online to view, edit, add, or delete any uploaded invoice before completing final OTP verification.


Regulatory References & Official Software Standards

For business accounting mandates, digital security standards, and statutory audit compliance, refer to the following official resources:

Tags:#GST Offline Tool#Excel to JSON#GSTR-1 Utility#GST Return Filing#Accounting Tools
Editorial Integrity & Statutory ComplianceCBIC & GST Council Validated

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.

Related Free Indian MSME Tools100% Free
SuperBiller ERP Software

Ready to automate your GST Billing & 80mm POS?

Generate your first tax invoice in under 30 seconds. 100% offline-ready.

Get Started Free