Json To Csv
Convert JSON data into a spreadsheet ready CSV file, turning an array of objects into rows and columns. No signup. Ideal for opening JSON data in Excel or Sheets.
Result
| CSV |
|---|
Share on Social Media:
A JSON to CSV converter turns JSON data into a spreadsheet-ready CSV file — free, with no account, right in your browser. Paste an array of JSON objects, click Convert to CSV, and each object becomes a row and each field a column, with the field names as the header row. Then copy the result and paste it into Excel, Google Sheets, or a text file saved as .csv. Your JSON is converted in your browser and never uploaded or stored.
On this page
- How to Convert JSON to CSV Step by Step
- What CSV Is and Why It Pairs With Spreadsheets
- JSON Versus CSV for Tabular Data
- Worked Example: Three People to a Spreadsheet
- Who Converts JSON to CSV
- Pro Tips for Clean JSON to CSV Conversion
- Common JSON to CSV Mistakes to Avoid
- Related Tools You May Need Next
- Frequently Asked Questions
How to Convert JSON to CSV Step by Step
- Paste your JSON. Paste or type an array of objects into the box above — for example
[{"name":"Alice","age":30},{"name":"Bob","age":25}]. It works best when every object has the same fields. - Click Convert to CSV. One click reads the objects, uses the field names as column headers, and turns each object into a row.
- Check the columns. Confirm the header row lists the fields you expected. If your objects have different fields, the converter includes every field as a column and leaves blanks where an object lacks one.
- Copy the result. Click the Copy to Clipboard button next to the result — there is no download button on this page, so copying is how you take the CSV away.
- Paste it where you need it. Paste into Excel or Google Sheets to open it as a table, or into a text editor and save the file with a
.csvextension. - If it says “Invalid JSON”, fix the error in your JSON — usually a missing bracket, a trailing comma, or single quotes — and convert again. An empty box or an empty array
[]shows “Invalid Input”.

What CSV Is and Why It Pairs With Spreadsheets
CSV, comma separated values, is the simplest and most universal format for tabular data. Each line is a row, and within a line, commas separate the values into columns. The first line usually holds the column headers. This plain-text simplicity is CSV’s strength: virtually every spreadsheet program, database, and data tool can read and write it, making CSV the common language for moving tabular data between systems.
JSON and CSV represent data very differently. JSON is hierarchical, built from nested objects and arrays, ideal for structured data with relationships and varying shapes. CSV is flat — a simple grid of rows and columns with no nesting. That difference is why conversion is needed: data often arrives as JSON from an API or program, but people want to work with it in a spreadsheet, which speaks CSV.
| What the tool does | How it does it |
|---|---|
| Takes JSON one way | Paste or type it into the box above — no file upload, no URL load |
| Turns objects into rows | Each object in the array becomes one CSV row |
| Turns fields into columns | Field names become the header row, always included |
| Handles uneven objects | Uses every field from every object as a column; missing fields become empty cells |
| Handles nulls | A null value becomes an empty cell |
| Quotes tricky values | Values with a comma, quote, or line break are wrapped in double quotes, with quotes inside doubled |
| Keeps your data private | Conversion runs in your browser; nothing is uploaded or stored |
| Gives you the result | On-screen CSV with a Copy to Clipboard button — no download button |
JSON Versus CSV for Tabular Data
| Aspect | JSON | CSV |
|---|---|---|
| Structure | Hierarchical, nested | Flat, rows and columns |
| Best for | Structured data, APIs | Spreadsheets, tabular data |
| Opens in Excel | Not directly as a table | Yes, natively |
| Handles nesting | Yes | No — nested data must be flattened first |
| Readability for tables | Verbose | Clean and compact |
| File size for the same table | Larger | Smaller |
Flat arrays of objects convert cleanly. JSON that is an array of objects sharing the same fields maps perfectly to rows and columns. Deeply nested JSON does not, because a CSV table is flat with no nesting — and this converter does not flatten it for you (see the worked example below). The simpler and flatter your JSON, the cleaner the resulting CSV.
Worked Example: Three People to a Spreadsheet
Paste this JSON — 135 characters:
| Line | JSON line |
|---|---|
| 1 | [{"name":"Alice","age":30,"city":"New York"},{"name":"Bob","age":25,"city":"San Francisco"},{"name":"Carol","age":28,"city":"Chicago"}] |
Click Convert to CSV and you get 4 lines, 69 characters:
| Line | CSV line |
|---|---|
| 1 | name,age,city |
| 2 | Alice,30,New York |
| 3 | Bob,25,San Francisco |
| 4 | Carol,28,Chicago |
The first line is the header row — name, age, city — taken from the field names, in the order they first appear. Each object became one row. The CSV is shorter than the JSON (69 characters against 135) because it drops the brackets, braces, quotes around keys, and repeated field names. Paste it into Google Sheets or Excel and it opens as a three-row table with three columns.
What happens to tricky values — all verified with the tool’s real behaviour:
| Input value | What comes out | Why |
|---|---|---|
| A field missing from one object | An empty cell | The header is the union of all fields; {"name":"Bob","city":"Paris"} gives Bob,,Paris |
null | An empty cell | null converts to nothing; 0 and false stay as 0 and false |
A value with a comma, like Doe, Jane | "Doe, Jane" | Wrapped in double quotes so the comma is not read as a column break |
A value with quotes, like She said "hi" | "She said ""hi""" | Quotes inside are doubled, per CSV rules |
A nested object, like {"city":"New York","zip":"10001"} | [object Object] | The converter does not flatten nesting — the data is lost, so flatten it first |
A nested array, like ["red","blue"] | "red,blue" | Joined into one quoted cell; the array structure is lost |
| A single object, not an array | One row | {"name":"Alice","age":30} converts to name,age / Alice,30 |
Invalid JSON, like [{"name":"Alice",}] | “Invalid JSON” message | Fix the error and convert again |
An empty array [] | “Invalid Input” message | There are no rows to convert |
Who Converts JSON to CSV
Data analysts. Receiving JSON from an API and converting it to CSV to open in a spreadsheet, where they can sort, filter, chart, and analyse it with familiar tools.
Non-technical colleagues. Converting JSON a developer gave them into CSV so they can work with the data in Excel rather than reading raw JSON.
People importing data. Needing to import data into a system that accepts CSV, converting JSON into the format the system expects.
Researchers handling datasets. With JSON-formatted data, converting it to CSV to load into statistical or spreadsheet software for analysis.
Anyone moving data to a spreadsheet. With data in JSON but wanting it as a spreadsheet, converting it to CSV, the format spreadsheets open natively and cleanly.

Pro Tips for Clean JSON to CSV Conversion
Use a flat array of objects for best results. The cleanest conversion comes from JSON that is an array of objects all sharing the same fields. If you can shape your JSON this way before converting, the resulting CSV will be tidy.
Flatten nested data first. Nested objects come out as [object Object] and nested arrays collapse into one cell, so pull nested fields up into flat fields — for example {"city":"New York"} instead of {"address":{"city":"New York"}} — before you convert.
Make the fields match. If every object has the same fields, there are no empty cells. Check the header row after converting: an unexpected column usually means one object had an extra field.
Copy, don’t retype. Use the Copy to Clipboard button so the CSV moves into your spreadsheet exactly as shown, with no typing mistakes — and remember there is no download button, so copying is the way to save it.
Paste into a spreadsheet to verify. After converting, paste the CSV into Excel or Google Sheets and confirm the columns and rows are as expected, catching any fields that ended up blank or combined unexpectedly.
Convert back with the CSV to JSON tool. If you need to go the other way, the CSV to JSON tool reverses the conversion, turning spreadsheet data back into JSON for a program.
Check your JSON first if it fails. If the tool says “Invalid JSON”, paste the JSON into the JSON Validator to find the error before converting again.
Common JSON to CSV Mistakes to Avoid
Expecting nested JSON to convert cleanly. A CSV table is flat and cannot represent nesting directly, and this converter does not flatten it — a nested object becomes [object Object] and its data is lost. For a clean table, flatten or simplify your JSON to an array of flat objects first.
Pasting a list of plain values. [1,2,3] has no fields, so it produces empty lines with no error message. The input must be an array of objects, not an array of numbers or strings.
Providing JSON that is not an array of objects — and assuming it fails. A single object actually converts fine (it becomes one row), so do not reshape it first; only arrays of plain values are a problem.
Ignoring inconsistent fields. If the objects have different fields, some rows will have blanks where a field is missing. This is handled, but be aware the table may have gaps, which is expected when the source objects are not uniform.
Looking for a download button. There is none on this page. Copy the result with the Copy to Clipboard button, then paste it into your spreadsheet or a text editor and save it as .csv.
Forgetting that null becomes blank. A null value comes out as an empty cell, which is not the same as the text null. If the distinction matters, replace null with a word like none before converting.
Forgetting to check commas in data. Values that themselves contain commas are quoted automatically, so a value like Doe, Jane stays in one column — but verify it opened correctly in your spreadsheet, especially if you pasted into a plain text file first.
Related Tools You May Need Next
CSV to JSON. Convert the other way, turning spreadsheet data back into JSON.
JSON Validator. Check your JSON is valid before converting, with the errors shown.
JSON Formatter. Tidy messy or minified JSON so you can read its structure before converting.
JSON Minify. Shrink JSON to the smallest one-line form.
JSON Viewer. View JSON as a collapsible tree.
JSON Beautifier. Beautify JSON for readability.
JSON Editor. Edit JSON in code, form, text, or tree mode.
JSON to XML. Convert the same JSON into XML instead of CSV.

Frequently Asked Questions
How do I convert JSON to CSV?
Paste your JSON — ideally an array of objects that share the same fields — into the box above and click Convert to CSV. The tool uses the field names as column headers and turns each object into a row. Then click Copy to Clipboard and paste the result into Excel, Google Sheets, or a text file saved as .csv.
Is this JSON to CSV converter free?
Yes. It is completely free with no account and no signup, and it runs entirely in your browser, so your data is processed locally and there is nothing to download or install. Nothing is uploaded to a server or stored — closing the page discards your JSON.
Can I download the CSV as a file?
There is no download button on this page. Click Copy to Clipboard next to the result, then paste it into a text editor and save the file with a .csv extension, or paste it directly into Excel or Google Sheets.
What kind of JSON converts best to CSV?
JSON that is an array of objects, where every object has the same fields, converts most cleanly, because this flat, uniform structure maps directly onto rows and columns. Each object becomes a row and each field a column. The simpler and flatter your JSON, the tidier the resulting CSV.
What happens to nested JSON when converting to CSV?
It is not flattened. A nested object becomes the literal text [object Object], so its data is lost, and a nested array becomes comma-joined text in a single cell, like "red,blue". For the cleanest result, flatten nested fields into plain fields — for example {"city":"New York"} instead of {"address":{"city":"New York"}} — before converting.
What if my JSON objects have different fields?
The converter handles objects with differing fields by including all the fields as columns and leaving blanks where a particular object lacks a field. This means the resulting table may have some empty cells, which is expected when the source objects are not uniform. If you need a clean table with no gaps, ensure all your objects share the same fields before converting.
What if my JSON is invalid?
The tool shows an “Invalid JSON” message and no result. The most common causes are a missing bracket or brace, a trailing comma, single quotes instead of double quotes, or unquoted keys. Fix the error — the JSON Validator can help find it — and click Convert to CSV again. An empty box or an empty array [] shows “Invalid Input” instead.
Can I convert a single JSON object, not an array?
Yes. A single object converts to a one-row CSV with its field names as the header — {"name":"Alice","age":30} becomes name,age followed by Alice,30.
Will values with commas break the CSV?
No. A value that itself contains a comma is enclosed in double quotes so it is not mistaken for a column break — Doe, Jane becomes "Doe, Jane" — and quotes inside a value are doubled. After converting, it is still worth opening the CSV in a spreadsheet to confirm the columns align correctly.
Can I convert CSV back to JSON?
Yes. If you need to go the other way, from spreadsheet data back to JSON for a program or API, the CSV to JSON tool reverses the conversion, turning each row into an object with the column headers as field names.