Excel Tools

JSON to Table

See JSON data as a table — every record a row, every key a column — and sort, filter, search or chart it like a spreadsheet.

Drop a JSON file

or browse from your device — a list of records

Private & secure Sort & filter Export to Excel

Read JSON like a spreadsheet

API responses and app exports are easy for code and hard for people. Drop a JSON file and its records open in Mega Excel Studio as a table: a row per record, a column per key (keys missing from some records leave the cell empty), several lists as several sheets. Sort and filter to find what matters, add a chart, then export the table as Excel, CSV or JSON again.

A row per record

A column per key.

Find anything

Sort, filter and search.

Export the table

Excel, CSV or back to JSON.

Frequently asked questions

A list of objects, a list of lists, or an object holding such lists (each becomes a sheet).