Find the array, not just the wrapper

{
  "totalCount": 2,
  "comments": [
    {"id": 101, "author": {"name": "Alex"}, "text": "Ready"},
    {"id": 102, "author": {"name": "Sam"}, "text": "Review"}
  ]
}

The root object holds metadata and a comments array. QuickDataView looks for nested collections and initially chooses a substantial nonempty array. Use Collection to select comments if another list is selected.

Compare records and inspect detail

  1. Open the JSON file or paste the document.
  2. Select the useful collection and read it in Table.
  3. Click the author cell to inspect its nested object.
  4. Enable Flatten nested objects into columns to compare author.name directly.
  5. Switch to Tree or Raw source when you need the surrounding structure.

What if a field contains JSON inside a string?

Some exporters store a JSON object or array as escaped text inside another record. The cell inspector can decode valid object or array strings for inspection. The original value remains available as raw text; decoding the preview does not rewrite your file.

Export the part you need

Search and sort the selected collection, then export filtered CSV. Nested values become text in the export, so keep JSON when preserving types and hierarchy matters. Arrays remain inspectable rather than being expanded into every possible column.

This is a free local viewer, not an API client: it does not request private endpoints or run database queries. Table and nesting limits apply. For one record per line, use the JSONL and NDJSON guide.

Credit to the format’s makers

JSON’s compact combination of objects, arrays and simple values makes exchanging structured data approachable. Thanks to the JSON community for a format that stays useful across applications and programming languages.

Format reference: The JSON format. Reference checked 7 October 2026. These links acknowledge the format; they do not imply endorsement or a partnership.