How to Convert JSON file of GSTR in Excel | Convert GSTR 2A JSON file in Excel format (free)

Date of filing of GSTR 2 for the month of July is 31st October 2017, to prepare GSTR 2 first GSTR 2A data has to be review by the person. GSTR 2A data can be downloaded in JSON File from GST Portal and JSON file can be view in GST offline Tool.
But the problem is, there is no option to convert JSON file in Excel Format and Excel is very much needful in case of large number of data.
so this video is all about how to convert JSON file of GSTR 2A in Excel Format for GSTR 2 filing
You can download the Octa convertor by clicking on following link:
Steps:
-save downloaded file
- extract
- run on your computer
- you will get octa icon

My Smart Home Channel Link:

Products I use for video recording and more, Link to buy are below. Please click:
Budget Mike for Audio recording:
Generic 57000928MG Silica Gel Professional Condenser Microphone Mic Sound Studio Recording Dynamic (Works with Phantom Power Supply Or Sound Card Only)

iball Rocky with mike, headphone and speakers:

Following Queries solved in this video:
1) How to download JSON file of GSTR 2A
2) How to convert JSON file in Excel
3) How to convert GSTR 2A JSON file in Excel Format
4) How to convert GSTR 2A JSON file in Excel Format for fee
5) Free Json to Excel file convertor
6) How to convert large GSTR 2A JSON data in Excel
7) Last date of filing GSTR 2 for July

Products I use for video recording and more, Link to buy are below. Please click:
Budget Mike for Audio recording:
Generic 57000928MG Silica Gel Professional Condenser Microphone Mic Sound Studio Recording Dynamic (Works with Phantom Power Supply Or Sound Card Only)

iball Rocky with mike, headphone and speakers:
Budget Cemeras:
Redme note 4 (xiaomi)
Coolpad Cool 1 (Gold, 3GB RAM + 32GB memory)
Coolpad Note 5 (Royal Gold, 32 GB)
Camera Stands:

Mini Tripod:
memore Mini Tripod Universal YT-228 For Digital Camera & All Mobile Phones- Black (YT-228 Tripod)
Laptops:
Lenovo Ideapad 320E 80XH01GKIN 15.6-inch Laptop (6th Gen Core i3-6006U/4GB/1TB/FreeDOS/Integrated Graphics)
HP HP 15 HP Notebook 15-BS549TU 2017 15.6-inch Laptop (Celeron N3060/4GB/500GB/Windows 10 Home Single Language(64 bit)/Integrated Graphics), Jet Black
Desktop:
Lenovo 510S-08IAP 90GB000QIN 21.5-inch All-in-One Desktop (Intel Core i3 7th Gen/7100/4GB/1TB/DOS/Integrated Graphics) LED IPS Monitor:
Tegh Computers Complete Desktop Computers Intel Core 2 Duo/2 GB/160 GB/15 Inch Led

Please Like, Share and Subscribe
Love
Pooja

[ManishVerma-ggxl]

बहुत बडीया मेडम आपने तो काम बहुत आसान कर दिया मेरा

[selvamm]

Thanks to CA Guru Ji channel. This video useful for all accounts peoples. Once again thanks to YOU.

[williammohanraj]

very easy to filing gstr2 method. Thanking you mam

[kasulagovardhan]

Hi mam. very usefull information and helped me a lot to get gstr-2a data in excel format.

[sujitsengupta]

Good demonstration Thanks, sujit sengupta

[karishmabakshi]

Thank you so much mam.... it is very helpful :)

[RAJESHDAS-uwls]

It is very helpful & thanks for sharing.

[harinderkumar]

nobody made video on you tube channel for filing of GST-ITC-04 which last date was 25 October 2017 but now Govt has extended it's date...So pls make video on it.
it would really helpful for every dealer..
thanks

[sanjivraut]

Thank you so much Guru JI.... it is very helpful

[sharadshitole]

Hi mam, How to open the Json file in the GST Offline Tool, is it possible?

[himanshudutta]

Thanks for video, how to reconcile purchase with GSTR 2A ?

[aamirahmed]

Can we export all GST reports or only GSTR2??

[rajanghadi]

While converting file into Excel is internet connection required? Question is asked because of data security. I don't want to share this data with software provider.

[surajitmandal]

Downloading time all entry are downloading accurately

[dilipgupta]

which is best online or offlin utilites in gst 2 return

[santoshprasad]

how can we reconcile our return and our books help with gson file as it may be diffrent after filling.

[yashdalmia]

Is this safe to use?' Data privacy and all other things?

[vibbj]

Hello mam, gst2 mai agar koi invoice edit krni ho to use edit krne k sath missing invoice mai bhi add krna hota hai kya ?

[heenamahajan]

Gstr 2 mein hsn summary col mein nil rated ki item fill krne pe tax amount vale box mein zero value likh paa rhe ... isko kaise thik kre

[shivanshtrivedi]

Mem GSTR1 excel file json mai convert karte same error aa rha