How to use it
How to use json to csv
Convert an array of JSON objects into spreadsheet-ready CSV with safe quoting for commas, quotes, and line breaks.
Convert a flat array of product records into a spreadsheet-ready CSV.
- Paste a JSON array of objects with consistent top-level keys.
- Review the output columns, quoted cells, and any nested values serialized as JSON text.
- Choose Copy and verify spreadsheet import settings for dates and identifiers.
How it works
Keys from the first object define the columns, flat values are escaped as CSV cells, and nested values are preserved as JSON strings. Use consistent keys across rows.
Common uses
- Move API data into a spreadsheet
- Create a CSV export from records
- Review which object keys become columns
What the free tool includes
- Flat-object conversion
- RFC-style quoting
Common questions
What happens to nested JSON?
Nested objects and arrays become JSON text inside a CSV cell. They are not flattened into separate columns. Use an array of flat objects when you need one column per field.
Which keys become CSV columns?
The current converter takes columns from the first object. Keep the same keys in every row, and include all required fields in the first object so later-only fields are not omitted.
How are missing values and nulls represented in CSV?
For columns established by the first object, a missing field or null value produces an empty cell. That output does not distinguish missing values, null, and an empty string. Keep the original JSON if that distinction matters.
How do I keep IDs and dates unchanged when opening the CSV?
Keep long IDs and leading-zero values as quoted strings in the input JSON, then choose text column types when importing the CSV into a spreadsheet. Spreadsheet software may otherwise reinterpret IDs or dates; CSV quoting alone does not prevent that.
For accounts, browser storage and access, read the Desklium FAQ.