JSON → CSVReady

Indent

JSON Input (Array of Objects)(drop file here)

Ln 1, Col 1·0 lines · 0 B

Raw input remains untouched until you click Format⌘↵ to Format

Actions

CSV OutputEditable

Ln 1, Col 1·0 lines · 0 B

Ready to copy (⌘⇧C) or download (⌘S)

JSON to CSV Converter

Convert JSON arrays and nested data to CSV spreadsheets online. Flatten nested hierarchies and download CSV files instantly with zero server uploads.

Nested key flattening

RFC 4180 export

Auto headers

Download .csv

Step-by-Step Guide

How to Use JSON → CSV Online

Follow these quick steps to process your data online directly in your browser with zero latency and 100% privacy.

Step 1Scans all JSON array items to discover all unique column headers.

Step 2Flattens nested object properties into dot-notation column names (e.g. user.address.city).

Step 3Formats cell values according to RFC 4180, enclosing strings with commas in double quotes.

Demonstration

Example Input & Output

Extracts union of keys from all array objects to build the header row, flattening nested objects and escaping commas inside quotes.

JSON Input (Array of Objects)

[
  {
    "id": 1,
    "name": "Alex",
    "role": "Lead",
    "location": "Hyderabad, India"
  },
  {
    "id": 2,
    "name": "John Doe",
    "role": "Developer",
    "location": "London, UK"
  }
]

CSV Output

id,name,role,location
1,Alex,Lead,"Hyderabad, India"
2,John Doe,Developer,"London, UK"

Applications

Common Use Cases

Spreadsheet Export

Import JSON database queries into Excel, Google Sheets, or Numbers.

Analytics & Reporting

Convert API data dumps into CSV tables for Tableau or PowerBI ingestion.

Guidelines

Specifications & Gotchas

Non-Array Top Level

Top-level JSON should ideally be an array of objects to generate tabular rows.

Knowledge

Frequently Asked Questions

Can I convert nested JSON to CSV?

Yes, nested objects are automatically flattened into dot-notated column names.

How are commas inside values handled?

Values containing commas or line breaks are automatically wrapped in double quotes per RFC 4180.

Workflow

Related Tools

All Tools →

CONVERTER

CSV → JSON

Convert CSV spreadsheets to JSON arrays and key-value objects online with header detection and type parsing. Fast browser-based CSV to JSON conversion.

Header row detectionType conversion (num/bool)2D array toggle

Open tool

CONVERTER

JSON → YAML

Convert JSON to YAML online with customizable indentation and clean syntax preservation. Generate YAML configurations from JSON payloads in your browser.

YAML 1.2 compliantIndentation optionsCopy & download

Open tool

CONVERTER