JSON To CSV

Convert JSON to CSV format

Upload a JSON file Select a file...

Or paste your JSON here

[
      {
        "album": "The White Stripes",
        "year": 1999,
        "US_peak_chart_post": "-"
      },
      {
        "album": "De Stijl",
        "year": 2000,
        "US_peak_chart_post": "-"
      },
      {
        "album": "White Blood Cells",
        "year": 2001,
        "US_peak_chart_post": 61
      },
      {
        "album": "Elephant",
        "year": 2003,
        "US_peak_chart_post": 6
      },
      {
        "album": "Get Behind Me Satan",
        "year": 2005,
        "US_peak_chart_post": 3
      },
      {
        "album": "Icky Thump",
        "year": 2007,
        "US_peak_chart_post": 2
      },
      {
        "album": "Under Great White Northern Lights",
        "year": 2010,
        "US_peak_chart_post": 11
      },
      {
        "album": "Live in Mississippi",
        "year": 2011,
        "US_peak_chart_post": "-"
      },
      {
        "album": "Live at the Gold Dollar",
        "year": 2012,
        "US_peak_chart_post": "-"
      },
      {
        "album": "Nine Miles from the White City",
        "year": 2013,
        "US_peak_chart_post": "-"
      }
    ]

Options Hover on option for help

Separator Flatten Output CSVJSON variant

Result

Download Copy

CSV to JSON

XML To JSON

JSON To XML

Convert JSON to PHP Array

JSON Escape / Unescape

C# Escape / Unescape

Javascript Escape / Unescape

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.

Upload your JSON file or paste your JSON text into the textbox
Use the default comma separator or change it to tab or semicolon
Click the Convert button
View the JSON to CSV convertion in the Result box
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.

If we wish to count lines of code, we should not regard them as ‘lines produced’ but as ‘lines spent.’
Edsger Dijkstra