Free JSON to Excel Converter
Paste a JSON array (or a single object), get back a real .xlsx workbook — nested fields flatten into their own columns, numbers stay numbers.
How this works
An API response or export is almost always JSON, but Excel and Power BI want rows and columns with real types. This reads your JSON, treats each object as one row, and writes a genuine .xlsx workbook — numeric fields land as real Excel numbers you can sum immediately, not text with a conversion step first.
A worked example
Paste JSON with a nested field, like {"name":"Alice","address":{"city":"Seattle"}}, and the nested value flattens into its own column named address.city automatically — a naive converter that only handles flat objects would choke on this or drop the field entirely.
What happens to my data?
Nothing is kept. It's read once to build the workbook and never stored afterward.
Questions
Is this free?
Yes, completely free, no account or signup needed.
Does the workbook have multiple sheets?
No — everything lands in one sheet named "Sheet1," same as every object you pasted.
Does it handle nested JSON?
Yes — nested objects flatten into dot-notation columns (e.g. address.city) automatically, rather than failing or dropping the field.
Is there a tool that goes the other way?
Yes — the Excel to CSV Converter and CSV to JSON Converter together cover an Excel file back to JSON.
Got your data in order? Build a dashboard from it.
Download the workbook above, upload it here, describe what you want, and get back a real, editable .pbip project — free, no Fabric or Copilot license needed.
More free tools: JSON to CSV · CSV to Excel · Excel to CSV · see all →