Turn a JSON array (uploaded or pasted) into an Excel sheet. Nested objects are flattened into dot-named columns, lists are joined, and an object of lists becomes one sheet per key.
Input
Works in your browser. What you paste or upload is processed on your device.
Upload a .json file or switch to Paste JSON and paste it in.
The tool reports how many items or lists it found and previews the first rows.
Keep Flatten nested objects on for dot-named columns, and choose how lists are written.
Press Convert to Excel and download the .xlsx file.
API responses, database exports and app data come as JSON, but the people who need to read, filter or share that data use Excel. This converter takes a JSON file or pasted text and builds an .xlsx sheet: each item in the array becomes a row and its keys become the columns, in the order they first appear. Items with missing keys simply get empty cells.
Nested data is handled for you. {"address": {"city": "Pune"}} becomes a column called address.city. Lists of simple values are joined (red, green, blue) or kept as JSON text, and lists of objects are kept as JSON text in one cell. The converter also accepts an object whose values are arrays ({"users": [...], "orders": [...]}), giving one sheet per key, a wrapper like {"data": [...], "total": 120}, JSON Lines (one object per line) and arrays of arrays.
Limits: the JSON must be valid; the error message points to the spot where parsing stopped. Excel cells hold at most 32,767 characters, so longer values are cut and counted in the result. A sheet holds 1,048,576 rows. Deeply nested arrays of objects are not expanded into extra rows.
Copying JSON into a spreadsheet by hand, or writing a script for a one-off export, takes longer than it should. A converter that flattens nested objects, keeps numbers and true/false as real values and shows a preview of the columns gets a readable sheet in seconds, and keeps API data, which often includes customer details, on your own device.
Something else? Ask the team
An array of objects works best: [{"id": 1, "name": "Asha"}, …]. It also accepts an object of arrays (one sheet per key), a wrapper object with one array inside, an array of arrays, JSON Lines, and a single object, which becomes one row.
With Flatten nested objects on, {"address": {"city": "Pune", "zip": "411001"}} becomes two columns, address.city and address.zip. Turn it off to keep each nested object as JSON text in one cell.
The message says where parsing stopped. The usual causes are a trailing comma before ] or }, single quotes instead of double quotes, or a missing bracket. Fix that spot in a text editor and try again. Your free run is not used until the JSON is valid.
No. Parsing and building the workbook happen in your browser. Our server only counts the run, so API keys, emails or other data in the JSON stay on your device.
Yes. Switch to Paste JSON and paste the response body. If the array is wrapped, as in {"data": [...]}, the tool finds the list inside.
Yes. You can paste JSON or pick a file on iPhone and Android and download the .xlsx to open in Excel, Numbers or Google Sheets.
You get one free run of this tool per day, with no account. After that, each run costs 5 credits from a free AI Rank Lab account (1 credit = 1 US cent). One run is one press of the convert button.
Each one opens on its own page and works straight away, with no sign-up.
Convert DOCX to clean HTML
Convert vCard contacts to CSV
Convert a CSV contact list to vCard
Extract a PDF from an Apple Pages file
Explore more free tools:Schema GeneratorMeta Tag GeneratorLLMs.txt GeneratorBrowse all free tools
JSON to Excel Converter is one piece of the puzzle. See how ChatGPT, Gemini, Perplexity, and Google AI Overviews actually view your brand, and get a prioritised list of fixes, with a free AEO & GEO audit from AI Rank Lab.
Run a free AEO & GEO audit or View pricing.
Site audit
Paste your site. The free audit scores it for SEO, answer engines and generative engines, with the fixes.
