What JSON format works best for CSV conversion?

A JSON array of similarly shaped objects works best. Each object becomes a row and object keys become CSV headers.

How are nested JSON objects handled?

Nested objects are flattened into dotted column names such as profile.city. This keeps the output as a simple table while preserving where each value came from.

How are arrays converted to CSV cells?

Array values are joined into a single CSV cell with semicolons. This is useful for tags and roles, but line-item arrays may need a different data model.

Is my JSON data uploaded?

No. JSON parsing and CSV generation run locally in your browser after the page loads. Your JSON is not uploaded for conversion.

Can I convert nested JSON to CSV online?

Yes. Nested objects are flattened into dotted column names, and arrays are joined into single cells so the output remains a simple CSV table.

JSON to CSV Converter Online

Paste a JSON array of objects and convert it to CSV online with nested fields, arrays, and escaped values handled in your browser. Download the result as a file or copy it to the clipboard.

JSON Input

CSV Output

How to Use

Paste a JSON array of objects into the left panel.
Click Convert to CSV.
The CSV result appears on the right.
Click Copy to copy to clipboard or Download to save as a file.

Example Conversion

JSON input

[{
  "name": "Alice",
  "profile": { "city": "New York" },
  "skills": ["JSON", "CSV"]
}]

CSV output

name,profile.city,skills
Alice,New York,JSON; CSV

Conversion Rules

Objects become rows

The input should be a JSON array. Each object in the array becomes one CSV row, and object keys become column headers.

Nested keys use dot notation

Nested objects are flattened into headers such as user.name or profile.city.

Arrays are joined

Array values are joined with semicolons so the result remains a simple CSV cell.

CSV values are escaped

Values containing commas, quotes, or line breaks are wrapped and escaped using standard CSV quoting rules.

Before You Convert JSON to CSV

CSV works best when every record has a similar shape. Before converting a large API response, identify the array that actually contains the rows you want. A full API response often includes metadata, pagination, and nested objects around the real dataset.

Pick the row array

Convert items, users, or orders instead of the entire wrapper object when an API response contains pagination metadata.

Check nested fields

Nested objects become dotted columns. Confirm that headers such as profile.city match the import system you plan to use.

Review arrays

Arrays are joined into one cell. That is useful for tags or roles, but not ideal for line items that should become separate rows.

Common JSON to CSV Workflows

API response review

Convert a sample response into CSV so product, support, or operations teams can inspect records in a spreadsheet without reading nested JSON manually.

Import template preparation

Flatten JSON into columns, then rename headers to match the import template used by a CRM, analytics platform, or internal admin tool.

Test fixture sharing

Convert small JSON fixtures into CSV when reviewers need a compact table, then keep the original JSON for automated tests.

Data cleanup handoff

Move structured records into a spreadsheet for manual cleanup, then convert the cleaned CSV back to JSON when the data needs to return to an app or script.

Features

Flattens Nested Objects

Nested JSON objects are flattened with dot notation into column headers automatically.

Handles Arrays

Array values within objects are joined with semicolons for clean CSV output.

Download as CSV

Export the result as a .csv file ready for Excel, Google Sheets, or any spreadsheet app.

Frequently Asked Questions

What JSON format is supported?

The tool expects a JSON array of objects. Each object becomes a row in the CSV. Keys become column headers.

Is my data sent to a server?

No. The conversion happens entirely in your browser after the page loads. Your JSON is never uploaded for conversion.

Can I convert nested JSON to CSV?

Yes. Nested objects are flattened into dotted headers, and arrays are joined into one cell so the CSV stays spreadsheet-friendly.

Can I open the CSV in Excel?

Yes. Download the result as a .csv file, then open it in Excel, Google Sheets, Numbers, or any spreadsheet application.

What happens if objects have different keys?

The converter builds a combined header list from every row. Missing values are left blank in rows where a key does not exist.

Can this convert deeply nested JSON?

It can flatten nested objects into dotted headers. For deeply nested arrays such as order line items, decide whether those arrays should stay in one cell or be exported as a separate table.

Why does my API response not convert?

The input must be an array of objects. If your response is an object with fields like data or items, copy the array inside that field and convert it instead.