Work and business
Turn JSON into a spreadsheet
JSON is how apps and APIs share data, but most people want it in a spreadsheet. Convert it in a few seconds, nested data included.
JSON to ExcelFree · No sign-up · Files stay on your device
Open JSON to Excel
Why convert JSON
JSON is perfect for programs and awkward for people. A spreadsheet lets anyone sort, filter, total and chart the same data.
The list of records is found for you, even when it sits inside "data" or "results", and nested fields become columns like address.city.
When you might need this
- API responsesProducts, orders or users from a web service, for a quick look or a report.
- App exportsData downloads from apps that only offer JSON.
- Logs and eventsJSON Lines files with one event per line.
Key benefits
- Nested data handledObjects become dotted columns; lists of values are joined in one cell.
- Types keptNumbers stay numbers and true/false stays true/false.
- PrivateData that may hold customer details stays on your device.
How to convert
- Save the JSON to a file (from your browser, API tool or app).
- Open it in JSON to Excel.
- Press Convert and save the spreadsheet.
Tips
- For many files, open them all at once and save a ZIP.
- Need it back as JSON later? CSV to JSON can rebuild nested objects from dotted headings.
- For XML feeds, use XML to Excel.
JSON to ExcelFree · No sign-up · Files stay on your device
Open JSON to Excel
Questions
What if my JSON is one big object, not a list?
The longest list inside it is used as the rows. A single object becomes a single row.
How big a file can it handle?
Tens of megabytes work well. Excel itself stops at 1,048,576 rows; use CSV for more.
Does it work with JSON Lines?
Yes, .jsonl and .ndjson files are read line by line.
Tools for this job
More guides
- Work and businessTurn Zoom or Teams captions into a Word documentTurn the VTT caption file from a Zoom or Microsoft Teams recording into a readable transcript in Word or plain text, with or without times.
- Work and businessFix a CSV that opens wrongly in ExcelFix CSV files that open in Excel with garbled accents (é instead of é) or with every value squashed into one column. Free, and nothing is uploaded.
- Work and businessOpen a DWG file without AutoCADSee an AutoCAD DWG drawing without AutoCAD, and save it as a sharp SVG or PNG to view, share or print, or as DXF for other CAD programs.