Free Online JSON to CSV Converter

Convert a JSON array of objects to CSV format instantly. Auto-detects column headers from object keys and generates properly escaped CSV output.

How the JSON to CSV Converter Works

This tool extracts all unique keys from objects to create the header row. Each object becomes a CSV row with values properly escaped following RFC 4180 conventions.

JSON Input Format

The input must be a JSON array of objects with string keys and simple values. Nested objects are converted to string representation. Missing keys result in empty cells.

CSV Escaping and Formatting

Fields containing commas, double quotes, or newlines are enclosed in double quotes. Double quotes within fields are escaped by doubling. Compatible with Excel, Google Sheets, and LibreOffice Calc.

Frequently Asked Questions

What JSON format does it accept?

A JSON array of objects like [{"name":"John"},{"name":"Jane"}]. Cannot convert single objects, nested arrays, or primitive values.

What if objects have different keys?

All unique keys are collected for the header row. Missing keys produce empty CSV cells.

How are nested objects handled?

Nested objects and arrays are converted to their JSON string representation in the CSV cell.

Can I open the output in Excel?

Yes. The CSV follows standard formatting with proper quoting. Save as .csv and open in any spreadsheet application.

Is there a size limit?

Depends on browser memory. Several thousand objects work well on modern devices.

Free Online JSON to CSV Converter

How the JSON to CSV Converter Works

JSON Input Format

CSV Escaping and Formatting

Related Tools

Frequently Asked Questions