JSON to Table

Convert JSON to a real Excel (.xlsx) spreadsheet — paste your data or drop a .json file. Nested objects and arrays are auto-flattened into clean columns.

📁 Drop a .json file here, or click to browse — or paste JSON below

About this tool

Convert JSON to Excel Online

Need to convert JSON to Excel without writing a script? Paste a JSON array or object above, preview the rows, and download a real .xlsx spreadsheet in seconds. The converter works with API responses, exported records, configuration data, and JSON files.

Turn JSON Into a Real Excel File

This JSON to Excel converter generates an actual .xlsx workbook — not a CSV file renamed with an Excel extension. It opens cleanly in Microsoft Excel, Google Sheets, and Numbers, with each JSON key becoming its own column. Everything runs client-side in your browser, so your data is never uploaded to a server.

How Nested Data Is Handled

Real-world JSON is rarely flat. This tool automatically flattens nested objects into dot-notation columns — a field like address.city becomes its own column with the nested value — and joins nested arrays into a single readable cell, so you still get one clean row per record instead of a broken or truncated sheet.

When You'd Use This

How to Convert JSON to Excel

  1. Paste JSON into the input box or upload a .json file.
  2. Keep Flatten nested objects enabled for spreadsheet-friendly columns such as customer.name.
  3. Click Preview to check the rows and columns.
  4. Click Download .xlsx to save the Excel workbook.

Does this create a real Excel file?

Yes — it generates a genuine .xlsx workbook (not a renamed CSV) that opens directly in Excel, Google Sheets, or Numbers with proper columns and data types.

What happens to nested JSON objects and arrays?

Nested objects are automatically flattened into dot-notation columns (e.g. address.city), and nested arrays are joined into a single readable cell, so the sheet stays flat and Excel-friendly.

Is my JSON data uploaded anywhere?

No — the conversion happens entirely in your browser using JavaScript. Nothing is sent to a server.

Can I convert an API response to Excel?

Yes. Copy the JSON response from your API, paste it into the converter, preview the records, and download them as a spreadsheet. JSON arrays become rows and object keys become columns.

Can I convert Excel back to JSON?

This page converts JSON to Excel. For the reverse direction, use the CSV ⇄ JSON converter after saving your spreadsheet as CSV.

Related Tools

More Data Conversion Tools

CSV ⇄ JSONJSON to TypeScriptYAML ⇄ JSONXML BeautifierJSON Diff CheckerJSON Formatter

Learn how nested arrays and objects become spreadsheet rows in the JSON to Excel Guide.