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.