hank-builds.com

JSON Table View - View Arrays as Sortable Tables

What is the Table View?

The table view extracts arrays of objects from your JSON and displays them as familiar, spreadsheet-like data tables. This is ideal for JSON that contains tabular data — API responses with lists of records, database exports, CSV-to-JSON conversions, and similar structured data.

How It Finds Tables

The table view scans your JSON for arrays of objects. It looks in two places:

  • Root array — If your JSON is an array of objects at the top level, it becomes the table directly.
  • Top-level properties — If your JSON is an object, any property that contains an array of objects is detected as a table candidate.

When multiple arrays are found, selector pills appear in the header bar so you can switch between them. Each pill shows the property name and row count.

Column Detection

Columns are automatically derived from the union of all keys across every row. This means rows don't need to have identical keys — missing properties simply show as empty cells. Column order follows the order keys first appear in the data.

Sorting & Searching

Click any column header to cycle through sort states:

First clickSort ascending (A-Z, 0-9)
Second clickSort descending (Z-A, 9-0)
Third clickReset to original order

Numbers are sorted numerically, strings alphabetically. Null and undefined values always sort to the end.

Use the search bar to filter rows — any row where a column header or cell value matches the search term is shown. The toolbar shows how many rows match.

Cell Interactions

Values are color-coded by type for quick scanning:

StringsGreen text
NumbersBlue text
BooleansPurple text
NullGray text
Objects / ArraysGray preview like Object{3} or Array(5)

Click any cell to copy its value to your clipboard. A brief checkmark confirms the copy.