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 · free tool

JSON to CSV

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

Runs in your browser — your data never leaves it

Input

Paste, type, or drop a file. Runs as you type.

Output

Output appears here as you type.

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 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.