goods and service tax

Published on 9 April 2025

GSTR-1 JSON to Excel Converter: Streamline B2B Invoice Management

GSTR-1 JSON to Excel Utility

The GSTR-1 JSON to Excel utility streamlines the extraction and organization of B2B (Business-to-Business) invoice details from GSTR-1 JSON files. This tool is especially beneficial for businesses and professionals, as it efficiently converts JSON data into a structured Excel format, capturing essential invoice information such as:

  • GSTINs
  • Invoice numbers
  • Dates
  • Values
  • Place of supply
  • Reverse charge indication
  • Invoice types

This utility is specifically designed for user-friendliness and exclusively deals with B2B invoices, excluding B2C transactions, exports, amendments, and HSN summaries that are available on the GSTN website.

How to Use the GSTR-1 JSON to Excel Utility

  1. Open the Excel Workbook:

    • Begin by opening the Excel workbook where the utility is stored. Ensure that macros are enabled.

  2. Select the JSON File:

    • Upon opening, you will be prompted to choose a GSTR-1 JSON file. Click on “Browse,” navigate to your desired JSON file, and select it.

  3. Convert to Excel:

    • Once the JSON file is selected, click “Convert.” The utility will process the data and convert it into a structured Excel format.

  4. Save the Excel File:

    • After the conversion is complete, save the newly created Excel file to your chosen location.

  5. Review Data:

    • Open the saved Excel file to examine B2B invoice details including GSTINs, invoice numbers, dates, values, and other relevant information.

  6. Additional Information:

    • Please note that this utility focuses specifically on B2B invoices. For any B2C transactions, exports, amendments, or HSN summaries, it is advised to refer to the GSTN website.
Share: