Skip to content
NewAI dashboards.See how →
Open MammothTry free
Free · Runs in your browser

JSON to Excel converter

Turn a JSON file into an Excel spreadsheet. Nested fields become their own columns, and your file never leaves your browser.

Works with
JSONJSONLXLSXCSV
Opens inExcelGoogle Sheets

Drop a JSON file here

JSON or JSON Lines, up to 100 MB. It stays on your computer.

  • No sign-up
  • Nothing uploaded
  • Excel or CSV
  • Arla Foods logo
  • Bacardi logo
  • British American Tobacco logo
  • Everest Detection logo
  • Golden Acre logo
  • Handlangers logo
  • Inspired Learning Group logo
  • Kantar logo
  • MUFG logo
  • NielsenIQ logo
  • PTI Digital logo
  • RethinkFirst logo
  • Starbucks logo
  • The Specialist Works logo
What you get

A clean spreadsheet, made on your computer.

  • Your file stays on your computer

    The conversion runs in your browser. Nothing is sent to Mammoth or anyone else.

  • Nested fields become columns

    A field like customer.name gets its own column, so every value has a cell.

  • Numbers stay numbers

    Totals and true/false values arrive typed, so SUM and filters work straight away.

How it works

How to convert JSON to Excel

The converter finds the list of records, gives each one a row, and gives every field a column.

  1. 1

    Add your JSON

    Drop a .json file on the box, choose one, or paste the JSON in.

  2. 2

    Check the table

    A preview shows the rows and columns the file will have.

  3. 3

    Download

    Save it as an Excel file, or as a CSV if that is what you need.

Your options

Other ways to do it

Excel can do this itself, with a few more clicks.

  • Excel's Power Query

    A file you refresh often

    • Expands nested fields for youPartly
    • Keeps numbers as numbersYes
    • Ready in one stepNo
    • Refreshes when the file changesYes

  • Copy and paste

    A few flat records

    • Expands nested fields for youNo
    • Keeps numbers as numbersPartly
    • Ready in one stepNo
    • Refreshes when the file changesNo
  • This page

    This converter

    One-off files, deep nesting

    • Expands nested fields for youYes
    • Keeps numbers as numbersYes
    • Ready in one stepYes
    • Refreshes when the file changesNo
In Excel itself

How to import JSON into Excel with Power Query

Excel for Windows can open a JSON file without a converter. It takes a few more clicks, because you expand each nested field by hand.

Use Power Query when you want the workbook to refresh from the same file. Use the converter above for a one-off file, or when you want every nested field expanded in one go.

  1. 1

    Open a blank workbook and go to Data > Get Data > From File > From JSON.

  2. 2

    Pick your .json file. The Power Query editor opens with the data as a list or a record.

  3. 3

    Select To Table, then OK, so each item becomes a row.

  4. 4

    Select the expand button in the column header and tick the fields you want. Repeat for each nested field.

  5. 5

    Select Close & Load to put the table on a sheet.

Your file stays private

The converter runs inside this page. Your JSON is read and turned into a spreadsheet on your computer, and nothing is sent to Mammoth. That makes it safe for API exports with customer data in them.

How we handle your data

Once the page has loaded, it works with your internet switched off.

Every month

Getting new JSON files every month?

Mammoth can do it for you. Put the JSON files in a folder and their records are added to one table automatically.

Try Mammoth free

Order exports

Septemberorders-sep.json
Octoberorders-oct.json
Novemberorders-nov.json
DriveDropboxOneDriveSFTP
All ordersUp to date
Sep 04Ana Costa129.50
Sep 18Ben Ellis48.00
Oct 09Chloé Martin310.25
Nov 03Dev Patel75.90
Nov 06Eva Lindqvist212.00

Illustration. Every new file in the folder is added to the same table.

Questions

JSON to Excel questions

Is my file uploaded anywhere?
No. The page reads the file and builds the spreadsheet inside your browser. Once the page has loaded, it works with your internet switched off.
Can Excel open JSON on its own?
Yes. In Excel for Windows, Data > Get Data > From File > From JSON opens the file in Power Query, where you expand each nested field yourself. The steps are above. This converter does the expanding for you.
Which part of my JSON becomes the rows?
If the file is a list, each item is a row. If it is an object, the converter looks for the longest list of records inside it, such as a data or results field, and uses that. The table tells you where the rows came from.
What happens to nested data?
Nested objects become dotted columns, like address.city. A list of plain values goes into one cell, separated by commas. A list of objects inside a row is kept as JSON text in one cell.
Does it work with JSON Lines?
Yes. A file with one JSON object per line becomes one row per line.
How big a file can it convert?
Up to 100 MB. Excel holds up to 1,048,576 rows and 16,384 columns per sheet, and the converter tells you if your data goes past either.
Is it free?
Yes. There is no account and no email to give.

More free tools

Free toolJSON to CSVThe same converter, with a CSV file as the result.Take a lookFree toolMerge Excel filesCombine several spreadsheets into one table.Take a lookFree toolXML to ExcelTurn an XML file into an Excel sheet.Take a look