Spreadsheet tools Free · No sign-up · No upload

Convert JSON to Excel

Paste or open JSON and get a spreadsheet with one column per key and one row per object. Nested fields can spread across columns, and nothing leaves your browser.

  • Free, no sign-up
  • Data never leaves your device
  • Nested keys flattened
  • XLSX, XLS, ODS or CSV
JSON
  • Runs on your device. Files are never uploaded.
  • Free and unlimited. No sign-up, no watermark.
Private: processed in your browserNo upload waitIN: JSON → OUT: XLSX
How was JSON to Excel?
How it works

JSON to Excel in three steps

No account, no email, no waiting for an upload.

  1. STEP 01

    Paste or open JSON

    Type or paste into the box, or open a .json, .jsonl or .ndjson file. A list of objects works best.

  2. STEP 02

    Pick the output

    Choose XLSX, XLS, ODS or CSV. Leave nested objects spread across columns, or turn that off.

  3. STEP 03

    Download the sheet

    Open the file in Excel. Column widths are set so the text is readable straight away.

What you get

What JSON to Excel does, and what it doesn't

We'd rather tell you up front than surprise you after the download.

What you get

  • One column per keyKeys from all objects are collected in the order they first appear, so objects with missing fields still line up.
  • Nested objects flattenedA field like address.city gets its own column. Arrays inside a row are kept as JSON text in a single cell.
  • Several input shapesLists of objects, lists of lists, plain value lists, JSON Lines, and objects whose values are lists (one sheet per key) are all understood.
  • Types are respectedJSON numbers and booleans become real numbers and booleans in Excel. Strings stay text.
  • Clear errorsIf the JSON is invalid the tool says what is wrong instead of failing silently.

Good to know

  • Dates stay textA string like 2024-03-31 is kept as text. Open the result in Excel and convert it, or use Normalize date columns.
  • CSV holds one sheetIf your JSON produces several sheets, the CSV option writes only the first one. Choose XLSX to keep them all.
  • Very long cell text is cutExcel cells hold about 32,000 characters, so longer text is shortened.
Private by design

Your spreadsheets never leave your device

The tool runs inside your browser instead of on our servers, so there is nothing to upload, store or delete afterwards.

Typical online tool upload

Your device→Their server→Your device

Your file travels over the internet, sits on someone else's computer for a while, and you wait for the upload and the download.

Mediaextractr no upload

Your device does all the work

The tool loads into your browser once, then works on your file locally. Nothing is sent, so nothing can leak.

Made for real work

When people use JSON to Excel

Inspect an API response

Paste what an endpoint returned and read it as a table instead of a wall of braces.

Analyse exported records

Open data from a tool that only exports JSON, then sort and filter in Excel.

Hand data to non-developers

Give colleagues a spreadsheet instead of a file they cannot read.

Check a config or log list

Turn JSON Lines logs into rows you can scan quickly.

Compare

Mediaextractr vs typical upload tools

MediaextractrPrivateTypical upload tools
Your file is uploadedNeverYes
Sign-up neededNoOften, after a few files
Daily file limitNoneOften 1–2 free files
WatermarkNeverSometimes
Wait for upload & downloadNoYes
Speed on very large filesDepends on your deviceDepends on their servers

What shape of JSON works best

The cleanest input is a list of similar objects, such as [{"name": "Asha"}, {"name": "Ravi"}]. Each object becomes a row and each key a column. If one object has a key the others lack, that cell is simply left empty.

Handling nested data

With flattening on, {"user": {"city": "Pune"}} gives a column called user.city. Lists inside an object do not become extra rows. They are saved as JSON text in one cell, so no data is lost.

Need the opposite direction? Excel to JSON turns a sheet back into objects, and JSON formatter helps tidy messy input first.

Common input problems

If you see an invalid JSON message, look for a trailing comma, single quotes instead of double quotes, or unquoted keys. Those are valid in JavaScript but not in JSON. Once the text is fixed, convert again.

Very large pastes are handled better by opening the file instead of pasting it into the box.

FAQ

Questions, answered

How do I convert JSON to Excel?

Paste the JSON or open the file, choose XLSX and download. Each object becomes a row.

Is my JSON uploaded anywhere?

No. It is parsed and written inside your browser, so API keys or customer records you paste stay on your device.

What if my JSON has nested objects?

They are spread across columns named like address.city. Switch the option off to keep them as JSON text in one cell.

Can it read JSON Lines or NDJSON?

Yes. If the text is one JSON value per line, each line becomes a row.

Why is the date column showing text?

JSON has no date type, so date strings stay text. Convert them in Excel if you need real dates.

Can I use it on my iPhone or Android phone?

Yes. It works in current mobile browsers, though pasting a huge JSON is easier on a computer.