JSON to CSV Converter
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}