ToolJovia
Data

Relational CSV to Nested Records

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

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

Loading tool…

How to use Relational CSV to Nested Records

Prepare a small one-to-many record payload from repeated flat source rows. Declared keys and fields make the relationship explicit, while conflicts, empty child policy and original encounter order remain reviewable.

  1. Enter input, parent fields json, parent key fields json, child fields json, child key fields json, new child-array property.
  2. Choose the settings for relational csv to nested records, then run the tool.
  3. Review the result and any limitations before copying or downloading it.

Good to know

  • 5,000 source records, 1,000 parents, 100 selected source columns and 250,000 planned nested field-text characters before allocation.
  • Exactly two explicit record levels; keys must be selected fields. All output values remain strings. Conflicting parent fields, nonempty children with empty keys and duplicate child identities within a parent are refused.
  • Processing is local. Output is limited to 1,000,000 text characters unless a stricter file limit is stated.

Common questions

Does a missing child create an invented child object?

No. If all selected child cells are empty, your policy either skips that child or refuses the input. A parent can retain an explicit empty child array without fabricated data.

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 →
Data

CSV to JSON

Convert a header-based CSV table into JSON records while preserving every cell as text.

Data

JSON Parent and Child Array Unnester

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

Data

CSV Foreign Key Checker

Check child records against unique parent composite keys with explicit blank-key handling.

Data

Embedded JSON Field Extractor

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

Data

CSV Functional Dependency Review

Find concrete original-record counterexamples to declared determinant-to-dependent field rules in supplied CSV data.

Data

CSV Adjacency Tree Builder

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