JSON to CSV
Convert a JSON array of objects into CSV you can open in a spreadsheet.
When you need to open JSON data in a spreadsheet or share it with non-developers, CSV is the universal format. JSON to CSV flattens a JSON array of objects into rows and columns, using the object keys as the header row.
How to use json to csv
- 1. Paste a JSON array of objects.
- 2. It's converted into CSV with keys as the header.
- 3. Copy the CSV or open it in a spreadsheet.
When to use JSON to CSV
Open data in a spreadsheet
Turn JSON into CSV so it opens cleanly in Excel or Sheets.
Share with non-developers
Hand off data in a format anyone can read without tools.
Export records
Convert structured JSON into a tabular file.
How the columns are built
Every key found in any object becomes a column, in the order it first appears; an object missing a key gets an empty cell. A single object (not wrapped in a list) is accepted as one row. Values containing a comma, a quote or a line break are put in double quotes, as the CSV standard requires, so they don't break the columns.
Getting it into Excel
The output uses commas. Google Sheets splits it automatically when you paste. Excel in countries that use a comma as the decimal mark (Romania, Germany, France) expects semicolons: paste the text into column A, then use Data → Text to Columns → Delimited → Comma.
Frequently asked questions
What JSON shape does it expect?
An array of objects, where each object becomes a row and its keys form the columns.
What about nested objects?
They're flattened into columns with dotted names: {"address": {"city": "Cluj"}} becomes a column address.city. Lists are kept as JSON text in a single cell.
Is my data private?
Yes — the conversion runs in your browser.