JSON to Excel converter using GSTZen

Overview

What JSON file to Excel converters does GSTZen support?

At present, you may convert JSON file to Excel through GSTZen for the following JSON files.

Where can I find these JSON to Excel converters?

  • Visit my.gstzen.in
  • Click on Useful Tools at the top navigation bar GSTZen Useful Tools
  • Under JSON To Excel Converters, click on the JSON to Excel converter you want

How can I convert my JSON file to Excel?

  • Click on Choose File and upload the JSON file downloaded from the Government Portal
  • Click on Convert to Excel

Choose the JSON file

  • Click on Click here to download your Excel

Download converted Excel file

How does the Excel output look like?

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.

GSTR-2A JSON to XLS

Is GSTZen's conversion software available for download? Can I run it on my computer?

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.

I used GSTZen's JSON to Excel converter, but the output was limited to 200 invoices. How do I get the rest of the data?

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.

Over 200 JSON records

How can I Signup and Login?

  • Please refer this article for instructions on - Sign up.
  • Please refer this article for instructions on - Log in.

Payment

How to add funds to your GSTZen Wallet?

Refer our article on Adding funds into GSTZen account or watch the video below:

What is the price of the GSTZen's JSON to Excel conversion software?

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. RecordsIn WordsConversion Cost()
200Two hundredZero
500Five hundred3.00
1,000One Thousand8.00
5,000Five Thousand50.00
10,000Ten Thousand100.00
50,000Fifty Thousand500.00
1,00,000One Lakh1,000.00
5,00,000Five Lakh5,000.00
10,00,000Ten Lakh10,000.00

Do I have to pay before converting a JSON file?

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.

How much should I pay?

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.

Add funds to GSTZen

Where should I pay?

  • 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.

GSTZen Billing page

What payment methods does GSTZen support?

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.

When will I receive an Invoice for my payment?

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.

How long do funds remain in the GSTZen wallet?

Any amount added to your GSTZen wallet is valid for 1 year.

Where can I view my GSTZen Wallet Balance?

You can view your GSTZen wallet balance in the your Billing page, refer our article on Viewing Wallet Balance

Troubleshooting

The output of GSTZen's JSON to excel converter does not match the output shown in the Government portal. Is GSTZen's JSON file to Excel converter incorrect?

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.

To know about GSTR 2A Reconciliation with GSTZen, please click here
To known about GSTR 1 vs GSTR 2A vs GSTR 3B Consolidated Comparison Report, please click here