DeveloperKit

JSON to CSV Converter

Convert JSON arrays to CSV for Excel and Google Sheets. Free, private, and 100% in your browser.

Input JSON

CSV Output

CSV output will appear here.

Convert JSON to CSV Online

CSV (comma-separated values) is the universal format for spreadsheets and data imports. When an API returns JSON but you need the data in Excel, Google Sheets, a database import, or a reporting tool, this converter turns your JSON into a clean table in one step.

Features

  • Flatten nested objects

    Nested objects become dot-notation columns such as address.city, so every value gets its own column.

  • Any delimiter

    Use comma, semicolon (common in European Excel), tab (TSV), or pipe delimiters.

  • Correct quoting

    Values with delimiters, quotes, or line breaks are quoted following RFC 4180, so spreadsheets read them correctly.

  • Flexible input

    Works with arrays of objects, a single object, arrays of arrays, and arrays of plain values.

  • Consistent columns

    Columns are collected from every row, so records with missing keys simply get empty cells.

  • Private by design

    The conversion runs entirely in your browser. Your data is never uploaded.

JSON to CSV Example

JSON input
[
  { "id": 1, "name": "Ada", "address": { "city": "London" } },
  { "id": 2, "name": "Alan, Jr.", "address": { "city": "Manchester" } }
]
CSV output
id,name,address.city
1,Ada,London
2,"Alan, Jr.",Manchester

The nested address object is flattened into an address.city column, and the value containing a comma is quoted.

How to Convert JSON to CSV

  1. Paste a JSON array into the input editor, or upload a .json file.
  2. Choose a delimiter and whether to include a header row and flatten nested objects.
  3. The CSV output updates instantly as you type.
  4. Copy the CSV or download it as a .csv file and open it in your spreadsheet app.

Frequently Asked Questions

What JSON structure works best for CSV?

An array of objects, where each object is one row and each key is a column, such as [{"id": 1, "name": "Ada"}]. A single object becomes one row, an array of arrays is written row by row, and an array of plain values becomes a single value column.

How are nested objects and arrays handled?

With Flatten nested objects enabled, nested objects become dot-notation columns, such as address.city. Arrays, and nested objects when flattening is off, are written into a single cell as JSON text.

How do I open the CSV in Excel?

Download the file and open it in Excel, or use Data > From Text/CSV. If your Excel uses a comma as the decimal separator, which is common in Europe, choose the semicolon delimiter so columns split correctly.

What happens if objects have different keys?

The converter collects every key from every object, in the order it first appears. Rows that do not have a value for a column get an empty cell.

Is my JSON uploaded anywhere?

No. The converter runs entirely in your browser using JavaScript. Your JSON never leaves your device.

  • JSON to XML

    Convert JSON to well-formed XML with custom root and item names, attributes, and indentation.

  • JSON to YAML

    Convert JSON to clean, readable YAML for Kubernetes, Docker Compose, CI pipelines, and config files.

  • JSON to Base64

    Encode JSON as Base64 or base64url for headers, tokens, environment variables, and data URIs.

  • Base64 to JSON

    Decode Base64 or base64url back into readable, validated, and pretty-printed JSON.