Hello Guys,

I would like to convert JSON Response into Excel tabular format

For e.g . JSON Response:
{"clients":[{"id":1,"name":"Shrikant","active":true},{"id":2,"name":"Rahul","active":true},{"id":3,"name":"Sachin","active":true},{"id":4,"name":"Satish","active":true}]}

I would like to store this response into excel file as in below format:
id Name active
1 Shrikant TRUE
2 Rahul TRUE
3 Sachin TRUE
4 Satish TRUE

I have seen many JSON to Excel online viewers but I need any tool or utility which performs such kind of operation. I tried with excel macros but haven’t succeeded.
It would be great if any one can help me out with the Macros.
Thanks.