JSON to CSV, instantly.

When you need JSON to CSV

APIs return JSON. Spreadsheet users expect CSV. The gap between the two formats shows up constantly in real work — a developer exports user data from a REST endpoint and the marketing team needs it in Excel. A data analyst fetches results from an analytics API and has to load them into a reporting tool that only accepts CSV. A product manager pulls a JSON export from a SaaS product and needs to review it without writing a single line of code.

This converter handles the translation instantly. Paste your JSON array, click convert, and download a CSV that opens cleanly in any spreadsheet app — no Python script, no online service that stores your data, no dependency on a developer being available.

How JSON to CSV conversion works

A JSON array of objects maps naturally to a table. Each object in the array becomes one row. The keys of those objects become the column headers. The values become the cells.

For example, this JSON:

[
  { "name": "Alice", "role": "Designer", "joined": "2023-01" },
  { "name": "Bob",   "role": "Engineer", "joined": "2022-06" }
]

Becomes this CSV:

name,role,joined
Alice,Designer,2023-01
Bob,Engineer,2022-06

Fields that contain commas or line breaks are automatically wrapped in double-quotes per the RFC 4180 standard, so the output is always valid and safe to import.

How to convert JSON to CSV

1. 1

   Paste your JSON

   Paste a JSON array of objects into the text area. Each object in the array becomes one row in the CSV.

2. 2

   Click Convert

   The conversion runs instantly in your browser. No data is sent anywhere.

3. 3

   Copy or download the CSV

   Use Copy CSV to paste directly into a spreadsheet app, or Download .csv to save the file.

Common use cases

• →Export API responses to share with non-technical teammates who work in Excel
• →Convert database query results (JSON format) for import into BI tools like Tableau or Power BI
• →Turn a JSON export from a SaaS tool (Notion, Airtable, HubSpot) into a spreadsheet
• →Prepare JSON data for import into tools that only accept CSV — email platforms, ad managers, CRMs
• →Log analysis: convert structured JSON logs into tabular form for filtering and sorting
• →Transform e-commerce order data for accounting or fulfillment systems

Handling nested JSON

Flat arrays of objects convert perfectly. Nested objects — objects inside objects — require a flattening step first, because CSV has no way to represent hierarchy.

If your JSON looks like this:

[{ "user": { "name": "Alice", "email": "alice@example.com" }, "score": 42 }]

Flatten it before converting — pull nested keys to the top level using dot-notation names:

[{ "user.name": "Alice", "user.email": "alice@example.com", "score": 42 }]

You can do this manually for small datasets or use a quick JavaScript snippet in your browser console for larger ones.

JSON to CSV vs CSV to JSON — which direction do you need?

JSON to CSV is for getting data out of a developer tool and into a spreadsheet. CSV to JSON is for the reverse — taking a spreadsheet export and loading it into an application that expects JSON. Both directions are available on this site, free and private.

Related tools

• CSV to JSON — go the other direction, from spreadsheet to JSON
• CSV to Excel — convert to .xlsx spreadsheet once you have a CSV