Text utilities

Flatten JSON

Convert nested JSON object keys into dot-separated paths.

Text stays in your browserCopy your result
Data workspace
Data workspace

Check delimiters and structure before downloading the output.

See the method

Your source data

Runs on your device

Your transformed data

Your result

Let’s calculate.

Use the Calculate button to see your result.

Your content is processed locally.

How to use this tool

  1. Enter json object.
  2. Select Update result to view the result.
  3. Check the method and assumptions below before using the result.

Input reference and sample values

Use the units and choices shown for each field. Sample values are provided for practice, not as recommendations.

InputFormat and unitsSample
JSON objectKeep the structure and separators shown in the sample. Line breaks are retained in this input.{"user":{"name":"Ava","score":20}}

Result for these sample inputs

{
  "user.name": "Ava",
  "user.score": 20
}

Processed locally. Review the output before using it.

Select Try the example in the form to load these values and calculate them again. This replaces the current form inputs. Compare the result with the method and worked explanation below.

The method, explained

Walk nested nonempty objects and join keys with dots. Arrays and empty objects remain values.

A WORKED EXAMPLE

{"user":{"name":"Ava"}} becomes {"user.name":"Ava"}.

What to keep in mind

Maximum nesting depth is 30. Empty keys, dotted keys and reserved object keys are rejected.

Common questions

How does this tool handle my input?

Processing happens in your browser. Your pasted content is not uploaded, included in URLs or stored as a calculation history.

What input should I use?

JSON object: use the example already shown, then replace it with your own content. Maximum nesting depth is 30. Empty keys, dotted keys and reserved object keys are rejected.

Methodology maintained by ClarityKit. How these tools are built and checked.