Supported JSON shapes
An array of objects (the most common), an array of arrays whose first array holds the headers, a single object, an object that wraps the records in a property such as data, results or items, and newline-delimited JSON (NDJSON or JSON Lines) with one object per line.
Nested data
Nested objects become dotted column names, so {"address": {"city": "Paris"}} turns into an address.city column. Arrays are kept as JSON text in a single cell, for example ["a","b"], so no information is lost. Every key that appears in any record gets a column, in the order it first appears.
From API to spreadsheet
Save an API response as a .json file, drop it here and you have a spreadsheet in seconds. Download it as Excel to share, or as CSV to import elsewhere.