JSON To CSV

What is JSON to CSV converter?

This is a free online tool for converting JSON to a CSV file format. The data format conversion can be beneficial for REST-based service automation testing.  This utility can convert any JSON data to CSV or spreadsheet format.
CSV files may be opened with ease in standard spreadsheet programs such as Microsoft Excel, OpenOffice, LibreOffice Calc in Ubuntu or Google Spreadsheets.

Using Convert JSON to CSV online tool

JSON to CSV Converter transforms the structured content of a JSON file into a table representation.

1. Upload your JSON file or paste your JSON text into the textbox
2. Use the default comma separator or change it to tab or semicolon
3. Click the Convert button
4. View the JSON to CSV convertion in the Result box
5. Copy or download the CSV data format

What is JSON

JSON (JavaScript Object Notation); also ECMA-404, JSON Data Interchange Format

JSON is a lightweight, text-based, language-independent data interchange format. It was derived from the Javascript/ECMAScript programming language, but is programming language independent. JSON is considered as a lightweight alternative to XML, as in JSON: The Fat-Free Alternative to XML, a 2006 presentation by JSON's developer, Douglas Crockford. JSON defines a small set of structuring rules for the portable representation of structured data. JSON provides simple notation for expressing objects, collections of name/value pairs, and for arrays, ordered lists of values. By nesting these two basic structures, trees and other complex data structures can be represented.

JSON syntax uses braces (curly brackets: {} ), square brackets ( [] ), colons, and commas to arrange values that are strings (sequences of characters in double quotes) or numbers (expressed as sequences of digits) into the two basic structures.

An object is an unordered set of name/value pairs. An object begins with { (left brace) and ends with } (right brace). Each name is followed by : (colon) and the name/value pairs are separated by , (comma). An array is an ordered collection of values. An array begins with [ (left bracket) and ends with ] (right bracket). Values are separated by , (comma). A value can be a string in double quotes, or a number, or true or false or null, or an object or an array. These structures can be nested.