Skip to content

JSON to CSV

Turn a JSON array into a spreadsheet-ready CSV file.

How to convert JSON to CSV

Three steps, all in your browser.

  1. 1

    Paste or open your data

    Drop a file or paste rows straight into the input box.

  2. 2

    Check the options

    Delimiter, header row, indentation: the output updates live.

  3. 3

    Download

    Save the converted file, or copy the output.

JSON to CSV: what to know

JSON stores data as nested objects and arrays, while CSV is a flat grid of rows and columns that Excel, Google Sheets and databases open directly. Converting between them means deciding how a tree fits into a table, and this converter does it with simple, predictable rules.

An array of objects becomes one row per object. The columns are every key found in any object, in the order they first appear, and a missing key leaves an empty cell. Nested objects become dotted column names, so {"address": {"city": "Paris"}} fills an address.city column. Lists of plain values are joined into one cell with "; " between them, and lists of objects are written into the cell as JSON text so no data is dropped. Turn flattening off to keep every nested value as JSON text instead.

Other shapes work too. An array of arrays becomes rows with no header, a list of plain values becomes a single value column, and an object that wraps one list of records, such as {"users": [...]}, uses that list. JSON Lines files, with one object per line, are read as well. The CSV is written with commas, quotes only where needed and Windows line endings, which every spreadsheet reads.

Popular uses

  • Opening an API response in Excel or Google Sheets
  • Importing JSON exports into a database or CRM
  • Sharing app data with people who don't read code
  • Making a quick report from a JSON log file

Tips for the best result

  • If the result has a single row, your data is probably one object; point the converter at the list inside it.
  • Deeply nested data makes many columns; consider exporting only the fields you need first.
  • Choose a semicolon delimiter if your spreadsheet app uses commas for decimals.

Read how JustYourConvert works and our privacy details. Keep your original files and check a converted file before you replace anything.

Frequently asked questions

An array of objects works best: each object becomes a row and every key found becomes a column. Arrays of arrays, a list of plain values and a single object also work, and if an object holds one list of records, such as {"users": [...]}, that list becomes the rows.

Nested objects become dotted column names, so {"address": {"city": "Paris"}} gives an address.city column. Lists of plain values are joined into one cell with "; " between them, and lists of objects are written into the cell as JSON text.

The columns are every key that appears in any object, in the order they first appear. When an object doesn't have one of those keys, its cell in that column is left empty.

No. Every live tool on JustYourConvert opens and converts your files inside your browser, on your own device. Nothing is sent to our servers, and the result is saved straight from your browser.

Yes. Every tool is free, with no sign-up, no watermark and no daily limit. Clearly labeled ads keep it that way.

Only your device's memory. Because the work happens in your browser, very large files can be slow on phones and older computers. Each tool says its practical limit under the drop area.