Array of objects
JSON records
JSON to CSV
Turn a list of flat JSON objects into a quoted CSV dataset.
Open this toolA list of object records can become a spreadsheet dataset when their fields are made explicit.
Paste the records and inspect the combined columns before exporting. Review missing values on the same basis.
Inputs and controls
Input separator
CSV output
Comma, Tab, Semicolon, Pipe
CSV export values
CSV output
Protect spreadsheet formula cells, Preserve raw machine values
How to use
- Paste or enter array of objects.
- Choose input separator and CSV export values.
- Select Process input. Read the returned values alongside the assumptions below before copying, exporting or acting on the result.
Why use this tool
The union of field names prevents a column from disappearing because it was absent in the first record.
Before relying on the result
Fields use the union of object keys. Missing and null fields become blank cells. Nested objects and arrays become compact JSON in a cell.
Tool limitations
Fields use the union of object keys. Missing and null fields become blank cells. Nested objects and arrays become compact JSON in a cell.
Questions
What happens to nested objects?
They become compact JSON inside a CSV cell. Missing and null values become blank cells.
What should I check before using JSON to CSV?
Check Array of objects, Input separator and CSV export values. Use the exact units shown beside the controls and replace any example values with your own inputs.
Source page last modified: 2026-10-04T16:58:29+00:00. This profile describes the tool; use its page to run it.
Markdown profile