JSON to Excel
Convert JSON to an Excel .xlsx file in your browser. Lists of objects become rows, and nested lists become extra sheets. Free, private, no upload.
JSON
Stays in your browserResult
Your workbook appears here after you press Convert.
Shortcuts: Ctrl+Enter run · Ctrl+Shift+C copy result · / search (use ⌘ on Mac)
Free Online JSON to Excel Converter
Open JSON data in Excel. Paste JSON or open a .json file and download an .xlsx workbook. Nested lists are written to extra sheets so nothing is lost. It gives developers a quick browser-based way to solve a focused json to excel task before moving the result into a project.
How to convert JSON to Excel
Paste a list of objects (or open a JSON file), choose the name of the first sheet and press Convert. The result is listed on the right: press Download to save the workbook.
Common mistakes
- Pasting a single value or text: Excel needs a list of objects or one object.
- Very long text cells: Excel cuts cells at 32,767 characters.
Frequently asked questions
What does the Excel file contain?
One sheet with a bold header row and one row per object. Nested objects become columns such as address.city. A nested list of objects is written to its own sheet with a parent_row column that points back to the row it belongs to.
Does it work in Excel and Google Sheets?
Yes. The file is a standard .xlsx workbook that opens in Excel, Google Sheets, LibreOffice and Numbers.
Is my data uploaded?
No. The workbook is built in your browser and downloaded from there.
Are dates written as Excel dates?
Dates stay as text in the format they have in your JSON, so they never change shape. Format the column in Excel if you want real dates.
How do I use this json to excel tool?
Use the interactive controls above; processing stays in your browser and the result is intended as a practical starting point for development work.
More Formatters & Parsers
JSON ParserCheck if JSON is valid and see it neatlyJSON Schema ValidatorCheck data follows the rules you setJSONPath TesterPick values out of JSON with a pathXML/XSD ValidatorCheck XML is valid and follows a schemaJSON ↔ TOML ConverterSwitch config files between JSON and TOMLURL ParserBreak a web link into its partsQuery String ParserRead the ?a=1&b=2 part of a linkREST API TesterSend API requests and see the response