JSON to CSV Converter Online - Free & Private
Paste a JSON array and get CSV you can open in Excel, Google Sheets or any database tool. Nested objects are flattened into dotted column names, and every row keeps the same columns even when some objects are missing keys.
How to convert JSON to CSV
- Paste a JSON array into the left editor, open a .json file, or drop one onto the page.
- The CSV appears on the right as you type. Turn off Live if you would rather press Convert (or Ctrl+Enter).
- Copy the CSV, or download it as a .csv file that opens straight in Excel, Google Sheets, LibreOffice or Numbers.
What the converter does with your data
Each object in the array becomes one row. The column list is the union of every key in every object, in the order the keys are first seen, so rows that are missing a field simply get an empty cell instead of shifting the other values out of place.
With Flatten nested on, a nested object such as {"address": {"city": "London"}} becomes a column called address.city. Arrays inside a row are written as JSON text in a single cell, so nothing is lost. If the input is an object that wraps a single array, such as {"users": [...]}, that array is used. Any other single object becomes a one-row table.
Values that contain the delimiter, quotes or line breaks are quoted the way spreadsheets expect, and quotes inside a value are doubled.
Options
- Delimiter: comma, semicolon, tab or pipe. Semicolon suits spreadsheets set to European locales, where the comma is the decimal separator. Tab gives you TSV.
- Flatten nested: write nested objects as dotted columns, or keep them as JSON text in one cell.
- Header row: include or leave out the first line of column names.
Example
The JSON [{"id":1,"name":"Ada","address":{"city":"London"}}] becomes:
id,name,address.city 1,Ada,London
Need to go the other way? The CSV to JSON converter reads the file back, and its Nest dotted keys option rebuilds the nested objects.
Private by design
The conversion runs entirely in your browser. Your JSON is never uploaded to our server, which makes the tool safe for exports that contain customer records or API keys.