Map Extract
Free tool

Convert JSON to an Excel spreadsheet

Paste or open a JSON file and download an .xlsx workbook. Each object becomes a row, nested fields are flattened into named columns, and values such as phone numbers stay exactly as they were.

Runs in your browser. Nothing you enter is uploaded.

Who this is for

JSON is how most web services and automation tools pass data around, and it is unreadable to anyone who just wants to scan a list. If a developer, an integration or a data tool has given you JSON and the person who needs it works in Excel, this turns one into the other without a script.

It skips the CSV step on purpose. Going JSON to CSV to Excel means Excel guesses the column types when it opens the CSV, and phone numbers lose their leading zero. Writing the .xlsx directly lets the converter decide: numbers that are safe become numbers, everything else stays as text.

Converting

  1. Paste or open the JSON

    Paste an array of objects, or press Open a file and choose a .json file.

  2. Name the sheet

    Enter a sheet name of up to 31 characters. The file downloads with the same name.

  3. Keep numbers as numbers

    Store numbers as numbers is on by default; leading zeros stay as text either way. Turn it off for an all-text sheet.

  4. Download the workbook

    The note shows the number of rows and confirms the header row will be bold. Press Download .xlsx.

An API response for a colleague

Two records with a nested contact object and a list of tags, as an enrichment service or an internal tool might return them.

The sheet gets one column per key found, with nested keys flattened to contact.email and contact.phone and the tags joined in one cell. The phone number 01632960410 is kept as text, and the 4.6 rating becomes a numeric cell. If the JSON has a syntax error, the error appears instead of the download button, with the position of the problem.

Input
[
  {"business": "Kiln & Co Pottery", "contact": {"email": "[email protected]", "phone": "01632960410"}, "tags": ["pottery", "workshops"]},
  {"business": "Marlow Print Works", "rating": 4.6}
]
Result
Sheet1.xlsx
business | contact.email | contact.phone | tags | rating
Kiln & Co Pottery | [email protected] | 01632960410 | pottery; workshops |
Marlow Print Works | | | | 4.6

Before you send the workbook on

  • Remove fields the reader does not need, such as internal IDs or raw HTML, from the JSON first.
  • Check columns that hold lists; they are joined into one cell and may need splitting.
  • Give the sheet a name that says what it is, such as Frome stockists, not Sheet1.
  • Open the file once yourself and confirm phone numbers and dates look right.

Questions people ask

How do I open a JSON file in Excel?

Convert it to .xlsx first. Paste the JSON or open the file here, press Download .xlsx, and open the result in Excel like any workbook. Each record becomes a row with its fields as columns, so there is no need for Power Query or a script to read the JSON.

What JSON structure does it accept?

An array of objects works best, one object per row. A single object is turned into a one-row sheet. Nested objects are flattened into dotted column names, and lists of simple values are joined with semicolons. JSON with a top-level object that wraps the array needs the array copied out first.

Is there a size limit?

No fixed limit is set. Conversion uses your browser's memory, so files of a few megabytes are quick and very large files depend on your device. Excel itself has a limit of 1,048,576 rows per sheet, so anything bigger needs splitting before you convert it.

Will dates be converted to Excel dates?

No. Dates are written as the text they are in the JSON, such as 2026-11-10, so nothing is reinterpreted by locale. Excel can turn a text column of ISO dates into real dates with its Text to Columns or DATEVALUE features if you need to sort or calculate with them.

Where your data goes

Everything happens in this browser tab: the JSON is read and the workbook is written locally. No data is uploaded to Map Extract.

Checked against the tool on

Top