# Flatten deeply nested JSON into rows and columns

> Unnest any JSON, however deep, into a flat table: nested keys become columns, lists can become rows, and you choose how keys are joined.

Who it is for: Data engineers and analysts who need nested API responses as flat records for a database, spreadsheet or analysis.

## What you get

- **Any depth**: Nested objects and arrays flattened, however deeply nested.
- **Lists into rows**: Optionally expand lists so each item becomes a separate row.
- **Your key format**: Choose the separator for nested keys (default .) and the delimiter.

## How it works

1. Put a JSON file URL in `jsonUrl` or paste the JSON into `jsonText`.
2. Set `expandLists`, `separator` and `delimiter`, and start the run.
3. Read the result from the key-value store and export it to the format you need.

## Use cases

- Preparing nested API responses for a database table.
- Flattening event data before analysis.

## Pricing


Free Actor: you pay only for your Apify platform usage.

## Questions

### What does it cost?

It is a free Actor: you pay only for your Apify platform usage.

### Can lists become rows?

Yes, with `expandLists`, on by default.

### Where is the result?

In the run's key-value store, ready to export.

Unnest your JSON: https://apify.com/eloquent_mountain/automated-json-unnester?utm_source=actors.taskmastergpt.nl&utm_medium=llms&utm_campaign=automated-json-unnester