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.
Unnest your JSON on the Apify Store · Version 0.0.1, updated 2024-11-20
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
- Put a JSON file URL in
jsonUrlor paste the JSON intojsonText. - Set
expandLists,separatoranddelimiter, and start the run. - Read the result from the key-value store and export it to the format you need.
Also runs from AI assistants through Apify's MCP server.
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.
Inputs
jsonUrl |
JSON File URL |
jsonText |
Paste JSON Text |
separator |
Key Separator default: . |
delimiter |
CSV Delimiter default: , |
expandLists |
Expand Lists into Rows default: True |
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.