unable to create json file from gst offline tool latest version after successfully upload excell file

Question

after successful upload of excel file gst offline time of create josn file it sufring all time ,

Answer 1

after successful upload of excel file gst offline time of create josn file it sufring all time ,

I have also faced this problem. The Version V3.2.2 GST Offline tool is throwing error on all rows in the sheet "b2b,sez,de" and "Cdnr" of the excel template V2.1, giving a long list of compliances to be checked. Actually, this is not a problem with any of the data in the sheets. This problem occurs when you use the option IMPORT->IMPORT EXCEL.

There is another option for Section-wise Copy from Excel sheet and Paste on the Offline tool using Ctrl+V. If you use this option with the same set of data, it works well and the tool creates a JASON file. This JASON file gets uploaded on GST portal properly and I have filed multiple returns today.

So the problem is not relating to the various trouble shoot steps enumerated by Bo A. It is something else.... may be with the Template itself or with the Offline Tool V3.2.2

Answer 2

Hi

Facing the same issue and have tried doing everything.

Still it's not working

Please help

Answer 3

Hi SK AJIBUL ALI,

This my 2nd follow-up regarding your issue on this post. We would like to know if the issue you have raised to us is still on-going. If yes, please reply to the thread so we can continue troubleshooting your concern.

Thank you.

Answer 4

Hi SK AJIBUL ALI,

We have noticed that you have not replied to our last response. We would like to know if the issue you have raised to us is still on-going. If yes, please reply to the thread so we can continue troubleshooting your concern. 

Thank you.

Answer 5

Hi SK AJIBUL ALI,

Thank you for posting here in Community.

I totally understand that you are dealing with persistent issues while trying to generate a JSON file from the GST Offline Tool can be frustrating, especially after successfully uploading your Excel file. You’re expecting a smooth process, but instead, the tool seems to be stuck, endlessly processing without producing the required JSON file. That’s definitely not ideal, and I understand how important it is to get this resolved quickly.

Let’s troubleshoot this step by step:

1. Ensure Compatibility – Confirm that your system meets the necessary requirements for the GST Offline Tool. It works best on Windows 7 and above with Microsoft Excel 2007 or later.
2. Check Excel File Format – The Excel file must strictly follow the format provided by the GSTN. If there are any deviations, the tool may struggle to process the data.
3. Verify GSTIN and Return Period – Open the JSON file using WordPad and check the first few lines. Ensure that the GSTIN and return period match the details on the GST portal. A mismatch can cause errors.
4. Update Java – The tool relies on Java to function properly. Make sure you have the latest version installed from Java’s official site and restart your system.
5. Reinstall the GST Offline Tool – If the issue persists, uninstall the tool, download the latest version from the GST portal, and reinstall it.
6. Check for Special Characters – Avoid using special characters in any fields within the Excel file, as they can cause validation errors when generating the JSON file.
7. Try a Fresh JSON Generation – Instead of modifying an existing JSON file, start fresh by re-uploading the Excel file and generating a new JSON file.

If none of these steps resolve the issue, consider reaching out to GST support or checking forums for additional solutions. You’re not alone in this—many users have faced similar challenges, and there are fixes available. Let me know if you need further clarification!

Best regards,

Bo | Microsoft Community