How do I convert Gstr 1 Excel to JSON?

Asked by: Dr. Emerson Hyatt  |  Last update: September 20, 2026
Score: 4.3/5 (69 votes)

Convert GSTR-1 Excel data to JSON by downloading the official GST Offline Tool from the GST portal. Open the tool, select "New" under "Upload new invoice/other data," enter your GSTIN and period, then click "Import Files" to upload your Excel sheet, finally clicking "Generate File" to create the JSON.

How to convert GST Excel file to JSON?

Once you are done uploading all the data to your GST Offline Utility Tool, click on the 'View Summary' button as highlighted below: Here, just click on 'Generate File' to generate a JSON file that can be uploaded to the GST Portal. Click on the link to download the JSON file: That's it!

How to export gstr-1 in JSON format?

From the GST Filing Module

  1. Go to GST Filing on the left sidebar.
  2. Select Unpushed Transactions under GSTR-1 and click the File your Return tab.
  3. In the File your Return page, click Export As at the top and select JSON.

How do I convert Excel to JSON format?

Excel doesn't offer the JSON format as one of its export options, so there's no built-in feature that can transform your data for you. However, you can copy the Excel data, paste it into a text editor, manually format it as JSON, and save it to a file.

How to generate JSON file for GSTR-1 in Busy?

To generate a JSON file directly from BUSY, follow these steps: Go to Display > GST Reports > GST Returns > GSTR-1 eReturn. Clicking on GSTR-1 eReturn will open a new window where you can select the type of report you wish to generate (JSON, CSV, As per govt. template, or Plain Excel).

How to Convert Excel to json online?

42 related questions found

How to create a JSON File for GST?

Go to the 13 - Documents Issued page, and enter the details.

  1. Submit your returns and e-sign. METHOD 2: BY USING THE GST OFFLINE TOOL. ...
  2. data from Tally.ERP 9: Export GSTR-1 returns in the MS Excel or CSV. ...
  3. F2: Period: Select the period for which returns need to be filed.

How to create a JSON File format?

Manually creating a JSON file

  1. Open a text editor and enter data in the following Salesforce Analytics schema format: Copy. { "fileFormat" : { }, "objects" : [ { <object_detail>, "fields" : [ { <Field1 details> } { <Field2 details> }…… ] }] }
  2. Save and close the file in the . json format.

How to convert CSV data to JSON?

CSV to JSON

  1. Upload Your CSV File: Drag and drop your CSV file into the upload area or click to choose a file from your device.
  2. Enter CSV Content: You can also paste your CSV content directly into the input box.
  3. Click Convert: Hit the "Convert to JSON" button and get your converted JSON file instantly.

How to convert Excel to JSON in Power Automate?

This makes setting up the demonstration easier.

  1. Step 1: Select the Automated Cloud Flow Option. ...
  2. Step 2: Configure the Site Address and List Name. ...
  3. Step 3: Get Excel Attachments and Attachment Contents. ...
  4. Step 4: Convert Excel Files Bytes to JSON. ...
  5. Step 5: Parse JSON.

How to export data in JSON format?

To export data to JSON:

  1. In Object Explorer, right-click a database, point to Data Pump, and then click Export Data.
  2. On the Export format page, select the JSON export format or load export options from a template file if you saved it previously.

How to get GSTR-1 data in Excel?

Export GSTR-1 in Excel format

  1. Press Alt+E (Export) > E-Return.
  2. Select the File Format as Excel (Spreadsheet).
  3. Set Export document summary to Yes.
  4. Export the file.
  5. Open the GSTR-1 offline tool downloaded from the GST portal. Import the MS Excel file into the GST Offline Tool.

How to return data in JSON format?

To return JSON from the server, you must include the JSON data in the body of the HTTP response message and provide a "Content-Type: application/json" response header. The Content-Type response header allows the client to interpret the data in the response body correctly.

How to validate gstr-1 json file?

User has to First Select the client from Grid. After that click on E-file tab and click on Validate JSON File button which is situated at the bottom of the window as shown below. These all are only warning message if you thing all the details are accurate/correct then you can simply ignore it.

How to create a JSON file for GSTR 1 from tally?

Generate the JSON file from Tally. ERP 9

  1. Go to Gateway of Tally > Display > Statutory Reports > GST > GSTR-1 .
  2. F2: Period: Select the period for which returns need to be filed.
  3. F12: Configure: To view the export options for HSN/SAC details, enable Show HSN/SAC Summary?
  4. Press Ctrl+E .

How to download GSTR 1 JSON from GST portal?

Downloading GSTR-1 for Offline Filing

  1. Step 1: Login to the GST Portal:
  2. Step 2: Access the Returns Dashboard:
  3. Step 3: Select Period and Year:
  4. Step 4: Prepare GSTR-1 Offline:
  5. Step 5: Generate the File:
  6. Step 6: Download the ZIP File:
  7. Step 7: File downloaded.
  8. Step 1: Visit the GST Portal and Login.

What is the date format for Gstr 1 in Excel?

The date format should bedd- mmm-yyyy only(eg 01-Jul-2017). ii. Incorrectinvoice format entered in excel. Invoice number should be maximum 16 digit and alphanumeric.

How to convert Excel to json file for gstr 1?

To convert GSTR-1 Excel to JSON, download the GST offline tool from the GST portal. Import your GSTR-1 Excel file into the tool, check the summary, and click “Generate File” to create a GSTR-1 JSON file. This JSON format is the only file type accepted for uploading GSTR-1 returns on the GST portal.

How do I convert a JSON file?

2 answers

  1. Open Excel and go to the Data tab.
  2. In the Get & Transform Data group, click Get Data.
  3. Select From File > From JSON.
  4. Browse and select your . json file, then click Import.
  5. In the Power Query Editor, preview and transform your data as needed.
  6. Click Close & Load to display the data as a table in your worksheet.

Can Power Automate extract data from Excel?

Use Power Automate to create a flow. Upload Excel data from OneDrive. Extract text from Excel, and send it for Named Entity Recognition(NER) Use the information from the API to update an Excel sheet.

How to convert an Excel into JSON?

Steps to export Excel data to JSON format

  1. Step 1: Create an ASP.NET Core project.
  2. Step 2: Install the following NuGet packages as references to your . NET Core applications from NuGet.org:
  3. Step 3: Add the following code example in the index. cshtml file to design the UI screen.
  4. Step 4: Click Convert to JSON.

Are CSV and JSON the same?

The CSV command converts logs to comma-separated values (CSV) format. The JSON command converts logs to JavaScript™ Object Notation (JSON) format. The CSV and JSON commands have similar syntax with many common parameters. Both commands can write to a ddname, a z/OS® UNIX™ file path, or a TCP socket.

How to convert file into JSON file?

  1. Upload Document. Select file from your computer, or simply drag and drop file into the upload box. ...
  2. Convert PDF to JSON. Veryfi's PDF to JSON converter automatically recognizes content in your PDF and converts it into JSON.
  3. Download JSON file. Download your converted JSON file immediately with no signup required.

Is JSON hard to learn?

JSON is easy to learn, especially if you are familiar with JavaScript.