Convert GSTR-1 JSON files to Excel

Describes how to convert GSTR-1 JSON files to Excel format

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 from GST Portal using Octa GST Assistant

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.