Getting an API response in front of someone who lives in Excel means converting JSON to CSV. This tool collects the union of every key across the array so no column is silently dropped, flattens nested objects into dotted column names, and quotes any value containing a delimiter or newline.
Every key found anywhere in the array becomes a column, and records missing that key get an empty cell. This avoids losing fields that only appear in later rows.
They are flattened into dotted column names, so a user object with a name field becomes a "user.name" column. Arrays are serialised as JSON inside a single cell.
Because they contain a delimiter, a quote character, or a line break. Doubling internal quotes and wrapping the field is the CSV standard for escaping.
Usually. If accented characters look wrong, the issue is Excel guessing the encoding — importing explicitly as UTF-8 rather than double-clicking the file fixes it.
All free tools · Blog · About · Contact