# 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.

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

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

## 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.

## 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.

Convert JSON to CSV: https://apify.com/eloquent_mountain/json-to-csv-converter?utm_source=actors.taskmastergpt.nl&utm_medium=llms&utm_campaign=json-to-csv-converter