Explore a JSON or JSONL file
Inspect JSON or JSONL fields, types, missing values and records. Preview your data and export its structure, without uploading the file.
JSON · JSONL · NDJSON → preview · structure
View guide : Inspect fields in a JSON or JSONL file (new tab)
DATA AND FILES
Explore a JSON or JSONL file
An unfamiliar file? See what is inside.
Up to 50,000 records, 500 fields and 1 million cells. The preview shows the first 100 rows and 20 columns.
Choose a file or try the example.
| No. | Field | Types | Missing | Empty | Null |
|---|
Preview limited to the first 100 records and 20 fields. Long cells are shortened to 240 characters. [missing] and [empty] are display markers.
Exports describe all fields, even when a search is active. CSV protects names that could be interpreted as formulas; JSON preserves exact names.
How do I read the results?
Missing means a JSON object does not have that field. Empty means an empty string. Null means the JSON null value. CSV types are suggestions: values are never converted.
The explorer describes top-level JSON fields. Nested objects remain visible in the preview. Parquet, Excel and NetCDF files are not supported by this tool.
Steps, formats and limits
How to use this tool
- Choose a JSON, JSONL or NDJSON file.
- Check the format, then explore the structure or preview. Missing, empty and null values are counted separately.
- Search field names or export the complete structure as JSON or CSV.
Which structures are supported?
A JSON object, an array of objects or one object per non-empty JSONL line. Only top-level fields are described; nested objects and arrays stay grouped.
Are repeated keys and large integers preserved exactly?
Within one object, repeated keys keep their last value. Numbers use JavaScript precision, so very large integers may be rounded. Keep identifiers as strings when exact digits matter.
What are the limits?
Up to 10 MB, 50,000 records, 500 fields and 1 million cells. Counts cover the whole file read. The preview shows at most 100 rows and 20 fields, with cells shortened to 240 characters. Analysis stops after 30 seconds.
Do exports contain the original data?
Exports describe the fields, types and counts, not all data rows. Searches do not limit the export. JSON keeps exact field names; CSV protects names that a spreadsheet could interpret as formulas.
Can I switch between CSV and JSON?
Yes. Each explorer keeps its own file, options and result within this tab. A failed or cancelled analysis leaves the last successful result available.
Are my files uploaded?
No. Processing happens in your browser. Download results before closing the tab or switching language. Original files remain unchanged.
Read the practical guide: Inspect fields in a JSON or JSONL file (new tab)