JSON Transform Tools

Choose an output shape

• Open Flatten JSON when nested objects or arrays need a path-keyed result.
• Choose dot notation, bracket notation, or a flat table for the output.
• Set array expansion, null handling, separator escaping, and empty containers to match the input you are checking.
• Review the collision report when separate input paths could produce the same output key.

See how nested paths become keys

Flatten JSON keeps each value's location in its output key. With dot notation, a nested value can look like this:

{
  "profile": {
    "name": "Flatten JSON"
  }
}

{
  "profile.name": "Flatten JSON"
}

Bracket notation gives the path a different format. The flat table presents the same transformation as rows and columns. Choose the form that matches the place where you will inspect or use the result.

Set the flattening controls

Array expansion changes how members of an array appear in the flattened result. Null handling determines what happens to null values. Separator escaping covers keys that contain the path separator, so a separator inside a key can be distinguished from a separator between path parts.

Empty objects and arrays need their own setting because they contain no child values to lay out. Check those options before you compare output with another system. If different input paths resolve to one output key, the collision report gives you a place to review that case.

When to use a JSON flattening tool

Flatten a nested response before checking individual paths. The resulting keys show where each value sits inside the original objects and arrays.

Choose the flat table when the output needs rows and columns. Dot notation or bracket notation fits a path-based review.

Turn on collision reporting when you are checking whether distinct input paths produce the same output key. Review the report before using the transformed result.

JSON transform tools and JSON Tools

For cleaning, validating, comparing, merging, or querying JSON, open JSON Tools and choose the category for that task. This page contains Flatten JSON, with path-keyed output, notation choices, and settings for arrays, nulls, separators, and empty containers.

Frequently asked questions