Dev Tool

JSON to CSV Converter

Convert JSON arrays to CSV format instantly. Auto-detects headers from JSON keys. Also converts CSV back to JSON.

JSON → CSV

CSV → JSON

📋 Input JSON

📊 CSV Output

Frequently Asked Questions

What does JSON to CSV do?

JSON to CSV converts JSON arrays into comma-separated values format, making JSON data compatible with spreadsheet applications like Excel and Google Sheets. Each JSON object in the array becomes a row, and each key becomes a column header.

Does it handle nested JSON?

The converter flattens one level of nesting. For deeply nested JSON structures, nested objects are serialised as string representations in the CSV cells. For complex nested data, you may need to pre-process the JSON before converting.

Is the converter free?

Yes — completely free, runs entirely in your browser, no data is sent to any server, no signup required.

What JSON format does this support?

Arrays of objects — the most common API response format. Each object should have the same keys which become the CSV column headers. Nested objects are flattened with dot notation.

How are special characters handled?

Values containing commas, quotes or newlines are automatically wrapped in double quotes per RFC 4180. Existing double quotes are escaped as two consecutive double quotes.

Can I convert back from CSV to JSON?

Yes — use the CSV → JSON tab. The first row is treated as headers and each subsequent row becomes a JSON object.

Turning JSON into a spreadsheet

CSV is the simplest way to open data in Excel, Google Sheets or a database import. This converter takes a JSON array of objects, uses the keys as column headers and turns each object into a row. It also works the other way, from CSV back to JSON.

What converts cleanly

Flat arrays of objects such as [{"name":"Ann","age":31},{"name":"Bo","age":27}] map directly to columns and rows.
Objects with different keys are common in API data. The result should have a column for every key, with empty cells where an object has no value. Check this before you import the file.

What needs care

Nested objects and arrays. CSV has no nesting, so a value like {"address":{"city":"Oslo"}} should be flattened first, for example into an address.city column. Otherwise it ends up as text in a single cell.
Commas, quotes and line breaks inside values. These must be wrapped in double quotes, with any inner quotes doubled, or the columns shift.
Leading zeros and long numbers. Spreadsheets turn 00123 into 123 and long IDs into scientific notation. Import those columns as text.
Character encoding. If accented letters look broken in Excel, import the file as UTF-8 instead of double-clicking it.

Before you convert

Check the JSON first with the JSON formatter, because a single syntax error stops the conversion. For the opposite direction with custom delimiters, use CSV to JSON.