Home
Tom Utilities

JSON to CSV

JSON Tools

Convert an array of JSON objects into a CSV table ready for spreadsheets.

Input

Result

How to use

Converting JSON to CSV

Provide an array of objects. A header row is created from the union of all keys.

  1. Paste an array of JSON objects.
  2. Press Convert.
  3. Copy or download the CSV file.

Frequently asked questions

What if the rows have different keys?

The union of all keys is used and missing values become empty cells.

How are commas and quotes handled?

Fields containing commas, quotes or newlines are quoted and inner quotes are doubled.

Related tools

JSON to XML Convert a JSON document into well formed XML with a configurable root element. JSON Sorter Sort object keys alphabetically at every level and optionally sort arrays. JSON Formatter Beautify and validate JSON with configurable indentation, error highlighting and one click copy. JSON Validator Check whether your JSON is valid and see a clear explanation of any syntax problem. JSON Minifier Remove every unnecessary space and newline to produce the smallest possible JSON payload. JSON Viewer Read JSON in a clean formatted view and explore it as a collapsible tree.