JSON to CSV Converter

Frequently asked questions

What JSON shape does this expect?

An array of objects, for example [{"name":"Ada","age":36}]. The header row is the union of every key across all objects, so rows with missing keys still line up. Values with commas or quotes are escaped automatically. A single object is treated as a one-row array.

What happens to nested objects or arrays in the JSON?

Nested values (objects or arrays within a field) are serialized as their JSON string representation inside the CSV cell. For example, {"tags":["a","b"]} becomes the string ["a","b"] in the cell. If you need the nested data flattened into separate columns, flatten the JSON before pasting it here.

Why does the downloaded CSV open with garbled characters in Excel?

Excel sometimes misreads UTF-8 files that lack a byte order mark. The downloaded file includes a UTF-8 BOM so Excel automatically detects the encoding and displays accented or non-Latin characters correctly. If you open the file in a text editor it may show a small invisible character at the start; this is normal.

Can I convert a large JSON file with thousands of rows?

Yes. Conversion happens in your browser using a JavaScript library, so there is no server-side size limit. Very large files may take a few seconds and use more browser memory. If the tab freezes, try splitting the JSON into smaller batches and converting each separately.