JSON to CSV Converter
Create a CSV table from records returned by an API or exported from another system. Columns are the union of top-level object keys, and commas, quotes, and line breaks are escaped correctly.
JSON to CSV
Turn an array of objects into spreadsheet-friendly CSV.
Array JSON0 lines
Output0 lines
1Ready. Load an example or paste JSON to begin.Ready. Load an example or paste JSON to begin.
Parse summary
- Root
- -
- Keys
- -
- Depth
- -
- Size
- -
Type counts
strings -numbers -booleans -nulls -objects -arrays -
Structure preview
No valid JSON preview.
Data handling notes
- Input must be an array of objects.
- Nested objects and arrays are stored as compact JSON inside one CSV cell.
- Column order follows first appearance across the records.
Before you rely on the result
This tool is intended for fast inspection and routine preparation. It can save time, but it does not replace review when the result affects production systems, security settings, business data, or legal obligations.
- Check representative inputs instead of assuming one example covers every edge case.
- Do not paste secrets, private customer data, or credentials unless you have confirmed the page processes that data locally and the use is allowed by your organization.
- Copy the output into your own workflow only after checking formatting, timezone, encoding, or syntax assumptions.
- Data conversion tools preserve structure where possible, but they cannot infer business rules such as optional fields, database dialects, XML namespaces, or CSV column meaning.
FAQ
How are nested objects handled?They are serialized as compact JSON within a quoted CSV cell rather than flattened.
Why does a field become an empty cell?That record does not contain the column key found in another record.