We are a small team of Software Providers. We recently received a request from one of our CAs, where they were facing a difficulty in downloading the GSTR2A files and converting them into Excel Format.

We have given a simple solution where you can download the .json file from the GSTR2A and upload it on our system. You can download an excel file with all the necessary details. Please check out at http://dev.opalcrm.com/converter

Would be great if you could please let us know if this would help you ease in GSTR calculations for your clients.

You can reach us at contactus @ kloudportal.com

Author Bio

Qualification: Post Graduate
Company: KloudPortal
Location: Hyderabad, Telangana, IN
Member Since: 02 Mar 2018 | Total Posts: 1

More Under Goods and Services Tax

Posted Under

Category : Goods and Services Tax (8133)
Type : News (13993)
Tags : goods and services tax (6579) GST (6180) Software (102)

24 responses to “How to Convert GSTR 2A JSON File to Excel Format”

  1. Saagar Rathi says:

    Credit and Debit Note number is not shown in exported data.

  2. Giri says:

    Hello Team
    Thanks for your help, recently tried converting the json file and received the following error, please let me know how to fix this.

    • kolluru81 says:

      Dear Giri,

      We got few request on our email address contactus@kloudportal.com and we have rectified the issue.

      In case of any further error, please drop us an email and we will be able to help you our immediately.

      Appreciate your time!

  3. vikas negi says:

    converted gstr 2b into excel….invoice count is correct but tax values (igst) is not matching with summary….huge difference in taxes…please help

  4. priyank says:

    great work. thanks for sharing

  5. Monika says:

    I tried converting the GSTR2A into excel it was done properly but the problem pertained to Credit and Debit Notes which are not converted in this link. Kindly help in converting the CN/DN part even in seperate sheet in same excel

  6. Anamika says:

    Perfects . Thanks
    But deppt shoud also give name of the party & date of Invoices

    • kolluru81 says:

      Hello Anamika,

      Thank You for reaching us. We can give you the invoice date in the output excel file. For the party name, it can be done. However, the current input file doesn’t give the party details except for the party’s GSTIN.

      To pull the party details, we need to do additional customization. In case you are interested to know more, please drop us an e-mail at contactus@kloudportal.com

  7. kolluru81 says:

    Hello All,

    We have received great feedback from few of the CAs. We understood that the converter wasn’t working for few files. Hence we have made some changes to it. Kindly contact us in case you face any issue in converting the files.

    • Abhrakesh Mankad says:

      Actually we have faced in downloding jason file of GSTR2A. Today we could download it and found no issue in converting it into excel file. Thanx!

      • kolluru81 says:

        Hello Abhrakesh,

        Thank You for letting us know your experience. Please let us know in case there are any issues/problems that we can help you with.

        We are a team of Software Product Developers from Hyderabad. You can e-mail us at contactus@kloudportal.com

  8. SAJID KHAN says:


  9. SAJID KHAN says:




Leave a Reply

Your email address will not be published. Required fields are marked *