JSON to Excel (.xlsx) Converter — Free, In-Browser
Convert JSON arrays of objects into an Excel spreadsheet. No nesting flattening—nested data becomes text. Client-side, no upload.
JSON to Excel Converter
Files never leave your browserYou're on 7BusyBoss — 300+ free tools that run instantly in your browser. No signup, nothing uploaded.
Turn a JSON array into a spreadsheet grid
JSON is a tree; Excel is a grid. This tool treats your JSON array as rows, derives column headers from object keys, and stringifies anything nested.
Example:
[
{ "name": "Ada Lovelace", "role": "Engineer", "years": 3 },
{ "name": "Alan Turing", "role": "Director", "years": 5 }
]produces three columns — name, role, years — and two data rows. Object keys become headers, in order. Any row missing a key shows a blank cell.
Array of objects only; nested data becomes text
Input must be a JSON array of objects: [{...}, {...}]. A bare object or NDJSON will error. Each object's keys determine columns; if rows differ, Excel creates all columns and leaves blanks where keys don't exist. Nested objects and arrays like {"address": {"city": "London"}} are converted to text strings, not flattened. This keeps conversion predictable: no guessing at schema depth.
One file, one sheet, no formatting
Output is converted-from-json.xlsx — a single sheet named Sheet1 with raw data only. No formulas, styling, or multi-sheet output. Uploaded files are capped at 5 MB; split anything larger before converting. Reverse the conversion with Excel to JSON, or export as CSV for other tools.
What this tool does not do
Nested structures are never unpacked into columns — sub-objects become cell text. There is no correct way to flatten {"address": {"city": "London", "postcode": "SW1A1AA"}} without guessing your schema. Reshape inside Excel after conversion if needed. No formulas, no styling, no multi-sheet — this is a data mover, not a designer.
How to use the JSON to Excel Converter
Takes about a minute. No signup, no download, your data stays in your browser.
- 1Open the tool. Scroll up to the JSON to Excel Converter above — it loads instantly in your browser, no install needed.
- 2Enter your values. The fields come pre-filled with realistic defaults so you can see how it works — replace them with your own numbers.
- 3Read the result. The output updates instantly. Copy or share it — nothing is uploaded to a server, everything stays on your device.
Frequently asked questions
Common questions about the JSON to Excel Converter.
Can I convert a single JSON object (not an array)?
No. The tool expects a top-level array of objects and rejects anything else with "Expected a JSON array of objects." If you have one record, wrap it in square brackets so it becomes an array of one, and it converts to a single row. An API response that nests the array under a key needs that inner array pasted on its own.
What happens to nested objects and arrays in my JSON?
They are converted to text and land in a single cell rather than being split across columns. A user field holding another object arrives in Excel as its JSON text, quotes and braces included. If you need those inner values in their own columns, flatten the structure before converting — the tool will not guess how deep your schema goes.
What if my JSON rows have different keys?
Excel creates a column for every unique key found. Rows missing a key show blank cells in that column. First-row keys set initial order; new keys append to the right.
How large a JSON file can this handle?
Uploaded .json files are capped at 5 MB and anything larger is rejected before conversion. Pasting text directly has no fixed cap, but the whole parse and workbook build happen in the browser tab, so very large payloads are limited by available memory. For big datasets, split the array into chunks, convert each, and combine the sheets in Excel.
Community rating
Discussion (0)
No comments yet. Start the discussion.
Keep exploring
Related tools across 7BusyBoss — all free, all instant.