How are commas and quotes inside values handled?

Properly escaped per RFC 4180 — a value containing a comma is quoted, and a quote inside a value is doubled. The output round-trips through the CSV to JSON tool.

What if my records have different keys?

The header comes from the first record. Feed it a uniform array of records for predictable output.

converters · Integration Studio Tool

JSON to CSV

Turn a JSON array of records into CSV, with proper escaping.

Your data never leaves your browser

This tool runs entirely on your computer. What you paste or drop is never uploaded, never stored and never seen by us — close the tab and it's gone. How we know

Input

Output

Press Run to see the output. Sign up takes ten seconds — no credit card required.

Worked example

Input

[{"name":"Ada","age":36},{"name":"Al","age":41}]

Output

name,age
Ada,36
Al,41

This example is one of JSON to CSV's test cases — if the tool stopped producing this output, the build would fail.

Questions

How are commas and quotes inside values handled?: Properly escaped per RFC 4180 — a value containing a comma is quoted, and a quote inside a value is doubled. The output round-trips through the CSV to JSON tool.
What if my records have different keys?: The header comes from the first record. Feed it a uniform array of records for predictable output.

Related tools

XML to JSONConverters

Convert XML into JSON, attributes and text nodes included.

JSON to XMLConverters

Convert JSON into XML, with sensible element names and nesting.

CSV to JSONConverters

Turn a CSV (or TSV, ; and | files) into a JSON array of records — headers become keys.

EDI to XMLConverters

Turn an X12 or EDIFACT file into readable XML — in your browser, nothing uploaded.