Convert JSON to Excel

#Download GSTR-1 JSON files

First you need to download GSTR-1 JSON files from GST Portal. There are 2 options to download GSTR-1 JSON files:

• Generate & download GSTR-1 files one by one from GST Portal
• Recommended: Bulk download of GSTR-1 files using Octa Portal

#Add to Octa GST

• Simply open the Octa GST business file
• Go to GSTR-1 page
• Click on Add button
• Select the zip files downloaded in above step. Note that you can select multiple files to import all of them in one go.
• Click Start button to start the import process.

#Export to Excel

On the GSTR-1 page, Click on the Export button and select the periods you would like to export. If you select multiple periods, all the data from selected periods will be exported to a single Excel file.