JSON to Excel converter
See JSON data as a readable Excel table, on your own device.
or drop them here, or paste them
Nothing is uploaded.
About JSON to Excel
Data exported from apps and websites often comes as JSON, which is hard to read for anyone who isn't a developer. This converter lays it out as a spreadsheet: each item becomes a row and each field a column.
It expects a list of items, or an object that contains one. Nested values, such as lists inside an item, are written into their cell as text so nothing is lost. Everything happens in your browser.
The column headings come from the field names, and every field that appears in any item gets its own column, so no data goes missing when items differ. Items without a field just leave that cell empty. Numbers and true or false values keep their type, so you can calculate with them straight away.
You get an ordinary Excel workbook, which Google Sheets, Numbers and LibreOffice open too. If the file isn't valid JSON, for example because a comma or bracket is missing, you get a clear message instead of an empty sheet. Your data never leaves your device.
Questions and answers
A list of objects, such as [{"name": "Anna"}, {"name": "Jan"}], or an object that holds such a list. Each object becomes one row.
Values that are themselves lists or objects are written into their cell as JSON text, so you can still see everything.
It may not be valid JSON, or it may hold a single value rather than a list. Check it in a JSON validator or text editor.