Convert JSON to Excel or CSV Without Losing Values

To make a table from JSON, start with an array of objects. Each object becomes a row. The union of their top-level property names becomes the column headers.

[
  { "name": "Alex", "score": 42, "team": "A" },
  { "name": "Sam", "score": 38, "team": "B" }
]

This produces columns name, score, and team, with two data rows. A nested object or array is kept as JSON text in one cell; it is not expanded into extra columns.

Choose an output

Output	Use when	Watch for
XLSX	You want a real workbook with typed safe integers and booleans	Long and decimal numbers are text to avoid rounding
CSV	You want a plain text table accepted by many apps	Importers may reinterpret dates, leading zeros, and formulas

An XLSX file is a zipped workbook package; changing a CSV filename to .xlsx does not make it one. The XLSX exporter writes formula-like strings as text and does not create executable formulas. Missing properties become blank cells; null is written as text. Inspect the workbook in the target application before sharing it.

Convert back to JSON

The Excel to JSON tool reads a local .xlsx workbook, lets you select a worksheet, and uses its first populated row for headers. Formula cells are rejected. Date-formatted numeric cells come back as their underlying spreadsheet serial values, so check the output before relying on date fields.

For comma-separated text, use CSV to JSON. It keeps every cell as a string, which preserves values such as 001 until you deliberately choose a type.