GSTR-2B JSON to Excel
Open the GSTR-2B JSON from the GST portal as a tidy Excel workbook: every invoice item, credit notes, supplier-wise totals and ITC totals.
Frequently asked questions
Why convert GSTR-2B JSON instead of the portal Excel?
The JSON has every invoice with item-wise tax rates, which makes reconciliation with your purchase register (Tally, Busy, Excel) easier. This tool flattens it so each tax line is one row.
Are the ITC totals the same as the portal summary?
They are worked out from the documents in the file: forward-charge invoices with ITC available, minus credit notes, with reverse-charge and ITC-not-available documents shown separately. Always compare with the portal summary before filing GSTR-3B.
Is GSTR-2B JSON to Excel free?
Yes. GSTR-2B JSON to Excel is free to use. You get 3 free conversions a day without an account, and unlimited use when you sign in with Google.
Are my files uploaded?
No. The conversion runs inside your browser, so your files stay on your device and are never sent to our servers.
Does it work on mobile?
Yes. PixKaro works in Chrome, Safari, Edge and Firefox on Android, iPhone, Windows and Mac.