JSON to Table
Paste a JSON array of objects and view it as a sortable, filterable table. Copy as CSV or HTML.
About this tool
Pasting a JSON array of objects into a spreadsheet is painful — quoting commas, splitting columns, dealing with nested fields. This tool renders the array as an interactive grid you can scan, sort, and filter, then copy out as CSV or HTML when you need it somewhere else.
It expects a top-level JSON array of objects: [{"name":"Alice","age":30},{"name":"Bob","age":25}]. The first object's keys become columns; keys that only appear in later objects are merged in automatically. Click any column header to sort ascending or descending; type in the filter box to hide rows that don't match.
Nested objects and arrays are shown inline as JSON so you can spot structure at a glance, and the Copy CSV button emits a spreadsheet-ready file with proper quoting.
FAQ
Why does my JSON show an error? ›
The input must be a JSON array whose items are objects (e.g. [{...},{...}]), not a single object or a list of primitives. If you have one object, wrap it in square brackets. Re-check for trailing commas, which are invalid JSON.
How are columns chosen when objects have different keys? ›
The tool scans every object in the array and collects all unique keys in the order they first appear, so a field present only in the fifth row still gets its own column. Missing values appear as blank cells.
What does the "Pretty columns" checkbox do? ›
It converts keys like created_at or fullName into Created At and Full Name for display in the header row only. The underlying key used for sorting and CSV export is unchanged.
Can I sort on more than one column? ›
No — clicking a header sorts by that column alone and toggles ascending/descending. For multi-column sorting, copy the data as CSV and open it in a spreadsheet.