>Fafa Dev Tools

JSON to CSV Converter

Convert JSON data to CSV format instantly. Free online JSON to CSV converter with automatic header detection and nested object flattening.

0 chars
Output will appear here...

What is JSON to CSV Converter?

JSON to CSV conversion transforms structured JSON data into comma-separated values (CSV) format. CSV is widely used for spreadsheet import (Excel, Google Sheets), data analysis, and database import. This tool handles nested objects by flattening them and automatically detects all headers from the JSON data.

How to Use

  1. Paste your JSON array in the input area
  2. The CSV output appears instantly with auto-detected headers
  3. Nested objects are flattened using dot notation (e.g., user.name)
  4. Download the result as a .csv file
  5. Open in Excel or Google Sheets for further analysis

Examples

Array of objects

Input[{"name":"Alice","age":30},{"name":"Bob","age":25}]
Outputname,age Alice,30 Bob,25

Nested data

Input[{"user":{"name":"Alice"},"score":95}]
Outputuser.name,score Alice,95

Frequently Asked Questions

Does it handle nested JSON objects?

Yes. Nested objects are flattened using dot notation. For example, {"user":{"name":"Alice"}} becomes the column header "user.name" with value "Alice". Arrays within objects are stringified.

What if my JSON is not an array?

If you paste a single JSON object, it will be wrapped in an array automatically. The tool needs at least one object to generate CSV headers.

How are special characters handled?

Fields containing commas, double quotes, or newlines are automatically wrapped in double quotes per CSV standards. Double quotes within fields are escaped as two double quotes.