1. Home
  2. Tools
  3. Conversion
  4. Data
  5. JSON to CSV Converter
Share

Convert JSON to CSV Popular

JSON   CSV   CONVERSION  
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.


Input: Paste JSON content below



Settings



Background Information

JSON pronounced as "Jason" is the de facto standard for data interchange on the web these days. It is a simple format that is easier to comprehend than XML. It also has less size than XML because of no closing tags. Interacting with JSON from JavaScript is extremely seamless.

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

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
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
In complex JSON structures which have nested objects, this setting governs how the column names are formed.
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
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.
Handle Multiple Jsons On
The following input works
{"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 Off
The following input does not work
{"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}
➤