Data Formats utility

JSON to CSV

Convert an array of JSON objects into CSV with a header row.

● This tool runs entirely in your browser. Your input is never uploaded to our servers.

Input

Output

Your result will appear here…

How to use JSON to CSV

Paste an array of JSON objects.
Select Convert to generate column headers and rows.
Copy the CSV output into your spreadsheet or data tool.

Example

Input:

[{"name":"Ada","role":"engineer"},{"name":"Grace","role":"scientist"}]

Output:

name,role
Ada,engineer
Grace,scientist

Use cases

Export API data to spreadsheets.
Create CSV fixtures from JSON records.
Prepare tabular data for import tools.

About this tool

Convert an array of JSON objects into CSV with a header row. Processing happens locally in your browser, so your input is not sent to a server or included in analytics.

Frequently asked questions

Must all objects have the same properties?

Objects may omit a property; the corresponding CSV cell is left empty.

How are nested objects represented?

Nested objects and arrays are encoded as compact JSON within that cell.

Are commas and quotes escaped?

Yes. Fields are quoted and embedded quotes are doubled when needed.