JSON to CSV

Turn an array of JSON objects into a CSV table.

JSON input

JSON array input

[
  {"name":"John","age":25},
  {"name":"Jane","age":30}
]

CSV output

CSV output

name,age
John,25
Jane,30

About the JSON to CSV

API responses are lists of objects; spreadsheets want rows and columns. This converter walks every object in the array, collects the union of all keys and emits them as the header row.

Objects with missing keys leave the cell empty rather than shifting columns. Values containing commas, quotes or newlines are quoted and escaped following RFC 4180.

Frequently asked questions

Related tools

JSON to YAML

Converters

Convert JSON documents into readable YAML.

Open Tool

YAML to JSON

Converters

Parse YAML and convert it into formatted JSON.

Open Tool

CSV to JSON

Converters

Convert CSV or delimited text into a JSON array.

Open Tool

Base64 Encoder / Decoder

Converters

Encode text to Base64 and decode Base64 back to text.

Open Tool