🌍 Dev.to
Convert a JSON API Response to Excel: 3 Ways (No-Code, Python, Power Query)
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 , "...


