ToolJovia
Data

JSON Parent and Child Array Unnester

Create a relational CSV from one explicit child array while retaining parent/child record provenance.

✓ Browser-local processing
Processed in this tab. Up to 100,000 characters unless this tool states a smaller limit.

Loading tool…

How to use JSON Parent and Child Array Unnester

Expand structured child objects rather than splitting a serialized multivalue cell. You choose the exact parent and child fields; the result repeats parent evidence deliberately, and empty arrays follow an explicit retain/drop/refuse policy.

  1. Enter input, root child-array property, parent field names json, child field names json.
  2. Choose the settings for json parent and child array unnester, then run the tool.
  3. Review the result and any limitations before copying or downloading it.

Good to know

  • 100,000 JSON characters,1000 parent records,100 children per parent,20 selected fields per level and 5000 output records. Cell allocation is preflighted at 350,000 characters.
  • Exactly one root child-array property and object children. Selected fields must exist. Strings remain text; other JSON values serialize as JSON. A retained empty parent has blank child provenance/cells and is not an observed child.
  • Processing is local. Output is limited to 1,000,000 text characters unless a stricter file limit is stated.

Common questions

Will two nested arrays create an implicit Cartesian product?

No. The supported profile expands one explicitly named child array only. It never multiplies unrelated arrays silently.

Is this input sent to a server?

No. The application processes this input inside your browser tab and does not save it to persistent storage.

Keep going with related tools

All data →
Developer

JSON to CSV

Convert a JSON array of objects into a quoted CSV table with spreadsheet formula protection.

Data

CSV Multivalue Exploder

Expand a selected multivalue CSV cell into separate records while retaining every other column.

Data

Table Unpivot Workbench

Turn selected wide CSV measure columns into variable/value records without aggregating text.

Data

Embedded JSON Field Extractor

Append scalar JSON Pointer fields from JSON text stored in CSV records while preserving numeric source spellings.

Data

CSV Adjacency Tree Builder

Export exact ID/parent records into ordered nested trees with original cell arrays, record provenance and explicit cycle refusal.

Data

Relational CSV to Nested Records

Pack explicit parent and child fields into nested JSON after checking parent consistency and child-key uniqueness.