JSON to CSV Converter

Conversion details

This converter turns arrays of JSON objects into tabular data that spreadsheet apps and data tools can import directly. Each object in the array becomes a row, and each unique key becomes a column header.

• Accepts JSON arrays of objects — each object becomes a row
• Nested objects flatten to dot-notation columns (e.g., address.city)
• Embedded arrays serialize as JSON strings within cells
• Values with delimiters or quotes are escaped per RFC 4180

Frequently asked questions

What JSON structure does the converter expect?

The input should be a JSON array of objects, like [{"name":"Alice","age":30}, ...]. Each object represents a row, and keys become column headers. If your JSON is a single object, wrap it in an array first. The tool also handles arrays where objects have different keys — missing values become empty cells.

How are nested objects flattened?

Nested objects are flattened using dot notation. For example, {"address":{"city":"NYC"}} becomes a column named address.city with the value "NYC". This works recursively at any depth, so nothing gets lost in the flat CSV output.

Can I open the CSV in Excel or Google Sheets?

Yes. The output is RFC 4180-compliant CSV that Excel, Google Sheets, LibreOffice Calc, and other spreadsheet applications import correctly. Special characters, commas within values, and line breaks are properly quoted and escaped so cells display as expected.

Can I change the delimiter from comma to something else?

Yes. The tool supports configurable delimiters including comma, semicolon, tab, and pipe. Semicolons are useful for European locales where the comma is the decimal separator, and tabs work well for pasting directly into spreadsheet applications.

Related tools

• JSON Studio — format, validate, and explore JSON before exporting
• JSON to YAML — convert JSON to YAML for configuration files
• YAML to JSON — parse YAML into JSON for further processing
• JSON Diff — compare two JSON documents side by side