JSON to CSV Converter

Turn a JSON array of objects into a spreadsheet-ready CSV. Paste your JSON below, convert, then copy the CSV or download it as a file for Excel or Google Sheets.

json-to-csv · runs locally

What this JSON to CSV converter does

APIs speak JSON; spreadsheets speak CSV. This converter bridges the two: paste a JSON array of objects — the shape almost every REST endpoint returns for list data — and it produces a comma-separated file with one row per object and one column per key. Keys are collected across the whole array, so records with missing or extra fields still line up under the correct headers.

Values are escaped according to the CSV standard (RFC 4180), which means text containing commas, quotes or line breaks survives the round trip into Excel, Google Sheets, Numbers or any data tool that imports CSV.

How to convert JSON to CSV online

  1. Paste your JSON array into the input box.
  2. Click Convert to CSV and review the output.
  3. Click Download .csv to save a file, or copy the text directly.
  4. Open the file in Excel or import it into Google Sheets.

Typical uses

Analysts convert API exports into spreadsheets for reporting; marketers turn JSON contact lists into CSV for CRM imports; developers snapshot endpoint responses as CSV fixtures. If your JSON fails to convert, validate it first with the JSON Validator — a stray trailing comma is the usual culprit.

Frequently asked questions

What JSON structure does the converter expect?

An array of objects, where each object becomes one CSV row and each unique key becomes a column. A single object also works and produces a one-row CSV. Objects with different keys are merged: the header row is the union of all keys, and missing values become empty cells.

How are nested objects and arrays handled?

Nested values are serialized as JSON strings inside the cell, wrapped in quotes so the CSV stays valid. If you need nested fields as separate columns, flatten the JSON before converting.

Will the CSV open correctly in Excel and Google Sheets?

Yes. The output follows RFC 4180: commas separate fields, and any value containing a comma, quote or newline is wrapped in double quotes with inner quotes doubled. Both Excel and Google Sheets import it cleanly.

Is my data uploaded anywhere during conversion?

No. Parsing and conversion happen in JavaScript inside your browser, and the download is generated locally as a Blob. Your data never touches a server, which makes the tool safe for exports containing customer or business data.

CSV to JSON Converter

Turn CSV data into a JSON array of objects, with automatic type detection.

Open tool →

JSON to YAML Converter

Convert JSON documents into clean, indented YAML.

Open tool →

JSON Formatter

Beautify and pretty-print JSON with 2-space, 4-space, or tab indentation.

Open tool →