> ## Documentation Index
> Fetch the complete documentation index at: https://docs.less.tech/llms.txt
> Use this file to discover all available pages before exploring further.

# Flatten JSON

> Flatten a JSON object into a table

The Flatten JSON tool should be used as a last resort when working with JSON data stored in Text columns.

It is much easier to use the Columns tool to convert JSON data into a an Object or List and then [Parse](/tools/new-columns/parse-object) or [Explode](/tools/new-columns/explode-list) the data into separate columns.

However, that is only possible if the JSON data schema is uniform. Sometimes, a JSON object has a nested structure where one row might contain a number and another row might contain an object. In that case, the Flatten JSON tool can be used to flatten the JSON object into a table.

With the Flatten JSON tool, all the JSON is parsed into a table with one row per JSON object. That means that the resulting table will be a rather long table with many rows.

Typically, you should use the [Split Columns](/tools/new-columns/split-columns) tool afterwards to separate the columns headers (and nested objects) into separate columns.