JSON to CSV Converter

JSON to CSV converter is used to convert JSON text or file into CSV or delimited format. You can choose whether to write the header record & what delimiter to use. Nested JSON documents are also supported. Checkout the examples.

For paid customers of Tool Slick: Make sure you login to ToolSlick before accessing the tool or else you will be redirected here.

Input

Output

Settings

Configure the settings for the conversion

Tags

Use Cases

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

Choose which delimiter to use to separate the fields & column names in a record. Acceptable values are:-

Comma
Tab
Space
Pipe
Semi-Colon

Comma Delimiter

name,department
John Doe,Engineering
Jane Doe,Billing

Tab Delimiter

name	department
John Doe	Engineering
Jane Doe	Billing

Space Delimiter

name department
"John Doe" Engineering
"Jane Doe" Billing

Pipe Delimiter

name|department
John Doe|Engineering
Jane Doe|Billing

Semi-Colon Delimiter

name;department
John Doe;Engineering
Jane Doe;Billing

Path Delimiter

This setting governs how the column names are formed in complex JSON structures which have nested objects. You can choose between any of the 4 delimiters which will be used to join the property names and create the output CSV column.

Uderscore Path Delimiter

name|department|address_city|address_state
John Doe|Engineering|Atlanta|Georgia
Jane Doe|Billingr|Hayward|California

Double Underscore Path Delimiter

name|department|address__city|address__state
John Doe|Engineering|Atlanta|Georgia
Jane Doe|Billingr|Hayward|California

Slash Path Delimiter

name|department|address/city|address/state
John Doe|Engineering|Atlanta|Georgia
Jane Doe|Billingr|Hayward|California

Pipe Delimiter

name|department
John Doe|Engineering
Jane Doe|Billing

Dot Path Delimiter

name|department|address.city|address.state
John Doe|Engineering|Atlanta|Georgia
Jane Doe|Billingr|Hayward|California

Write Header
Choose whether to write the header record (which contains the names of the columns) in the output.
- Write Header On
```
name,department
John Doe,Engineering
Jane Doe,Billingr
```
- Write Header Off
```
John Doe,Engineering
Jane Doe,Billingr
```
Cleanse Boolean Values
If selected, Boolean values in Sentence & Capital cases such as True, False, TRUE & FALSE are transformed to their lowercase versions before conversion to CSV. This makes sure that the JSON is valid by cleansing the boolean values. According to the JSON specification, such boolean values are invalid and only lowercase true/false are valid.
Use this if your input JSON has such boolean values in Sentence or Capital casing. However, this will also transform such words inside JSON strings (i.e inside double quotes)

Handle Multiple Jsons

If selected, multiple JSONs in the input are handled. Each Valid JSON must completely exist in one line.

{"name": "Robin Hood","department": "","manager": "","salary": 200}
{"name": "Arsene Wenger","department": "Bar","manager": "Friar Tuck","salary": 50}
{"name": "Friar Tuck","department": "Foo","manager": "Robin Hood","salary": 100}

Handle Multiple Jsons On
The above input works
Handle Multiple Jsons Off
The above input does not work