JSON to CSV Converter

Convert JSON data to CSV format

JSON to CSV Converter transforms your JSON arrays and objects into CSV (Comma-Separated Values) format. Perfect for importing data into spreadsheets like Excel or Google Sheets, database imports, or data analysis tools. Supports nested objects, custom delimiters, and automatic header generation.

JSON Input

json
1
0 characters • 1 linesUTF-8

CSV Output

plaintextRead only
1
0 characters • 1 linesUTF-8

About JSON to CSV Conversion

Input Format: The tool accepts JSON arrays of objects (most common) or single objects. Each object in the array becomes a row in the CSV, and object keys become column headers.

Nested Objects: When "Flatten nested objects" is enabled, nested properties are converted to dot notation (e.g., address.city). Arrays within objects are converted to JSON strings.

Delimiter Options: Choose between comma (,), semicolon (;), or tab delimiters. Use semicolon for European locales where comma is used as decimal separator.

Special Characters: Values containing the delimiter, quotes, or newlines are automatically escaped and wrapped in double quotes following RFC 4180 standard.