How to Convert Excel to JSON for GST and GSTR-1 Filing

If you file GST returns in India, you already know the frustration: your data lives in Excel, but the government portal wants JSON. Whether you're preparing GSTR-1 returns, filing an ITR, or generating e-invoices, this guide shows you how to get your Excel spreadsheet converted to JSON quickly — using a free browser-based tool that never uploads your financial data to any server.

One important note before we start: our tool converts Excel data to a standard JSON array format. It won't produce the exact GST portal schema automatically — but it gets you 80% of the way there, and this guide explains how to bridge the rest.

Why the GST Portal Uses JSON Format

The Indian GST portal (gstn.org.in) accepts return data in JSON format because JSON is machine-readable, compact, and easy to validate against a schema. When you use the GST Offline Tool or upload returns directly, the system expects structured JSON that matches the official schema for GSTR-1, GSTR-2A, or whichever return type you're filing.

Most accountants and business owners maintain their sales data, invoice details, and tax calculations in Excel spreadsheets. That's perfectly fine — but at submission time, you need to bridge the gap from Excel rows to JSON objects.

The core transformation is simpler than it sounds: Excel rows become JSON objects, column headers become JSON keys, and the whole sheet becomes a JSON array. That's exactly what our free Excel to JSON converter does — in seconds, without touching a server.

What JSON Our Tool Produces

Drop your Excel file into the Excel to JSON converter, pick your sheet, and you get output like this:

[
  {
    "Invoice_No": "INV-001",
    "GSTIN": "29ABCDE1234F1Z5",
    "Invoice_Date": "2026-03-01",
    "Taxable_Value": 10000,
    "CGST": 900,
    "SGST": 900,
    "Total": 11800
  },
  ...
]

The first row of your spreadsheet becomes the JSON keys. Each data row becomes a JSON object in the array. Numbers are typed as numbers, not strings — which matters for the GST portal's validation.

This flat JSON array is the starting point for GST submission. Depending on your return type, you may need to reshape this into the nested format the portal expects — most accountants use the GST Offline Tool to do this final mapping step.

Sell Custom Apparel — We Handle Printing & Free Shipping

Step-by-Step Guide for GSTR-1 Preparation

Here's the practical workflow most GSTR-1 filers use:

1. Prepare your Excel sheet with proper headers. Use clean column names that match your data fields: GSTIN, Invoice_No, Invoice_Date, Place_of_Supply, Taxable_Value, CGST_Rate, SGST_Rate, IGST_Rate, and so on. Avoid spaces in headers — use underscores instead.
2. Clean your data before converting. Remove blank rows, fix any cells where a number got stored as text, and make sure date columns are in consistent format (YYYY-MM-DD works best).
3. Open the Excel to JSON converter in your browser. Drop your .xlsx file onto the tool. If your workbook has multiple sheets, a sheet selector appears — pick the correct one.
4. Check the JSON output. Scan the first few records to confirm the data looks right. Numbers should not have quote marks around them. Dates should be readable strings.
5. Download the JSON file. Click "Download JSON" to save the file locally.
6. Import into the GST Offline Tool or upload directly. Depending on your return type, import this JSON into the government's GST Offline Tool for final schema mapping, or use it as input for your accounting software's upload feature.

For ITR filing, the same process applies: export your income/deduction data from Excel as JSON, then import it into the appropriate filing tool.

Common Errors When Converting GST Data to JSON

Dates showing as serial numbers (e.g., 45000 instead of 2026-03-01): This happens when Excel stores dates as numeric serial numbers. Format the date column as Text (YYYY-MM-DD) before converting, or use the tool's output and post-process the date fields. See our full guide on Excel to JSON date format issues.

Numbers wrapped in quotes: Happens when your Excel cells contain numbers stored as text (you'll see a small green triangle in the corner of the cell). Fix by selecting the column, clicking the warning icon, and choosing "Convert to Number."

Extra blank rows in output: Empty rows in Excel become empty JSON objects. Remove all blank rows before converting — use Ctrl+Shift+End to see the last used cell and delete rows below your actual data.

GSTIN format mismatch: The GST portal validates GSTIN format strictly. Make sure your GSTIN column values are stored as text (not numbers) to preserve leading zeros and letter casing.

Your GST Data Never Leaves Your Device

Financial data belongs on your device, not on a third-party server. Our converter processes everything in your browser using a client-side engine — your Excel file is never uploaded, stored, or transmitted anywhere. This matters for GST data, which contains GSTIN numbers, turnover figures, and invoice details that could expose your business if intercepted.

After you close the browser tab, nothing persists. There are no accounts to create, no files stored in the cloud, and no logging of what data you converted.

For comparison, several popular online converters (including some that rank for "excel to json converter for gst") upload your file to their servers. Check their privacy policies before using them with real financial data.

If you also need to convert CSV files to JSON for GST filing, check out our CSV to JSON for GST guide — same no-upload approach for CSV-formatted data.

Frequently Asked Questions

Can I use this tool for GSTR-1 filing directly?

The tool converts your Excel data to a JSON array — the right starting format. For official GSTR-1 submission, you typically need to import this JSON into the GST Offline Tool or your accounting software for final schema mapping. The converter handles the Excel-to-JSON step; the portal tool handles schema validation.

Does the tool support HSN codes and tax rates correctly?

Yes. Any column in your Excel sheet — including HSN codes, tax rates, and GSTIN values — becomes a JSON key-value pair. HSN codes stored as numbers will be typed as numbers in the output. If you need them as strings (some tools expect "8471" not 8471), format that column as Text in Excel before converting.

What about GSTR-2A JSON to Excel — can the tool do that?

The tool converts Excel to JSON. For the reverse direction (JSON to Excel), use our free JSON to Excel converter at /spreadsheet-tools/json-to-excel/ — same no-upload approach.

Is the tool free for commercial use including tax filing?

Yes, completely free. No account, no subscription, no usage limits. You can convert as many files as you need for GSTR-1, ITR, e-invoicing, or any other filing purpose.