JSON Viewer Online
View and inspect JSON files directly in your browser. Browse rows, check column names and data types — no upload required, your data stays on your device.
About the JSON viewer
The JSON viewer turns a JSON file into a table. It is useful for API responses, database exports and data dumps that are too long to scroll through in a text editor. An array of objects becomes rows, with the keys as columns. The schema panel shows the type detected for each key, and the first 500 rows are shown 100 per page.
Nested objects are kept as STRUCT columns and arrays as LIST columns. Their values appear as JSON text in each cell, so you can see the structure without expanding a tree. A file containing a single top-level object shows as one row. If your records sit under a key such as "data" or "results", they appear as one nested cell. Extract that array first, or use the Flatten JSON tool. Newline-delimited JSON with a .json extension is also read. Keys missing from some records still get a column, with null where they are absent.
What to check when you open a JSON file
- Rows correspond to records. One row with a huge nested cell means the records are wrapped in an outer object.
- Keys that appear only in some records still show up as columns, with null in the other rows.
- Numeric fields show BIGINT or DOUBLE rather than VARCHAR, which would mean some values are quoted strings.
- Date strings in ISO form are detected as DATE or TIMESTAMP.
- STRUCT columns list the fields you expect to flatten or query later.
Your file is processed locally in your browser and is never uploaded. The free limit is 50 MB per file; larger files work if your device has the memory for them.
Frequently Asked Questions
Why does my JSON file show as a single row?
The top level is an object, not an array. A response like {"data": [...]} is one record with one field holding the whole array. Point the tool at a file whose top level is the array, or use the SQL Query tool with unnest() on the nested field.
How are nested objects and arrays shown?
Each nested value is printed as compact JSON text inside its cell. The schema panel shows the full type, such as STRUCT(city VARCHAR, zip VARCHAR) or VARCHAR[].
What happens if the same key has different types in different records?
The column gets a type that fits every value, usually VARCHAR or JSON. Numbers in that column are then shown as text. Look for records where the value is quoted or holds an object.
Related Tools
Convert JSON to CSV Online
Convert JSON files to CSV format directly in your browser. No upload required — your data never leaves your device.
Convert JSON to Excel Online
Convert JSON files to Excel format directly in your browser. No upload required — your data never leaves your device.
Convert JSON to Parquet Online
Convert JSON files to Parquet format directly in your browser. No upload required — your data never leaves your device.
Validate JSON Files Online
Validate JSON file structure in your browser. Check null counts, distinct values, and data types for every column — no upload required.
Filter JSON Files Online
Filter rows in JSON files by column value, directly in your browser. Your data stays on your device.
Count Values in JSON Files Online
Group and count rows by any column in JSON files directly in your browser. Sort by frequency or value to find the most common entries — no upload required.
CSV Viewer Online
View and inspect CSV files directly in your browser. Browse rows, check column names and data types — no upload required, your data stays on your device.
Excel Viewer Online
View and inspect Excel files directly in your browser. Browse rows, check column names and data types — no upload required, your data stays on your device.