Guide · 4 min read

Flatten Nested JSON to CSV

CSV files are the universal format for spreadsheets, data analysis, and reporting tools. But most APIs and databases return JSON — often with nested objects and arrays. This guide explains how to convert JSON to CSV, how flattening works, and how to handle nested data.

JSON Array

CSV (ready for Excel / Sheets)

[
  {
    "name": "Alice",
    "city": "New York",
    "score": 95,
    "active": true
  },
  {
    "name": "Bob",
    "city": "Los Angeles",
    "score": 87,
    "active": false
  },
  {
    "name": "Carol",
    "city": "Chicago",
    "score": 92,
    "active": true
  }
]

How to Convert JSON to CSV — 3 Steps

Prepare your JSON array

The input must be a JSON array of objects ([ {...}, {...} ]). Each object becomes one row; its keys become the column headers.

Paste into the JSON to CSV converter

Open the JSON to CSV tool and paste your JSON array. The converter detects all keys automatically and builds the header row.

Download the CSV

Click Download to save the .csv file, then open it in Excel, Google Sheets, or any spreadsheet tool. No reformatting needed.

Convert JSON to CSV

How Nested Objects Are Flattened

CSV is a flat format — it has rows and columns but no nesting. When you convert JSON with nested objects, the converter flattens nested keys using dot notation:

Nested JSON

{
  "name": "Alice",
  "address": {
    "city": "NYC",
    "zip": "10001"
  }
}

Flattened CSV

name,address.city,address.zip
Alice,NYC,10001

The nested address object becomes two columns: address.city and address.zip.

How Nested Arrays Are Handled

When a field contains an array of values (e.g. "tags": ["web", "api"]), the converter joins the values into a single cell separated by semicolons:

tags
web;api

For arrays of nested objects, each array element is typically expanded into separate rows or columns, depending on the structure. For complex nested arrays, it is often easier to process the JSON with a script than to flatten it automatically.

Common Use Cases for JSON to CSV Conversion

API data to spreadsheet: Export user lists, orders, analytics events, or any JSON array from an API directly into Excel or Google Sheets for analysis.

Database exports: MongoDB and DynamoDB export data as JSON. Convert to CSV for import into PostgreSQL, MySQL, or a BI tool like Tableau.

Reporting and sharing: Non-technical stakeholders can open CSV files in Excel without any tools. Share data exports as CSV instead of raw JSON.

Data migration: When migrating between systems, CSV is often the lowest-common-denominator import format accepted by almost every platform.

Convert JSON to CSV Now

Paste your JSON array and download a CSV in seconds — free, no sign-up.

Open JSON to CSV