iLoveDevTool
Back to Tools

JSON to Excel Converter

My tools
No tools yet

Loading...

How to convert JSON to Excel

  1. 1

    Paste or upload JSON

    Can use JSON objects, arrays, or API responses containing array fields like data, items, records, rows, results, list, etc.

  2. 2

    Adjust root node and mapping

    Select the array root path, set the array output method, and edit headers, source paths, transformation functions, default values, or template mapping.

  3. 3

    Preview and edit

    Modify data directly in the online spreadsheet, add or delete rows and columns, then export the current preview as an XLSX file.

Features Overview

Convert JSON to editable Excel workbooks in your browser. The tool identifies array root nodes, expands nested objects, supports custom headers, and allows field mapping through secure built-in transformation functions before exporting to XLSX.

Tool Description

Free online JSON to Excel converter. Flatten nested JSON, detect API array roots, customize headers, apply data mapping transforms, edit the spreadsheet preview, and export XLSX locally in your browser.

Last updated

Capabilities Checklist

  • Automatically recognizes common API array structures like data, items, records, rows, results, and list.
  • Flattens nested JSON objects into table columns; arrays can be exported as JSON text, concatenated text, or counts.
  • Provides an online table preview with direct editing of cells, rows, columns, and headers.
  • Supports custom headers, source paths, default values, and data mapping transformations.
  • Supports path.to.value path template mapping for combining multiple JSON fields.
  • All processing is done locally in the browser. The exported .xlsx includes frozen headers and filters.

Conversion reference

These three tables describe what this tool actually outputs. Checking them before you convert saves a round trip through the exported file.

Source path and default header

Source pathDefault header
idId
address.cityCity
created_atCreated at
orderIdOrder Id
user.name / company.nameName / Name

How JSON types land in Excel

JSON typeResult in Excel
stringWritten as-is into a text cell.
numberStays numeric, so you can sum and sort it directly.
booleanStays boolean, shown as TRUE / FALSE and filterable.
nullBecomes an empty cell rather than the text null, so AVERAGE skips it correctly.
objectFlattened into columns; anything left unflattened is written as JSON text.
integer ≥ 16Written as text to keep every digit, so long order IDs do not end in zeros.

Three ways to export an array

ModeOutputUse when
Keep JSON["pro","beta"]Another program will parse the cell again.
Join Valuespro, betaThe array holds simple labels and a person reads the sheet.
Count Items2You only need the quantity, to sum or sort on.

User feedback

Your feedback will be reviewed (and redacted if needed) before it appears publicly. Please do not include emails, passwords, or other personal information.

Your feedback helps us do better ❤️

Related Tools

Excel to JSON Converter

Convert Excel or CSV to JSON with multi-sheet support, field picking, and type fidelity

JSON to CSV Converter

Batch convert, history tracking, support nested JSON structures

JSON YAML Converter

JSON and YAML format conversion, supports syntax highlighting and history tracking

JSON to PHP Array Converter

Convert JSON to PHP array online with [] or array() output and nested data support

Base64 Encoder Decoder

Support Base64 encoding and decoding for text and files, can preview images

JSON Formatter Online

Format, validate, and explore JSON in your browser with a tree view, exact error lines, and JSONPath, with nothing uploaded

CSV to JSON Converter

Turn CSV into a JSON array online, with type inference and CJK-safe parsing

Related Guides

Online Converter, Power Query, or Python: Choosing How to Turn JSON into a Spreadsheet

One nested JSON document, three routes, three different spreadsheets. See how nested objects become columns, how arrays are exported, and where long numbers get rewritten — then pick between an online converter, Excel Power Query, and Python.

JSON Arrays to Excel: Export Nested Records as Related Worksheets

An array of objects is a one-to-many relationship, not a cell value. Learn how arrays become their own worksheet with parent identifiers, what each export mode keeps, and which structures lose data.

How to Import JSON into Excel with Power Query (and When Not To)

Excel cannot open a .json file as a spreadsheet. Here is the Power Query import path step by step, how to expand nested records and lists, and when converting to .xlsx first is faster.

Frequently Asked Questions

Can this tool handle nested JSON?
Yes. Nested objects are flattened into field paths, and arrays can be exported as JSON text, concatenated values, or counts.
Will my JSON be uploaded to the server?
No. Parsing, mapping, preview editing, and XLSX generation all happen locally in your browser.
Can I customize Excel headers?
Yes. The mapping panel supports renaming headers, modifying source paths, disabling fields, and adding default values or template combined columns.
Which array export modes does this tool support?
Three: keep the raw JSON text (the default), join items with a delimiter, or output the item count. An empty array becomes [], an empty cell, and 0 respectively. When the array holds objects, export it as a separate worksheet instead, one row per item with parent identifier columns. The trade-offs are covered in the guide JSON Arrays to Excel: Export Nested Records as Related Worksheets.
Which array root nodes does the tool detect automatically?
It looks for common API wrapper fields such as data, items, records, rows, results, and list, then uses the array it finds. If your structure differs, set the root path manually with a dot path such as data.items, or use $ when the document itself is the array.
What data types does the exported .xlsx preserve?
Numbers and booleans keep their native types, and null becomes an empty cell rather than text. Integers of 16 digits or more are written as text to avoid precision loss, so long order IDs do not end in zeros; shorter numbers stay numeric and remain usable in formulas.
Are there size limits on the export?
A worksheet holds at most 1,048,576 rows and 16,384 columns, and one cell holds 32,767 characters. Past 50,000 rows or 500 columns the tool warns that the dataset is large and export may be slow, and it reports a clear error when a hard limit is exceeded.
Should I download XLSX or CSV?
Pick XLSX when you need native number and boolean types, multiple worksheets, or a frozen header row with filters. Pick CSV when you need plain text that is diff-friendly or readable by another program. Note that the CSV output contains only the current preview table, not the extra worksheets generated from nested arrays.