Convert nested JSON to CSV without writing code
Give a JSON file URL or paste the JSON, and get a CSV with nested objects flattened into columns and lists expanded into rows.
Convert JSON to CSV on the Apify Store · Version 0.0.41, updated 2024-12-18
Who it is for
Analysts and spreadsheet users who receive JSON exports and need them in Excel or a BI tool.
What you get
Nested structures
Nested objects and arrays flattened into CSV columns, however deep.
Lists into rows
Optionally expand lists so each item becomes its own row.
Your separators
Set the separator for nested keys (default .) and the CSV delimiter (default ,).
How it works
- Put a JSON file URL in
jsonUrlor paste the JSON intojsonText. - Set
expandLists,separatoranddelimiterif you need to, and start the run. - Download the CSV from the key-value store.
Also runs from AI assistants through Apify's MCP server.
Use cases
- Opening an API export in Excel.
- Loading JSON into a BI tool that reads CSV.
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.
Where do I find the CSV?
In the run's key-value store.
How are nested keys named?
Joined with the separator, so address and city become address.city by default.