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 , "...