How to use it
- Paste JSON or open a .json file.
- Choose how arrays inside the objects are written.
- Optionally name the sheet.
- Select Convert and download .xlsx.
How it works
Each item of the top-level array becomes one row; a single object gives one row. Nested objects are flattened into columns named with dot paths, such as address.city. Columns appear in the order their keys are first seen, so objects with different keys still line up and missing values are empty cells.
Arrays inside objects can be written as JSON text in one cell, joined with semicolons, or spread over numbered columns (tags.0, tags.1). Numbers and booleans keep their type in Excel; null becomes an empty cell. Strings stay text, including strings that look like dates or start with =, which are never turned into formulas.
The header row is bold, frozen and has filter buttons, and column widths follow the content. Excel limits a cell to 32,767 characters; longer text is cut and the tool tells you how many cells were affected.
Examples
An API response
A list of users from a REST API, each with a nested address object, becomes a sheet with columns id, name, address.city and address.zip.
Tags for filtering
Choose One column per item to put each tag in its own column, or Join values to keep them together as “vip; newsletter”.
Frequently asked questions
What if my objects have different keys?
Every key that appears anywhere becomes a column. Rows without that key get an empty cell.
My JSON is an object that contains the array. What do I do?
Paste only the array, or the tool treats the whole object as one row with dot-path columns. Many API responses keep the list under a key such as data or items.
Are dates converted?
No. JSON has no date type, so date strings are kept as text exactly as written.
Privacy
The JSON is converted in your browser and the .xlsx file is created on your device. Nothing is uploaded, stored or included in analytics; only an anonymous event that the tool was used is counted.