Home / Tools / JSON to CSV Converter

CSV & data

JSON to CSV Converter

Flatten nested JSON or JSON Lines into a CSV table.

About $1 per 10,000 rows.

Try it on Apify
JSON to CSV Converter — Flatten nested JSON or JSON Lines into a CSV table.

Turn nested JSON into a flat table for Excel and Google Sheets. You pick how lists are handled.

What it does

  • Flattens nested objects, such as user.name and user.address.city.
  • Reads JSON, JSON Lines, and Apify dataset links.
  • Saves a CSV file and also puts rows in the dataset.

Before and after

Nested JSON

[
  {"id": 1, "user": {"name": "Ann", "tags": ["a", "b"]}},
  {"id": 2, "user": {"name": "Bo"}, "ok": true}
]

Flat CSV

id,user.name,user.tags,ok
1,Ann,a; b,
2,Bo,,true

From json-to-csv-apify/tests/test_actor.py.

Get it

Pay per use · Apify · $0.0001 per row

Try it on Apify

FAQ

What does this tool do?

Flatten nested JSON or JSON Lines into a CSV table. Turn nested JSON into a flat table for Excel and Google Sheets. You pick how lists are handled.

What does it cost?

Pay per use on Apify costs $0.0001 per row.

Will you see my files?

The download tools run on your computer, so those files stay with you. The Apify tools run in your own Apify account. This website does not take uploads.