Convert JSON to CSV

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.

Converted on ToolSlick's server. Your input and its output are not stored.

Paste JSON content below
Converted CSV

Settings

How the input is converted. Each is explained below.

History

  • 2019-01-06Support for dot as path delimiter
  • 2018-01-12Support for multiple JSON input
  • 2017-11-08Boolean value cleansing
  • 2017-09-04Tool Launched

Settings explained

Delimiter
What separates the fields and the column names in a record: comma, tab, semi colon, pipe or space.
Path Delimiter
How the columns of nested objects are named: the property names along the path, joined by this.
Write Header
Whether the first record holds the column names.
Cleanse Boolean Values
True and FALSE are written as true and false.
Handle Multiple Jsons
An input of one JSON document per line is converted as one list of records.

Background

Use Cases

Nested JSON to CSV Converter
This tool is designed to work with JSON documents. Your JSON data can have array of objects or even objects inside of objects. The tool does it's best to come up with a CSV output that best corresponds to your nested JSON.
Convert JSON to Pipe Delimited
Paste your JSON in the input or upload a JSON file. The default output data format is comma separated. Goto settings and choose Pipe as the delimiter. Click on Convert. Your input JSON will be converted to a pipe delimited format. Optionally, hit the Download button to save the output as a CSV file.

JSON

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

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.

Related tools