GSTZen has developed various JSON to Excel converters that will help you convert bulk JSON files into Excel format quickly. Here is the list of JSON to Excel online converter GSTZen has to offer:
Normal Taxpayer (JSON To Excel Converters)
Composition Taxpayer
Input Service Distributor
- Visit GSTZen website
- Click on Useful Tools at the top navigation bar
- Under JSON To Excel Converters, click to choose the JSON you want to convert
No. The Zip file you download from the government portal can be directly uploaded into GSTZen
- Click on Upload or Drag and drop the JSON/Zip file
- On the upload page, click on Convert to Excel
- You may download the Excel file from Click here to download your Excel
Here’s a screenshot of the output sample from the GSTR 2A JSON to XLSX Converter. Once you open the 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.
GSTZen’s JSON to XLSX converter is an online tool. No download required; access it using your Web Browser such as Google Chrome, Mozilla Firefox, or Microsoft Edge.
The free version of GSTZen’s JSON file to Excel converter is limited to 50 records (Invoices, Credit Notes, etc.) in a file.
To download the Excel file with the first 50 records, click on Click here to download partial file – 50 Records only
To convert larger files, click on Click here to signup and download full Excel. You will need to Signup to GSTZen, Log into your account, Add funds and then convert the complete file.
- You may visit https://my.gstzen.in/ to create an account with GSTZen. Please see article – Sign up to create a new GSTZen account for instructions on how to create your GSTZen account.
- With your newly created GSTZen account, you will now be able to access the complete features of GSTZen. Please see article – Log-in to your GSTZen account for information on the Login procedure.
GSTZen supports all major Credit and Debit cards, Net banking from all Major banks, UPI, and Private Wallets. Read our article on – Adding funds to your GSTZen wallet for more details. Don’t feel like reading through an article? This video will also explain how you may Add funds to your GSTZen account.
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.
JSON to XLS Converter is free for the first 50 records in a JSON file. Minimum conversion amount for upto 500 records is Rupees 40. Additional records (beyond 500) are charged at 2 paise per record. For example, the cost to convert a JSON file with 325 records is Rupees 40 and for 750 records is Rupees 45.
Num. Records | In Words | Conversion Cost() |
---|---|---|
50 | Fifty | Zero |
500 | Five hundred | 40.00 |
1,000 | One Thousand | 50.00 |
5,000 | Five Thousand | 130.00 |
10,000 | Ten Thousand | 230.00 |
50,000 | Fifty Thousand | 1030.00 |
1,00,000 | One Lakh | 2030.00 |
Yes. GSTZen uses a pre-pay model. Any amount that you pay gets added to your GSTZen Wallet. Every time you convert a JSON file, GSTZen deducts from your Wallet balance.
The minimum payment amount is Rupee 40 (GST additional). You can add as little or as much as you want based on your expected usage.
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 would receive the Invoice to your registered email address the same day you make the payment. Should there be a delay, we guarantee the receipt of the Invoice within 2 working days.
Any amount added to your GSTZen wallet is valid for 1 year.
You can view your GSTZen wallet balance on your GSTZen Billing page. Please see article – Check GSTZen 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.