Sign up free

JSON to CSV Converter

Turn a JSON array into a CSV with one column per key, right in your browser.

More tools
Excel & CSVExcel to CSVCSV to ExcelXLS to XLSXNumbers to ExcelODS to ExcelHTML Table to Excel
Export tables & SQLExcel to SQLJSON to SQLSQL to ExcelXML to ExcelCSV to XMLExcel to Markdown TableExcel to HTMLExcel to WordExcel to Image

or drop files here

Accepts JSON

Runs in your browser. Your files never leave your device.

About JSON to CSV

JSON to CSV takes the output of an API, a NoSQL export or a config dump and lays it out as rows and columns that Excel, Google Sheets or a BI tool can load. Paste the JSON or open a file; the CSV appears as you type, with one row per object and a header row built from every key found in the data.

Nested objects become dotted columns such as address.city, lists of simple values are joined into one cell, and lists of objects spread over numbered columns like items[0].sku. Values that contain the separator, quotes or line breaks are quoted. Choose comma, semicolon or tab, and the saved file carries a UTF-8 BOM so Excel shows every character correctly. Everything happens in your browser.

How to use JSON to CSV

  1. 1
    Paste or open JSON

    Paste into Input, drop a .json file on the box or use Open file. Mistakes are pointed out as you type.

  2. 2
    Pick a separator

    Choose comma, semicolon or Tab under Separator to suit the program that will open the CSV.

  3. 3
    Save the CSV

    Copy the JSON to CSV result, or click Save for a .csv file that opens in Excel with the right characters.

Why use Cubfile for this

  • Nested keys flattened

    Deep objects turn into readable column names like customer.address.city.

  • Columns for every key

    Objects with different fields still line up; a missing value leaves an empty cell.

  • Excel-friendly file

    Saved CSVs start with a UTF-8 BOM, so accents and Chinese text don't turn into gibberish.

  • Private and unlimited

    Your JSON never leaves the browser, and conversions don't count as tasks.

FAQ

JSON to CSV: questions and answers

Does JSON to CSV upload my file?
No. Parsing and conversion happen in your browser, so API keys, customer records and anything else in the JSON stay on your device.
How are nested arrays converted?
Arrays of plain values, such as tags, are joined into one cell as a, b. Arrays of objects get a column per item and field, for example items[0].name and items[1].name.
Why does my JSON to CSV show an error?
The input isn't valid JSON yet, often because of a missing comma, a trailing comma or single quotes around keys. The message under Result says where the parser stopped, and JSON Formatter can help you find and fix it.
Which separator should I choose?
Comma is the default and works almost everywhere. Pick semicolon for Excel set to a European locale, and Tab if the values themselves contain lots of commas. To skip separators altogether, JSON to Excel produces a workbook instead.
Is it free, and how big can the JSON be?
It's free and doesn't use your daily tasks. There's no upload limit either, since nothing is uploaded; very large files are only limited by your browser's memory.
Share JSON to CSV with a friendIt runs in any browser, and they can try it without signing up.

Related tools

XLSSQL Excel to SQLGenerate CREATE TABLE and INSERT statements from Excel or CSV.
XMLXLS XML to ExcelTurn repeating XML records into spreadsheet rows.
CSVXLS CSV to ExcelOpen CSV and TSV data in Excel with the right columns and encoding.
CSVJSON CSV to JSONConvert CSV to JSON in your browser. Nothing is uploaded.
CSVXML CSV to XMLConvert CSV or Excel rows into XML records.
XLSCSV Excel to CSVSave each sheet as CSV, line breaks in cells handled.
XLSHTML Excel to HTMLTurn a sheet into an HTML table you can paste into a page.
XLSJPG Excel to ImageSnapshot sheets and charts as images.