How JSON arrays and nested objects become tables
A table is the right view for a list of things. JSONBee finds every list in your file and gives each one its own table, the way you'd lay it out by hand.
- Every array of objects is a table. One row per item, one column per field, titled after the array's key.
- Nested objects become columns.
{"customer": {"city": "Pune"}}gives a column called "Customer · City". - Nested arrays become child tables. The operations of a work order or the lines of an invoice open under their row.
- Everything else becomes a header. Single values at the top, like a report's name and totals, show as a title and KPI cards above the tables.
- JSON Lines too. A JSONL file is one table, one row per line.