JSON to CSV Converter

Skip to editor
Explorer
Open Files

No files open

0 files open

jsoneditor.io v2

No file open

Create a new file or open an existing one from the sidebar

JSONUTF-8
Spaces: 2

How do I convert JSON to CSV?

To convert JSON to CSV, paste a JSON array of objects above, open Convert and press To CSV. Each object becomes a row and each key becomes a column, using every key found across all the objects, so rows with extra fields keep them.

Nested objects are flattened into dot notation columns like address.city, arrays of simple values are joined into one cell, and arrays of objects are kept as JSON inside the cell. Press Save to download the result as a .csv file for Excel or Google Sheets.

  1. Paste a JSON array into the editor.
  2. Open Convert and press To CSV.
  3. Press Save to download the .csv file.

Example

JSON
[
  {
    "id": 1,
    "name": "Alice",
    "address": {
      "city": "London",
      "country": "UK"
    },
    "skills": [
      "JavaScript",
      "Python"
    ]
  },
  {
    "id": 2,
    "name": "Bob",
    "address": {
      "city": "Paris",
      "country": "France"
    },
    "skills": [
      "Go"
    ]
  },
  {
    "id": 3,
    "name": "Carol",
    "address": {
      "city": "Tokyo",
      "country": "Japan"
    },
    "skills": [],
    "manager": true
  }
]
CSV
id,name,address.city,address.country,skills,manager
1,Alice,London,UK,"JavaScript, Python",
2,Bob,Paris,France,Go,
3,Carol,Tokyo,Japan,,true

Questions people ask

Why does it say my JSON must be an array?

CSV is a table, so the converter needs a list of rows. If the array is wrapped in an object, like {"users": [...]}, pull it out first, Query view with $.users[*] does that in one go.

Will the CSV open properly in Excel?

Yes. Values with commas, quotes or line breaks are quoted the standard way, so Excel and Google Sheets keep them in one cell.

Can I convert the CSV back to JSON?

Yes, press To JSON in the CSV section. Values come back as strings and the dot notation columns stay flat.

Is my data uploaded anywhere?

No, this runs entirely in your browser, so nothing you paste is sent to a server. The only feature that sends data anywhere is the optional AI assistant, and only when you actually ask it something.

Read the guideHow to Convert JSON to CSV for Excel and Google Sheets