At present, you may convert JSON file to Excel through GSTZen for the following JSON files.
- Visit my.gstzen.in
- Click on Useful Tools at the top navigation bar
- Under JSON To Excel Converters, click on the JSON to Excel converter you want
- Click on Choose File and upload the JSON file downloaded from the Government Portal
- Click on Convert to Excel
- Click on Click here to download your Excel
Here's a screenshot of the output sample from the GSTR 2A JSON to XLS Converter. Once you open JSON file in Excel, the spreadsheet has one row per Invoice with columns for the Supplier's GSTIN number, Supplier's name, Supplier's Filing Status, Invoice Date, Invoice Number and Tax Amounts.
At present, GSTZen's JSON to Excel conversion software is an online tool, allowing you to convert JSON to Excel online. Access it using your Web Browser such as Google Chrome, Mozilla Firefox, or Microsoft Edge. Upload your JSON file and download XLS output. If there is enough demand, we might consider providing a Desktop version.
The free version of GSTZen's JSON file to Excel converter is limited to 200 records (Invoices, Credit Notes, etc.) in a file.
To download the Excel file with the first 200 records, click on Click here to download partial file - 200 Records only
To convert larger files, click on Click here to signup and download full Excel. You will need to signup at GSTZen, log into your account, add funds and then convert the complete file.
Refer our article on Adding funds into GSTZen account or watch the video below:
GSTZen's JSON to XLS converters are available online for all customers to use, free of cost. GSTZen only charges customers for the actual JSON to Excel conversion.
The cost of JSON to Excel conversion is free for the first 200 records (Invoices, Credit Notes, etc.) in a file. Additional records are charged at 1 Paisa per record.
For example, to convert a file with 330 records, you will be charged Rupees 2 (Rupees Two).
The approximate conversion cost for various number of records is shown:
|Num. Records||In Words||Conversion Cost()|
Yes. GSTZen uses a pre-pay model. Any amount that you pay gets added into your Wallet. Every time you convert, GSTZen deducts from your Wallet balance.
The minimum payment amount is Rupee 1 (GST additional). You can add as little or as much as you want based on your expected usage.
- Ensure that you have a GSTZen account and are logged into the account
- Click on Logged in as your name on the top right corner of the page.
- Click on Billing.
You can view your GSTZen Wallet Balance and Add funds into your GSTZen account on this in this Billing page.
We support all major Credit and Debit cards, Net banking from all Major banks, UPI, and Private Wallets. If you are unable to pay using one of these methods, please get in touch with us. We can accept NEFT/RTGS payments to our bank account.
GSTZen issues Tax Invoices against each payment. In cases where you have provided your GST number, we issue a B2B Invoice. If there is no GST number registered for invoicing, we issue a B2C Invoice.
You should receive the Invoice in your registered email address the same day you make the payment. However, we guarantee the receipt of Invoice within 2 working days.
Any amount added to your GSTZen wallet is valid for 1 year.
You can view your GSTZen wallet balance in the your Billing page, refer our article on Viewing Wallet Balance
Our Converter's output is correct. The usual explanation for the difference is that the file you are converting is old. Please check your file name and make sure that the file was generated recently.
For example, if your file name starts with returns_26042018_R2A it was generated on 26-Apr-2018. Even though you might have downloaded your file today, it might have been generated a long time ago.