Skip to main content
The JSON Expander extracts individual values from JSON columns and places them into their own columns, turning nested API response data into structured, usable table fields.
JSON Expander is a transformation. It does not consume any credits.

​
How it works

Many enrichment APIs return complex JSON objects. The JSON Expander lets you visually browse those objects and select exactly which fields to extract, without writing any code.
1

Click on a JSON cell

Click any cell that contains JSON data in your table.
2

Browse in the sidebar panel

The JSON Expander opens in the right-side panel, keeping your table visible while you explore the JSON structure.
3

Map fields to columns

Browse the JSON structure and click Map next to any field to create a new column from that value. If the JSON contains a list of objects (e.g., [{}, {}]), you will also see a Write to another table option, which sends each item in the list as its own row into a separate table.

​
Key capabilities

Nested JSON mapping

Map columns directly to nested JSON values without expanding into intermediate columns first.

Export JSON as column

Extract a full nested JSON object into a separate column, not just primitive text or number fields.

Parallel processing

JSON Expander runs up to 6x faster than before. Values are processed in parallel for large tables.

Side panel view

The expander lives in the right-side panel so you can keep your table context visible while working.

​
When to use JSON Expander vs. JQ formulas

JQ formulas

Use JQ expressions for advanced JSON manipulation.

Tables overview

Learn how tables work in Databar.