JSON to CSV Converter

Convert JSON text into CSV or another delimited format. Choose whether to write the header record and which delimiter to use. Nested JSON documents are supported - try the examples.
Input
Output

Settings

How the input is converted. Each is explained below.

Tags

Use cases

Nested JSON to CSV
The input can hold arrays of objects, or objects inside objects. The tool works out the CSV that best matches your nested JSON.
JSON to pipe-delimited
Paste your JSON, choose Pipe as the delimiter and convert. Download saves the result as a file.

History

JavaScript Object Notation (JSON), pronounced as Jason, is the most common data interchange format on the web. Douglas Crockford first released the JSON specification in the early 2000s. It is a simple format that is easier to comprehend than XML. It is also smaller in size because it does not have closing tags. A wide variety of programming languages can parse JSON files. They also support the serialization of data structures to JSON. You can copy JSON text to JavaScript and start using them without any modifications.

CSV is an old & very popular format for storing tabular data. It has been used in the desktop as well as mainframe. It is a simple & compact format that works really well for tabular data and so is still in use today.

Settings explained

Delimiter
What separates the fields and the column names in a record: comma, tab, semi-colon, pipe or space.
name|department
John Doe|Engineering
Jane Doe|Billing
Path delimiter
How column names are made for nested objects: the property names along the path, joined by this.
name,address__city,address__state
John Doe,Atlanta,Georgia
Write header
Whether the first record holds the column names.
Cleanse boolean values
Turns True, False, TRUE and FALSE into lowercase true and false before converting, as JSON only allows lowercase. This also changes those words inside strings.
Handle multiple JSONs
Reads several JSON documents, one per line.
{"name": "Robin Hood", "salary": 200}
{"name": "Friar Tuck", "salary": 100}