JSON to CSV

Convert a JSON array of flat objects into quoted CSV rows.

Your workspace

Processed in your browser

Enter your values or try the example.

This utility transforms a JSON array of objects into a comma-separated values (CSV) format. It is designed to help you prepare structured data for spreadsheet software or database imports.

How to convert JSON to CSV

  1. Paste your JSON array into the input field. Ensure the JSON is an array of objects where each object represents a row.
  2. The tool automatically extracts unique keys to create the CSV header row and maps object values to the corresponding columns.

Handling complex data

If your JSON contains nested objects or arrays, the tool serializes these nested structures into a single string within the CSV cell. This ensures no data is lost during the conversion, though you may need to parse these cells further if you intend to perform calculations on nested values.

Conversion example

[{"id": 1, "name": "Widget"}, {"id": 2, "name": "Gadget"}]

"id","name" "1","Widget" "2","Gadget"

Questions about conversion

What happens if objects have different keys?

The tool identifies the union of all keys present across all objects in the array. If a specific object is missing a key, that cell will be left empty in the resulting CSV.

Can I import this directly into Excel?

Yes. The output is standard CSV format with quoted fields, which is compatible with Excel, Google Sheets, and most database import tools.

Continue your workflow

Explore more tools in this category for your next step.