Paste JSON above to see it here…
Processed locally
About this tool
This tool flattens an array of JSON objects into rows, using the keys as column headers. The result opens directly in Excel, Google Sheets or any data tool.
Use it to export API responses for analysis, or hand structured data to non-developers.
Nested objects are flattened with dot notation: user.name becomes a column.
Frequently asked questions
How are nested objects handled?
They are flattened using dot-notation column names (user.id, user.name). Arrays inside objects are JSON-stringified.
What if objects have different keys?
The column set is the union of all keys; missing values are left empty.
Can I choose the delimiter?
This tool outputs standard comma-delimited CSV. For semicolon- or tab-delimited output (common in European Excel locales), find-and-replace the delimiter after conversion — every value is quoted, so the swap is safe.