Calculator4Everyone

JSON to Excel — developer utilities, encoders and data format tools

JSON to Excel converts an array of JSON objects into a spreadsheet you can open in Excel. Because no xlsx library is available, it exports a SpreadsheetML 2003 .xls file as well as a CSV, with the keys of the first object used as the column headers.

Category: File Tools

About this tool

What Is the JSON to Excel Tool? This tool turns a JSON array into a spreadsheet you can open in Excel. It runs in your browser, so your data is never sent anywhere, and it accepts input pasted directly or loaded from a JSON file on your machine. Input A JSON array of objects, for example [{ "name": "Ali", "age": 30 }] . Keys do not have to match across objects, because they are all collected. How the Conversion Works The array is read and verified to be a list of objects. Every key from every object is collected to build the column headers. Each value is typed: numbers stay numbers, true and false become booleans, everything else is text. Nested values become JSON text inside the cell. The first ten rows are previewed and you can download xls or csv. Why Every Field Is Kept JSON data is rarely uniform: a field appears in the first record and disappears in the tenth. Collecting keys from every record guarantees that no field is lost from the table, with an empty cell where a record has no value. Cases That Do Not Work Well A single object at the top level instead of an array, which gives no table to build. Top level elements that are not objects, which appear as blank rows. Deeply nested arrays, which become a long JSON string that is hard to read. Getting the Best Result Order your keys so the table reads more easily. If the array is very large, split it into parts before conve

Browse all tools — Browse categories