JSON To CSV
Convert an array of JSON objects into CSV with a combined header row and safely quoted values.
How to use the JSON To CSV
What does the JSON To CSV do?
Convert an array of JSON objects into CSV with a combined header row and safely quoted values; It applies this page-specific rule: the union of all object keys becomes the header row, so records may contain different properties without shifting values into the wrong column.
Which inputs does this tool use?
To convert an array of json objects into csv with a combined header row and safely quoted values, enter JSON object or array, Output delimiter, Delimited result; keep every value in the same example; where available, choose between Comma (,), Tab, Semicolon (;), Pipe (|) to match the required format; select Convert JSON to CSV when the values are ready; Start with a familiar case covered by this rule - Flattening turns a nested property such as address.city into a column named address.city - so the expected result can confirm the settings.
How should the tool result be read?
For a result intended to convert an array of json objects into csv with a combined header row and safely quoted values, flattening turns a nested property such as address.city into a column named address.city; read delimited result together with the original json object or array rather than as an isolated answer, and confirm that its units or structure match the intended use.
Must the JSON contain an array?
When the goal is to convert an array of json objects into csv with a combined header row and safely quoted values, no.
What happens to nested objects?
When using the page to convert an array of json objects into csv with a combined header row and safely quoted values, they are flattened into dotted column names by default.
Limits and accuracy
When using this tool to convert an array of json objects into csv with a combined header row and safely quoted values, quotation marks, delimiters, and line breaks are escaped when required by the selected output format; check the result in its intended destination before relying on it for important work; keep json object or array until the output has been checked in its intended destination.
How objects become rows and columns
The union of all object keys becomes the header row, so records may contain different properties without shifting values into the wrong column. Missing properties become empty fields.
Flattening turns a nested property such as address.city into a column named address.city. Arrays remain JSON text inside one field because expanding them into an unpredictable number of rows would change the data’s meaning.
Quotation marks, delimiters, and line breaks are escaped when required by the selected output format.
Frequently asked questions
Must the JSON contain an array?
No. A single object becomes one data row.
What happens to nested objects?
They are flattened into dotted column names by default. Turn that option off to keep nested values as JSON text.
Are commas inside values safe?
Yes. Fields are quoted and embedded quotation marks are escaped when necessary.