JSON to Excel on Mac — Free Browser Tool (No Python, No Office)

Converting JSON to Excel on a Mac is free and takes about 30 seconds — no Python environment, no Microsoft Office license, and no additional software to install. The converter runs entirely in your browser (Safari or Chrome), reads your JSON locally, and downloads a formatted .xlsx spreadsheet directly to your Downloads folder.

Three Ways to Get Your JSON Into Excel on Mac

Method 1 (Easiest): Browser tool, no install. Open wildandfreetools.com/spreadsheet-tools/json-to-excel/ in Safari or Chrome. Paste your JSON array or drop your .json file. Download the .xlsx file to your Mac. Open in Numbers, Excel, or LibreOffice.

Method 2: Python (if you already have it). macOS comes with Python 3 pre-installed. The pandas library handles this well:

import pandas as pd
import json

with open('data.json') as f:
    data = json.load(f)

df = pd.DataFrame(data)
df.to_excel('output.xlsx', index=False)

This requires pandas to be installed (pip3 install pandas openpyxl). The browser tool is faster for one-off conversions because there is no setup required.

Method 3: Microsoft Excel for Mac (with Power Query). If you have Microsoft 365, Excel for Mac supports Power Query. Go to Data > Get Data > From File > From JSON. This builds a queryable connection rather than a one-time export. Useful if you want the data to refresh automatically.

This Tool Runs in Your Mac Browser — Safari, Chrome, Both Work

A common question from Mac users: does this require downloading a Mac app? No. The converter is a web tool that runs JavaScript in your browser — the same kind of processing your browser already does for countless other tasks.

Safari on macOS works well. Chrome on macOS works well. Firefox works too. The tool uses the Web Workers API for processing so it does not freeze your browser tab during conversion.

When you download the .xlsx file, it goes to your Mac's Downloads folder by default (the same place as any other browser download). You can then open it with:

• Numbers — Apple's free spreadsheet app, pre-installed on most Macs. Handles .xlsx files natively.
• Microsoft Excel for Mac — if you have an Office or Microsoft 365 subscription.
• LibreOffice Calc — free, open source, available at libreoffice.org.
• Google Sheets — upload the .xlsx to Google Drive and open it there.

Sell Custom Apparel — We Handle Printing & Free Shipping

How Nested JSON Converts on Mac

The conversion behavior is identical regardless of whether you run it on a Mac, Windows, or Linux machine — it all runs in the browser. For nested JSON structures like:

[
  {"user": {"name": "Alice", "role": "admin"}, "score": 95}
]

The nested object is flattened to dot notation: columns will be user.name, user.role, and score. This matches the behavior you would get from Python's pandas json_normalize function.

For JSON files with deeply nested arrays (more than 2 levels), the nested arrays are stringified into cells. If you need to expand those, the manual approach is to use Numbers or Excel's built-in JSON import functionality after conversion.

Browser Tool vs Python: What to Use on Mac

Scenario	Browser Tool	Python
One-off conversion	Faster — no setup	Requires pandas install
Repeated conversions of same structure	Paste each time	Script runs with one command
Very large files (>100MB)	May hit browser memory limit	Better for big files
Privacy (sensitive data)	Local only — same privacy as Python	Local only
Non-technical users	No install, zero configuration	Requires terminal knowledge

For most Mac users who need JSON data in a spreadsheet occasionally, the browser tool wins on speed — from "I have this JSON" to "I have an Excel file" takes about 30 seconds with no setup. For developers who automate this as part of a workflow, Python is more appropriate.

Frequently Asked Questions

Does this work on an M1 or M2 Mac?

Yes — since it runs in the browser, it works on all Mac hardware including Apple Silicon (M1, M2, M3). There is no native binary to install, so the ARM vs Intel distinction does not apply.

I have a .json file on my Mac — can I just drop it in rather than pasting?

Yes. The tool has a drag-and-drop zone. Drag your .json file from Finder directly into the browser tab's drop zone, and it will load and convert automatically.

My Mac does not have Microsoft Excel. Can I still open the .xlsx file?

Yes. Numbers (pre-installed on most Macs) opens .xlsx files natively. LibreOffice Calc is a free alternative. You can also upload the .xlsx to Google Drive and open it in Google Sheets without any install.

Is there a row limit for the conversion?

No hard limit — the tool uses available browser memory. Tens of thousands of rows work fine on modern Macs. For files over 50MB, Chrome typically handles large JSON better than Safari, so switch browsers if you run into issues.