JSON to CSV Converter
Convert JSON arrays of objects into CSV with nested field flattening
Accepted upload: .json · max 5 MB. Accepts an array of objects or a single object. Nested fields become dotted columns (e.g. address.city).
JSON input
Paste or upload JSON
CSV output
Convert result
About JSON to CSV
Turn JSON records into spreadsheet-friendly CSV in your browser. The converter accepts a JSON array of objects (best for multiple rows) or a single object (one row). Nested objects flatten into dotted column names such as address.city.
How to use
- Paste JSON or upload a .json file (up to 5 MB).
- Click Convert. Valid input becomes CSV with a header row from object keys.
- Copy the result or download converted.csv.
How conversion works
- Each top-level object key becomes a column. Nested plain objects use dotted keys instead of extra columns for sub-objects.
- Array values stay in one cell as a JSON string so list structure is not lost.
- null and undefined become empty cells.
Common uses
- Export API or log JSON for Excel, Google Sheets, or BI tools.
- Share a flat snapshot of nested configuration or survey responses.
- Quickly inspect many records without writing a script.
Tips
- Prefer an array of objects with consistent keys so columns align across rows.
- For round-trips, pair this tool with CSV to JSON — dotted headers rebuild nesting on the way back.
- Output uses RFC 4180-style quoting with CRLF line endings for broad spreadsheet compatibility.
Limitations
- Input must be valid JSON under 5 MB. Empty arrays, non-object array elements, or invalid JSON will fail with an error.
- Deep or irregular nesting can produce many dotted columns; simplify structure if the sheet becomes unwieldy.
Privacy
Conversion runs entirely in your browser. ToolsArk does not upload your JSON for processing.
Frequently asked questions
Common questions about the JSON to CSV Converter.
What JSON shapes does the JSON to CSV Converter support?
An array of objects (recommended) or a single object treated as one row. Each object’s keys become CSV columns. Nested objects are flattened with dotted keys such as address.city.
How are nested objects and arrays handled?
Nested plain objects are flattened into dotted column names. Array values stay as a single cell containing a JSON string so structure is preserved. Null and undefined become empty cells.
Does my JSON leave my device?
No. Conversion runs entirely in your browser. ToolsArk does not upload your JSON for conversion.
Why did conversion fail?
Usually the input is invalid JSON, an empty array, an array of non-objects (for example numbers or strings), or larger than 5 MB. Fix the reported error and try again.
Can I download or copy the CSV?
Yes. After a successful conversion you can copy the CSV to the clipboard or download a .csv file. You can also upload a .json file as input.
Will Excel open the CSV correctly?
The output uses RFC 4180-style quoting with CRLF line endings. Excel and Google Sheets open standard UTF-8 CSV. For special Excel locale issues, import the file as UTF-8 CSV.
Need to go the other way?
Use the CSV to JSON Converter to turn CSV back into nested JSON. Both tools share the same conversion engine and keep your data on this device.
Tags
Continue with these utilities
People frequently use these utilities together.