Find the useful collection
An export often wraps its records in metadata. QuickDataView looks for nested collections and initially selects a substantial nonempty array. Use Collection to switch arrays, or Back to document to inspect the root.
{
"totalCount": 2,
"comments": [
{"id": 101, "author": {"name": "Alex"}},
{"id": 102, "author": {"name": "Sam"}}
]
}
Here, comments is the table you probably want. Clicking the author cell opens the nested object. Flatten nested objects into columns makes author.name available as a column. Arrays remain inspectable cells.
Tree, table or raw source
Use Tree to follow structure, Table to compare records, and Raw source to read the document. The cell inspector offers tree and raw JSON views. Valid JSON object or array strings embedded in a field can also be decoded for inspection.
JSON Lines is a different format
For .jsonl and .ndjson files, each nonblank physical line must contain one complete JSON value. Blank lines are ignored as records, but source line numbers remain available in inspection. A malformed record stops loading and reports its exact line. Pretty-printed JSON spread across lines belongs in a .json file.
{"id":1,"owner":{"name":"Alex"}}
{"id":2,"owner":{"name":"Sam"}}
Export with context
Search and sort the selected collection, then export filtered CSV. Nested values become text in the export. Keep the original JSON if you need its complete structure or types later.
Tables are limited to 100,000 rows and 200 columns. Structured documents have nesting and expanded-value limits. The optional 10 MB warning does not remove those limits. JSON previews use safe text and sanitized markup; your file contents are not sent to a server.
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.