DEV Community

shi warren
shi warren

Posted on • Edited on

How to Convert JSON to Excel Online

JSON is great for APIs and structured data, but reviewing large responses in raw format gets painful fast.

I kept running into this while debugging APIs, checking exported records, and reviewing nested logs.

Most of the time, I didn’t actually need the raw JSON. I needed something readable.

Converting JSON into a spreadsheet ended up being the fastest workflow for things like:

API debugging
exported records
nested logs
sharing structured data with non-technical teams

One thing I noticed is that nested JSON matters a lot more than people expect. A lot of converters technically work, but still leave deeply nested fields unreadable.

So I built a lightweight browser-side workflow for flattening JSON into readable spreadsheet columns.

It supports:

JSON → XLSX
nested JSON flattening
browser-side processing
no signup

I also added XLS export because some older Excel workflows still depend on it.

Top comments (0)