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
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).