JsonBro

JSON to CSV converter

Open a JSON document, choose CSV when you save, and you have a spreadsheet-ready file. It works in the other direction too: drop a CSV in and get JSON.

Open the editor →

How the conversion maps

An array of objects is the natural shape: each object becomes a row, each distinct key becomes a column. A single object is treated as a one-row table. Column order follows the keys as they appear.

[{ "id": 1, "name": "ada" }, { "id": 2, "name": "grace" }]

id,name
1,ada
2,grace

What it does not do

Nested values are not flattened into columns. An object or array inside a field is written into the cell as text rather than expanded into address.city style headers. If you need flat output, reshape the document first — the JSONPath panel is a quick way to pull out the array you actually want, and the tree view makes the shape obvious.

CSV to JSON

Import a .csv file by picker or drag-and-drop and it is parsed into an array of objects keyed by the header row, then formatted so you can read it. From there everything else applies: validate it, query it, diff it against another file, or save it back out as JSON.

Questions

Does the converter handle nested JSON?

It accepts it, but nested objects and arrays are written into a single cell as text rather than expanded into separate columns. Flatten or extract the array you need first if you want one column per field.

Can I convert CSV back to JSON?

Yes. Import a CSV file and it becomes an array of objects using the header row as keys.

Is my file uploaded to convert it?

No. Both directions run in your browser, and the download is generated locally.

What happens to empty or missing fields?

Rows are written with a column for every key seen in the document; where an object lacks that key the cell is empty.

Try it with your own JSON →