Convert JSON to CSV: Flatten Records Into Rows

Created by

Data Done Right

Actor

JSON Formatter & Validator: Pretty Print, Minify, Fix, Convert

Turn a JSON array of records into CSV with one row per record and flattened nested fields. This example converts three customer records with an address object. Replace the text with your own JSON or add file links.

Try for free

JSON Formatter & Validator: Pretty Print, Minify, Fix, Convertdata-done-right/json-formatter-validator

Source

Operation

Status

Valid

+28 fields

Input

JSON texts:[{"id":1,"name":"Ada Lovelace","email":"ada@example.com","address":{"city":"London","country":"UK"}},{"id":2,"name":"Grace Hopper","email":"grace@example.com","address":{"city":"New York","country":"US"}},{"id":3,"name":"Alan Turing","email":"alan@example.com","address":{"city":"Wilmslow","country":"UK"}}]

Operation:to_csv

Output fields

Source

Operation

Status

Valid

Error

Line

Column

Hint

Repaired

Changes

Result

Result file

Schema valid

Schema errors

Stats

Bytes in

Bytes out

Format

Warnings

Note

Type

URL

Error context

Position

Fix count

Schema error count

CSV rows

CSV columns

Lines

Line errors

Bad lines

How it works

Sign up on Apify or log in

The JSON Formatter & Validator: Pretty Print, Minify, Fix, Convert Actor is ready to run with the inputs already set for "Convert JSON to CSV: Flatten Records Into Rows". Sign up or log in and you'll land in Apify Console with a copy of this exact task.

Start the "Convert JSON to CSV: Flatten Records Into Rows" task

The JSON Formatter & Validator: Pretty Print, Minify, Fix, Convert Actor will start running based on the input automatically. You can also change all the input fields, like JSON texts and operation, to match your specific use case.

Receive the "Convert JSON to CSV: Flatten Records Into Rows" output

Monitor the progress in real time. You will be notified as soon as your dataset is complete and ready for review. Each result includes data such as source, operation, status, and more.

Integrate into your workflow

The final output is delivered in JSON, CSV, or Excel format, ready to be plugged into your workflow. You can also run the "Convert JSON to CSV: Flatten Records Into Rows" task via API.