JSON to Excel Converter

Convert JSON into an Excel spreadsheet. Paste an API response or open a .json file: arrays of records become rows, nested objects become columns, and you can download the result as XLSX or CSV. Everything runs in your browser.

  • Nested objects flattened
  • XLSX & CSV
  • No upload: 100% private

How to use the JSON to Excel tool

  1. Add JSONPaste JSON into the box, or drop or open a .json file.
  2. Pick the dataThe tool finds the lists of records in your JSON. If there are several, choose which one becomes the table.
  3. Adjust columnsChoose how nested names are written and how lists inside records are shown.
  4. DownloadCheck the preview, then download an Excel (XLSX) or CSV file.

Features

  • Finds your dataWorks with a top-level array, with records wrapped in an object like {"data": [...]}, and with JSON Lines.
  • Nested objects become columns{"address": {"city": "Pune"}} becomes a column named address.city.
  • Every key keptRecords with different fields are combined; missing values are left empty.
  • Numbers stay numbersNumeric values are written as numbers, so you can calculate with them in Excel.
  • PrivateAPI responses with customer data or tokens never leave your device.

From API response to spreadsheet

JSON is how most web services and apps exchange data, but it is hard to read, filter or total. Excel is the opposite. This converter turns one into the other in seconds.

  • Exporting orders, users or products from an API or admin panel
  • Analyzing logs and analytics exports in Excel or Google Sheets
  • Sharing data from developers with colleagues who don’t read JSON
  • Checking a JSON file for missing or inconsistent fields

How JSON is turned into rows and columns

JSONIn the spreadsheet
Array of objectsOne row per object, one column per key
Nested objectColumns such as address.city
List of values ["a","b"]One cell: a, b
List of objects inside a recordJSON text in one cell, or choose that list as the table to get one row per item
true / false / nullTRUE / FALSE / empty

Problems you may run into

  • “Invalid JSON”. The most common causes are a trailing comma after the last item, single quotes where double quotes are required, and text copied with “smart” curly quotes. Run the data through our JSON Formatter to see exactly where the error is.
  • Everything lands in one row. Your data is probably a single object, not a list. Look for the array inside it, often under a key such as data, items or results, and convert that part.
  • Long numbers change. Excel keeps 15 digits of precision, so very long IDs can be rounded. Store such values as text in the source, in quotes, to keep every digit.
  • Dates show as text. JSON has no date type. Dates arrive as text such as 2026-03-15T10:30:00Z. In Excel, use Data → Text to Columns or the DATEVALUE function to turn them into real dates.
  • Records have different fields. That is fine. Every field becomes a column, and a cell is left empty where a record does not have that field.

Related tools

Check or tidy your JSON first with the JSON Formatter. Already have a CSV? Use CSV to Excel.

Frequently asked questions

How do I convert JSON to Excel?
Paste the JSON or open a .json file, check the preview and click “Download Excel”.
What JSON structure is supported?
An array of objects works best. Records wrapped in an object (like {"results": [...]}), objects of objects and JSON Lines files are also recognized.
What happens to nested objects?
They are flattened into columns with names like address.city. You can choose a different separator.
Can I get CSV instead?
Yes. Click “Download CSV” for a UTF-8 CSV file that opens correctly in Excel.
Is my JSON uploaded?
No. The conversion runs entirely in your browser.