FilePicoYour files stay on your device
← Home

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)

Explore a JSON or JSONL file

Up to 50,000 records, 500 fields and 1 million cells. The preview shows the first 100 rows and 20 columns.

Adjust file reading

UTF-8 by default, with automatic CSV separator detection. Adjust these settings if accents or columns look wrong, then run the analysis again.

Choose a file or try the example.

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

  1. Choose a JSON, JSONL or NDJSON file.
  2. Check the format, then explore the structure or preview. Missing, empty and null values are counted separately.
  3. 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)