Convert a JSON API Response to Excel: 3 Ways (No-Code, Python, Power Query) (opens in new tab)

You call an API, get back JSON, and someone non-technical asks for it "in Excel." Here are three ways to do that — pick based on whether it's a one-off or a repeatable pipeline — plus the part everyone trips on: nested objects. The sample data [ { "id": 1, "name": "Ada", "address": { "city": "London", "zip": "EC1" }, "roles": ["admin", "editor"] }, { "id": 2, "name": "Alan", "address": { "city": "Oxford", "zip": "OX1" }, "roles": ["viewer"] } ] The catch: address is a nested object and roles ...