JSON to Excel Converter

A valid JSON input is an array of objects. Each object represents a row and the keys become column headers. For example:

[
  {
    "os": "Windows",
    "version": "11",
    "architecture": "x64"
  },
  {
    "os": "macOS",
    "version": "Tahoe",
    "architecture": "ARM64"
  }
]

The output is an Excel file (.xlsx) with column headers derived from JSON keys. Each object becomes a row. The output of the above JSON will be:

Note: You need to click the "Download" button to download the Excel file, as Excel is a binary format that cannot be copied directly.

If your JSON has empty/null, these values will be converted to empty values in the Excel output. For example:

[
  {
    "browser": "Firefox",
    "engine": null,
    "license": ""
  }
]

produces an Excel file as:

The converter collects all unique keys from all objects to create column headers. Missing values in any object will be represented as empty cells. For example:

[
  { "language": "Rust", "paradigm": "Systems" },
  { "language": "Python", "typing": "Dynamic" }
]

produces an Excel file as:

No. Excel requires flat, tabular data. Nested objects or arrays are not supported. For example, this will not work:

[
  {
    "server": "nginx",
    "config": { "port": 80, "ssl": true }
  }
]