JSON to Excel
Paste your JSON data and download as Excel (.xlsx).
About the JSON to Excel converter
The TConverter JSON to Excel tool turns JSON data into a real Excel workbook (.xlsx) that you can open in Microsoft Excel, LibreOffice Calc, Google Sheets or any other spreadsheet application. You paste your JSON into the text area, click one button, and the file is created and downloaded straight away. There is no account to create and nothing to install, and the tool is free to use.
JSON is the everyday format of APIs, configuration files and database exports, but it is hard to read for anyone who does not work with code. Converting it to a spreadsheet is a common need: sharing an API response with a colleague, reviewing an export from a web service, building a quick report, or checking a list of records for missing values. In a spreadsheet you can sort, filter and add formulas without writing a single line of code.
Real-world JSON is rarely a flat list, so the converter does some of the preparation work for you. If the top level is an array, each element becomes a row. If the top level is an object, the tool looks for the property that holds the largest array (for example a "data" or "items" list inside an API response) and uses that as the rows; when no array exists, the object becomes a single row. Nested objects are flattened into columns with dot notation, so {"address": {"city": "Berlin"}} becomes a column named address.city.
Arrays are handled in a predictable way as well. A list of simple values such as tags is joined into one cell, separated by commas, while a list of objects is expanded into indexed columns like items.0.name and items.1.name. Because records do not always share the same keys, every column found in any record is collected, and cells that do not apply to a given row are simply left empty. The result is a consistent table on a single sheet named Sheet1.
The conversion runs entirely in your browser using the SheetJS library. Your JSON is not uploaded to a server, which makes the tool suitable for internal data you would rather not send anywhere. The practical limit is the memory of your own device: very large inputs take longer to process in the browser tab. If the input is not valid JSON, an error message is shown under the text area instead of producing a broken file.
Frequently asked questions
Is the JSON to Excel converter free?
Yes. TConverter is free to use and does not require sign-up or registration.
Is my JSON data uploaded to a server?
No. The Excel file is generated in your browser, so your JSON never leaves your device.
How are nested objects and arrays converted?
Nested objects become columns with dot notation, such as user.name. Arrays of simple values are joined into one cell with commas, and arrays of objects are expanded into indexed columns such as items.0.price.
What happens if my records have different fields?
All fields from all records are collected as columns. If a record does not have a particular field, that cell is left empty.
Can I convert a JSON object that wraps the data, like an API response?
Yes. If the top level is an object, the tool uses the property that contains the largest array as the rows. If there is no array, the object is written as a single row.
Is there a size limit?
No fixed limit is set for pasted JSON. Because everything runs in your browser, very large inputs depend on your device's memory and may take a while.