Home › File & PDF Tools › JSON to CSV Converter

JSON to CSV Converter

Our free JSON to CSV converter turns a JSON array of objects into a clean CSV file you can open in Excel or Google Sheets. Paste your JSON, click Convert, and download the result — all in your browser, with no sign-up and no upload.

How it works

JSON and CSV are two ways of writing the same table. JSON writes each row as an object with named keys, like {"name":"Ana","age":30}, while CSV writes the same table as plain lines separated by commas, with the first line naming the columns. This tool translates between the two without changing your data.

First, it parses your JSON. If the text is not valid JSON — a missing bracket, a trailing comma, or a single quote where JSON needs a double quote — it stops and shows the exact error message from the parser, so you can find and fix the mistake.

Second, it checks the shape. It needs an array of objects, because a CSV is a table and each object is one row. If you paste a single object, a list of plain numbers, or an empty array, it explains what is wrong instead of producing an empty file.

Third, it builds the header from every key it finds, in the order each key first appears, and writes one CSV line per object. Missing values become empty cells, and nested objects or arrays are written as compact JSON text inside the cell.

Escaping matters. A value like Smith, John would break a CSV if it were written bare, because the comma would look like a column break. The tool wraps such values in double quotes, and doubles any quote inside a value — so Say "hi" becomes "Say ""hi""". That is the standard rule that Excel and Google Sheets expect, and it is why files from this tool open cleanly.

Worked example

Paste this JSON into the tool:

[{"name":"Ana","age":30},{"name":"Ben","age":25}]

Step 1: the parser reads a valid array with two objects. Step 2: the header is built from the keys, in first-seen order: name,age. Step 3: each object becomes one row — Ana’s row is Ana,30 and Ben’s row is Ben,25.

The full CSV output is:

name,age
Ana,30
Ben,25

That is a header plus two data rows, three lines in total. Click “Download CSV” and you get a file called converted.csv with exactly that content, ready to open in Excel. The sample button loads a slightly bigger example with four customers, including one whose city contains a comma, so you can see the quoting rule in action.

When to use a JSON to CSV converter

Developers use it to turn API responses into spreadsheets they can share with a non-technical team. A list of orders, customers, or products that comes back from an API as JSON becomes a CSV that anyone can sort and filter in Excel.

Shop owners and analysts use it the other way around in their workflow: export data from a tool as JSON, convert it here, and hand the CSV to an accountant or a manager who works in spreadsheets all day. Because the conversion never uploads your data, customer names and order totals stay on your own computer.

One caution: CSV has no data types, so a leading zero in a ZIP code like 02101 can disappear when Excel opens the file, because Excel reads it as the number 2101. If your data has ZIP codes, phone numbers, or IDs with leading zeros, import the CSV through Excel’s Text Import wizard and mark those columns as Text.

FAQ