JSON to Excel Converter
Turn a JSON array into an .xlsx sheet; nested fields become columns.
Drop JSON files here
or select to choose from your device
Files are processed on this device. Nothing is uploaded.
How to use JSON to Excel Converter
- Add a .json file containing an array of objects (for example an API response saved to a file).
- Check the preview: each key becomes a column.
- Select Convert to Excel and download the .xlsx file.
How it works
Each object in the array becomes a row and each key a column, in the order keys first appear; objects with different keys are handled, with blanks where a key is missing. Nested objects are flattened with dots (user.address.city), lists of simple values are joined with commas, and lists of objects are spread into numbered columns (items[0].sku).
JSON numbers and booleans are written as real numeric and TRUE/FALSE cells; strings are written as text, so codes with leading zeros are safe. If the JSON is an object whose values are all arrays of objects, each key becomes its own sheet.
Files are read and written by your browser on your device. Nothing is uploaded, so there is no size limit set by us and no copy of your data anywhere else.
Example
[{"id":1,"user":{"name":"Ada"},"tags":["a","b"]}] → columns id, user.name, tags with the row 1 | Ada | a, b.
Frequently asked questions
What JSON structure works best?
An array of objects with similar keys: [{…}, {…}]. A single object becomes one row.
How is nested JSON handled?
Nested keys are joined with dots into column names. Deep or irregular structures give many columns; reshape the JSON first if you need a different layout.
Can I paste JSON instead of uploading a file?
Save it as a .json or .txt file and add that. For pasted text to CSV, use JSON to CSV.
Is there a size limit?
Excel allows 1,048,576 rows and 16,384 columns per sheet. Very large files need enough memory on your device.
Limitations
- Input must be a file with valid JSON.
- Strings longer than 32,767 characters do not fit in an Excel cell and are reported.
- No styling beyond a bold header.
Last reviewed November 9, 2026. How we build and test tools.