JSON to XLS (JSON to Excel) Converter - Frequently Asked Questions
At present, GSTZen supports the following JSON to XLS Converters.
Visit my.gstzen.in and click on the menu named "Useful Tools" on the top of the page, in the navigation bar. You will see links to these converters in the drop down menu.
Click on Choose file and upload the JSON file downloaded from Government Portal. Then Click on Convert to Excel.
Click on Download GSTR-2A XLS to download and View the Excel data.
Here's a screenshot of the output sample from the GSTR-2A JSON to XLS Converter. The spread sheet 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 conversion software is an online software. 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 the Converter is limited to 200 records (Invoices, Credit Notes, etc.) in a file. To convert larger files, please signup at GSTZen, login into your account, and then convert.
GSTZen's JSON to XLS converters are available online and the price is based on usage. The conversion cost is free for the first 200 records (Invoices, Credit Notes, etc.) in a file. Additional records are charged at 1 Paisa per records. For example, to convert a file with 330 records, the cost will be 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.
Firstly, make sure that you have created an account on GSTZen and that you have logged in into your account. After logging in, you will see your name on the top right hand corner of the page. Click on our name, and then click on Billing.
In this page, you will see details about your GSTZen Wallet balance. You can choose an amount and add funds to your Wallet.
We support all major Credit and Debit cards, Net banking from all Major banks, UPI, and Private Wallets. If you are not able to pay using one of these methods, please get in touch with us. We can accept NEFT/RTGS payments to our bank account.
Against each payment, we issue a GST Tax Invoice. If you have provided your GSTIN number, we will issue you a B2B Invoice. Otherwise, we will issue you a B2C Invoice. Usually, you should receive the Invoice in your email the same day you make the payment. We guarantee to send out the Invoice within 2 working days.
Any amount added to your GSTZen Wallet is valid for 1 year.
You can view it in the your Billing page (in the same page from which you made your payment).
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.