GSTR-1 JSON to Excel Utility

GSTR-1 JSON to Excel Utility

This Excel utility simplifies the extraction and organization of B2B (Business-to-Business) invoice details from GSTR-1 JSON files. Ideal for businesses and professionals, it efficiently converts JSON data into a structured Excel format, including essential invoice details such as GSTINs, invoice numbers, dates, values, place of supply, reverse charge indication, and invoice types. Designed for ease of use, it focuses solely on B2B invoices, omitting B2C transactions, exports, amendments, and HSN summaries, which are readily available on the GSTN website.

How to Use the GSTR-1 JSON to Excel Utility

1. Open the Excel Workbook: Open the Excel workbook where the utility is saved. Ensure macros are enabled. 

2. Select the JSON File:

• You’ll be prompted to select a GSTR-1 JSON file upon opening.
• Click “Browse”, navigate to your JSON file, and select it.

3. Convert to Excel:

• After selecting the JSON file, click “Convert”.
• The utility processes the data into a structured Excel format.

4. Save the Excel File: Once conversion is complete, save the Excel file to your desired location.

5. Review Data: Open the saved Excel file to view B2B invoice details like GSTINs, invoice numbers, dates, values, and more.

6. Additional Info: The utility focuses solely on B2B invoices. For B2C transactions, exports, amendments, or HSN summaries, use the GSTN website.