Our Network


Coming Soon


Coming Later

JSON to CSV Converter

World's Simplest JSON Tool

Free online JSON to CSV converter. Just load your JSON in the input field and it will automatically get converted to CSV. In the tool options, you can enable or disable the conversion of JSON object keys into CSV column headers, specify the CSV field delimiter symbol, the quote character, and toggle the quoting of all fields on or off. Created for developers by developers from team Browserling.

᠎᠎᠎          Tool Options

CSV Header Row

Convert the keys of JSON
objects into the header
row of the CSV.

CSV Column Separator

Character that separates
columns. (By default, CSV
uses a comma as a delimiter.)

CSV Field Quote

Character that encloses fields
in quotes. (By default, CSV
uses double quotes.)
Enclose all CSV Values in quotes.

What Is a JSON to CSV Converter?

This tool converts data stored in JSON format (JavaScript Object Notation) into CSV format (Comma Separated Values). JSON format is commonly used for exchanging information via APIs, while CSV is commonly used for storing backups and exporting database data. From a technical perspective, JSON supports structured information in the form of objects and arrays, while CSV represents tabular information, where the data is separated by commas and laid out in a table. This conversion is useful when you need to import data from JSON sources (such as APIs) into programs for working with spreadsheets, like Excel or Google Sheets. In the tool options, you can choose whether to use JSON object keys as the first row (headers) in the CSV file. If the input JSON is an array of arrays, then the headers are the elements in the first nested JSON array. Additionally, the tool allows you to create custom symbol-separated formats, such as SSV (Semicolon Separated Values) and HSV (Hash Separated Values). To do it, you can select the character used to separate columns in the output file. Typically, a comma is used to create a CSV file, but if you set it to a semicolon, you'll get an SSV file (Semicolon Separated Values), and if you set it to a pipe symbol, you'll get a PSV file (Pipe Separated Values). You can also specify the character used to enclose field values in quotes. By default, this symbol is double quotes, but you can set a different character, such as single quotes. For consistency, you can also enable an option to always wrap all CSV values in quotes. To convert a CSV file back to a JSON file, you can use our Convert CSV to JSON tool. Json-abulous!


JSON to CSV Converter Examples

Click to try!

Convert JSON to CSV with Headers

In this example, we convert an array of JSON objects into a CSV file. Because each JSON object has two keys and values, they form two CSV columns in the output. The keys get converted into CSV column names and are placed at the top row of the CSV data. They identify the contents of each column. Additionally, for easier parsing, we enable quoting of all CSV fields.

[ { "planet" : "earth", "size" : "400" }, { "planet" : "mars", "size" : "500" }, { "planet" : "jupiter", "size" : "9000" } ]
"planet","size" "earth","400" "mars","500" "jupiter","9000"
Required options
These options will be used automatically if you select this example.
Convert the keys of JSON
objects into the header
row of the CSV.
Character that separates
columns. (By default, CSV
uses a comma as a delimiter.)
Character that encloses fields
in quotes. (By default, CSV
uses double quotes.)
Enclose all CSV Values in quotes.

Turn a JSON Data Structure into a Single-Column CSV

In this example, we extract social media URLs from a complicated JSON data structure and turn it into a simple single-column CSV file. To do it, we adjust the tool options to remove the CSV column headers and disable CSV field quoting. Then, we load the JSON data structure containing an array of four objects into the input of the tool, and the tool extracts the values of all "url" keys into a single vertical CSV column without a header and quotes.

[ { "url" : "catonmat.net" }, { "url" : "reddit.com" }, { "url" : "digg.com" }, { "url" : "news.ycombinator.com" } ]
catonmat.net reddit.com digg.com news.ycombinator.com
Required options
These options will be used automatically if you select this example.
Convert the keys of JSON
objects into the header
row of the CSV.
Character that separates
columns. (By default, CSV
uses a comma as a delimiter.)
Character that encloses fields
in quotes. (By default, CSV
uses double quotes.)
Enclose all CSV Values in quotes.

Convert JSON Arrays with Musical Data to a CSV File

In this example, we convert a JSON array containing multiple nested arrays into a CSV file. Each inner JSON array contains the names of different musical instruments (keyboard, string, and wind instruments). During the conversion, all arrays are transformed into comma-separated rows, forming three rows and three columns.

[ [ "Piano", "Organ", "Synthesizer" ], [ "Guitar", "Violin", "Cello" ], [ "Flute", "Clarinet", "Trumpet" ] ]
Piano,Organ,Synthesizer Guitar,Violin,Cello Flute,Clarinet,Trumpet
Required options
These options will be used automatically if you select this example.
Convert the keys of JSON
objects into the header
row of the CSV.
Character that separates
columns. (By default, CSV
uses a comma as a delimiter.)
Character that encloses fields
in quotes. (By default, CSV
uses double quotes.)
Enclose all CSV Values in quotes.

Pro tips Master online json tools

You can pass input to this tool via ?input query argument and it will automatically compute output. Here's how to type it in your browser's address bar. Click to try!

https://onlinetools.com/json/convert-json-to-csv?input=%5B%0A%20%7B%0A%20%20%20%22planet%22%20%3A%20%22earth%22%2C%0A%20%20%20%22size%22%20%3A%20%22400%22%0A%20%7D%2C%0A%20%7B%0A%20%20%20%22planet%22%20%3A%20%22mars%22%2C%0A%20%20%20%22size%22%20%3A%20%22500%22%0A%20%7D%2C%0A%20%7B%0A%20%20%20%22planet%22%20%3A%20%22jupiter%22%2C%0A%20%20%20%22size%22%20%3A%20%229000%22%0A%20%7D%0A%5D&convert-headers=true&char-delimiter=%252C&char-quote=%2522&convert-quote=true

All JSON Tools

Didn't find the tool you were looking for? Let us know what tool we are missing and we'll build it!
Quickly color-code the syntax of a JSON file.
Quickly beautify a JSON data structure.
Quickly compress a JSON file.
Quickly convert JavaScript data to a JSON string.
Quickly convert a JSON string to JavaScript data.
Quickly check JSON for errors and report them.
Quickly escape special JSON characters.
Quickly unescape an escaped JSON string.
Quickly convert a JSON data structure to an XML file.
Quickly convert an XML file to a JSON data structure.
Quickly convert a JSON data structure to a YAML markup.
Quickly convert a YAML markup to a JSON data structure.
Quickly convert a JSON file to a TSV file.
Quickly convert TSV data to a JSON file.
Quickly convert a JSON file to a CSV file.
Quickly convert CSV data to JSON data.
Quickly convert a JSON structure to binary JSON encoding.
Quickly convert JSON to a PNG, GIF, JPG, or BMP image.
Quickly create a screenshot from JSON code.
Quickly encode JSON to base64.
Quickly decode base64 to JSON.
Quickly convert JSON to URL-encoding.
Quickly convert URL-escaped JSON back to JSON.
Quickly convert JSON data to plain text.
Quickly edit a JSON file in a neat JSON editor in your web browser.
Quickly extract keys from objects in JSON data.
Quickly extract values from objects in JSON data.
Quickly reduce the nesting level of an array of arrays.
Quickly create a single-level JSON object from nested JSON objects.
Quickly rewrite JSON strings, keys, and values using escape codes.
Quickly obfuscate a JSON data structure.
Quickly remove certain information from a JSON data structure.
Quickly display detailed information about a JSON data structure.
Quickly convert a JSON file to properties file.
Quickly convert a properties file to a JSON file.

Coming Soon

These JSON tools are on the way!
Find JSON Keys/Values

Find keys and/or values that interest you in a JSON file.

Convert JSON to a List

Create a text list from a JSON array or object.

Convert a List to JSON

Create a JSON array from a text list.

Convert JSON to Form Data

Generate HTTP form data from a JSON object.

Convert Form Data to JSON

Generate JSON object from HTTP form data.

Convert JSON to HTML

Create a HTML table from keys and values of a JSON object.

Convert JSON to CSON

Convert a JSON file to a CSON file.

Convert CSON to JSON

Convert a CSON file to a JSON file.

Convert JSON to TOML

Convert a JSON config to a TOML config.

Convert TOML to JSON

Convert a TOML file to a JSON file.

Convert JSON to Bencode

Convert a JSON data structure to Bencode encoding.

Convert Bencode to JSON

Convert Bencode data to JSON data.

Convert JSON to JSONL

Convert a JSON file to a JSONL file.

Convert JSONL to JSON

Convert a JSONL file to a JSON file.

Convert BSON to JSON

Convert binary JSON data structure (BSON) to JSON.

Convert JSON to UBJSON

Convert a JSON file to a universal binary JSON (UBJSON).

Convert UBJSON to JSON

Convert universal binary JSON (UBJSON) to regular JSON.

Convert JSON to Message Pack

Serialize JSON data to binary MessagePack format.

Convert Message Pack to JSON

Unserialize binary MessagePack to a JSON struct.

Convert JSON to Protobuf

Serialize JSON data to binary Protobuf format.

Convert Protobuf to JSON

Unserialize binary Protobuf to a JSON struct.

Convert JSON to a LaTeX Table

Generate a LaTeX table from a JSON object.

Convert JSON to INI

Convert a JSON data file to an INI configuration file.

Convert INI to JSON

Convert an INI configuration file to JSON data file.

Truncate JSON

Loop over JSON structure and truncate all values or keys.

Find JSON Depth

Find the nesting depth of a JSON data structure.

Convert JSON to a Data URI

Convert a JSON data structure to a data URL.

Convert JSON to a PHP Array

Create a PHP data structure from a JSON data structure.

Convert a PHP array to JSON

Create a JSON data structure from a PHP data structure.

Compare Two JSON Files

Diff JSON files and show differences visually.

Sort JSON Object Keys

Lexicographically sort the order of JSON object keys.

Swap JSON Keys with Values

Exchange keys with values in a JSON file.

Create a Random JSON Array

Create a JSON array with random values.

Create a Random JSON Object

Create a JSON object with random keys and values.

Randomize a JSON Array

Randomly change the positions of array elements.

Randomize a JSON Object

Randomly change the order of key, value pairs.

Add Spacing to JSON

Add random spaces and newlines in a JSON file.

Tokenize JSON

Tokenize a JSON data structure.

Remove JSON Syntax

Remove all JSON syntax and leave just the values.

Change JSON Syntax

Change curly braces, commas, and quotes to other symbols.

Fix Quotes in JSON

Fix incorrectly quoted (usually single quote) keys and values.

Use Single Quotes in JSON

Make all keys and values in a JSON to be single-quoted.

Use Double Quotes in JSON

Make all keys and values in a JSON to be double-quoted.

Generate FakeSON

Create JSON that looks real but is fake (FakeSON).

Run jq

Execute a jq query on a JSON data structure.

Filter JSON

Filter keys and values that match a pattern.

Split a String into a JSON Array

Create a JSON array from a string.

Group a JSON Array

Create groups of JSON array items.

Merge JSON Arrays

Merge two or more JSON arrays together.

Compare JSON Arrays

Find differences in two or more JSON arrays.

Merge JSON Objects

Merge two or more JSON objects together.

Damage JSON

Introduce errors in a JSON data structure.

Fix JSON

Try to fix a damaged JSON to the best of our ability.

Create JSON Art

Convert images to valid JSON strings that look like ASCII art.

Visualize a JSON Structure

Create an abstract visualization of JSON's complexity.


Subscribe!

Subscribe to our updates. We'll let you know when we release new tools, features, and organize online workshops.

Enter your email here


Feedback. We'd love to hear from you! 👋



Didn't find the tool you were looking for? Let us know what tool we are missing and we'll build it!