Convert a JSON Array to Excel Columns (Step-by-Step)

Last updated: 6 June 2026

The most common JSON shape is an array of objects - a list where each item has the same kind of fields. That maps perfectly onto a spreadsheet: each object becomes a row, and each field becomes a column. This guide shows exactly how that mapping works so your Excel output looks the way you expect.

The basic mapping

Given [ { "name": "Ada", "age": 30 }, { "name": "Linus", "age": 41 } ], you get a sheet with columns name and age and one row per object. Object keys become the header row; values fill the cells.

Nested fields become dotted columns

When an object contains another object, the default Separate columns mode flattens it into dotted headers, for example address.city and address.zip. Choose JSON in one cell instead to keep the whole nested object as JSON text in a single column.

Lists inside a row

A field that holds a list of simple values (for example tags: ["a", "b"]) becomes a single comma-separated cell: a, b. A field that holds a list of objects is kept as JSON text in one cell, so one input object always stays one spreadsheet row.

Different keys across objects

Real data is rarely uniform. If some objects have keys others don't, the converter builds the column set from the union of all keys and leaves cells blank where a value is missing - so nothing is dropped.

Convert it

Paste your JSON array, or drop a .json file (up to 15 MB).
Preview the columns and rows.
Download the .xlsx and open it anywhere.

It's free, needs no signup, and runs entirely in your browser. Tip: keep long numeric IDs as quoted strings so they stay exact in Excel.

Related guides

See all guides or the FAQ.

Open the free JSON to Excel converter →