Free JSON to CSV Converter

By Free JSON Tools team · Published 18 November 2026 · Updated 18 November 2026

Turn JSON data into CSV text you can open in a spreadsheet or feed to another program. Object keys become headers, each object becomes a row, and commas, quotes and line breaks are quoted correctly, free, with nothing uploaded anywhere.

Photo coming soon. A matched original photograph for this page is being sourced. The tool and guide below are complete and fully working.

CSV output

Your input never leaves this device — the conversion runs entirely in your browser.

Limits, stated plainly. Arrays of objects become rows, nested objects are flattened into columns with dotted headers, and nested arrays become JSON text in a cell. A single object becomes one row under headers taken from its keys. CSV carries no types, so numbers and true or false values appear as text, and null values leave fields empty.

What this tool does

This tool converts JSON data into comma-separated values, or CSV, following RFC 4180. Each object in a JSON array becomes one row of text, and the object keys become the headers in the first row. Fields are separated by commas, and the result is plain text.

Quoting is handled for you. A field that contains a comma, a double quote or a line break is wrapped in double quotes, and any double quote inside a field is doubled. That is the RFC 4180 rule, and it is what lets spreadsheets read the file back correctly. You do not need to escape anything by hand.

CSV is not Excel: it is plain text with no workbook, sheets, formatting or formulas. When you need a real workbook, convert to Excel instead.

The conversion runs entirely in your browser, so your input never leaves your device. Nothing is uploaded and there is no sign-up.

How to use the JSON to CSV converter

Converting JSON to CSV takes a few simple steps. No installation is needed.

  1. Paste your JSON into the input area. An array of objects works best, because each object becomes one row.
  2. Check that the JSON is valid. If there is a mistake, the tool reports the problem so you can fix the input before converting.
  3. Start the conversion and read the CSV text that appears. Headers come first, followed by one row per object.
  4. Copy the CSV text, or save it as a file with the .csv extension, and open it in your spreadsheet program or import it into the receiving system.

Paste exported JSON exactly as supplied, including the outer square brackets of an array, because the brackets mark the data as a list of rows.

Worked example

The input below holds two objects. One name contains a comma, and one note contains double quotes. Both cases need quoting in CSV.

[
  {"name": "Smith, Ana", "city": "Lisbon", "note": "Said \"hello\""},
  {"name": "Lee Bo", "city": "Porto", "note": "No extras"}
]

The CSV output quotes the fields that need it, and doubles the quotes inside the note.

name,city,note
"Smith, Ana",Lisbon,"Said ""hello"""
Lee Bo,Porto,No extras

The first name is quoted because it contains a comma, so the comma reads as part of the name, not as a separator. The word hello keeps its quotes, doubled as the rule requires. A field with a line break is quoted the same way, with the break kept inside the quotes.

Rules and edge cases

Headers come from the object keys, in the order the keys are found. When objects use different keys, the headers cover the keys found, and objects without a given key leave that field empty. Key names are used exactly as written, including capital letters.

Nested objects are flattened into columns, with the path shown in the header, such as buyer.city. Nested arrays become JSON text inside a single CSV field, quoted as needed, so the data is kept in one cell. A single JSON object on its own becomes one row under headers taken from its keys.

Numbers and true or false values appear as text, because CSV has no types. A null value leaves the field empty. An empty array has no rows to convert.

If the same key appears twice in one object, only the last value is used, because that is how JSON parsing works. Invalid JSON is reported as an error rather than converted, so fix the reported problem and try again.

Common mistakes

Most CSV problems come from treating the output as a workbook, or from building CSV by hand without quoting. The cases below cover the mistakes seen most often.

When to use CSV, and when to choose something else

Use CSV when the receiving program expects plain text rows: spreadsheet imports, database loads, and data exchange between systems that do not share a format. CSV files are small, simple, and readable almost everywhere.

Use Excel when the receiver works in spreadsheets and needs a workbook that opens directly, with no import step. Use a table view when you only want to look at the data once, without producing a file. Keep JSON when the data feeds code or an application programming interface, because JSON preserves types and nesting that CSV flattens to text.

Remember that CSV forgets types: numbers, dates and true or false values all become text. Convert to CSV for exchange and review, and keep the JSON original as the source of truth.

Frequently asked questions

Is CSV the same as an Excel file?

No. CSV is plain text with rows separated by line breaks and fields separated by commas. An Excel file is a workbook with sheets and structure. Use the Excel converter when you need a real .xlsx file.

How are commas and quotes handled?

Following RFC 4180, a field containing a comma, a double quote or a line break is wrapped in double quotes, and double quotes inside the field are doubled. Spreadsheets then read the fields back correctly.

What happens to line breaks inside values?

The field is wrapped in double quotes and the line break is kept inside the quotes. A spreadsheet reading the CSV correctly keeps the break as part of the value, not as a new row.

What happens to nested objects and arrays?

Nested objects are flattened into columns, with headers showing the path, such as buyer.city. A nested array becomes JSON text inside a single CSV field, quoted as needed. Nested values do not become extra rows or sheets.

What if my JSON is a single object, not an array?

A single object becomes one row under headers taken from its keys. For several rows, wrap the objects in square brackets to form an array, with commas between the objects.

Why does my spreadsheet show everything in one column?

The spreadsheet may be using a different separator. Use its text import option and choose comma as the separator, with double quote as the text qualifier, and the columns should split correctly.

Is my data uploaded anywhere?

No. The conversion runs in your browser on your own device. Your input is never sent to a server, and there is no sign-up or account.

Related tools and guides

Sources

Share:
Disclaimer: The tools and guidance on this page are for general use. Tools run entirely in your browser and your input never leaves your device. Always keep a backup of important data before converting or editing it.