---
title: "JSON to CSV Converter for Arrays of Objects | ToolSugar"
description: "Convert a JSON array of objects into CSV in your browser. Uses the union of all keys, quotes cells correctly and says when nested values were stringified."
canonical: https://toolsugar.com/tools/json-to-csv
image: https://toolsugar.com/og.png
---

# JSON to CSV

This converter turns a JSON array of objects into CSV in your browser. The header row is the union of every key in the array, in first seen order, and cells are quoted when they hold the delimiter, a quote or a line break. Nested objects and arrays are written as JSON text, and the page tells you when that happens.

Runs on your device

## How it works

1. Paste a JSON array of objects into the box, or open a .json file.
2. Pick a Delimiter: comma, semicolon, tab or pipe.
3. Check the CSV on the right, and read the note if nested values were written as JSON.
4. Copy the CSV or press Download to save data.csv.

## Key facts

- **Where it runs**: In your browser tab. The text and files you use are never uploaded.
- **Live result**: The output updates as you type or paste, with no button to press.
- **Input shape**: A top level array whose items are all objects. Anything else shows an error.
- **Nested values**: Objects and arrays inside a cell are written as JSON text, not flattened into columns.

## Common uses

- Opening an API response in a spreadsheet.
- Handing a list of records to someone who works in Excel.
- Building a quick import file for a tool that only takes CSV.

## Questions

### Is my data sent to a server?

No. The conversion runs in your browser with JavaScript, so what you paste or open stays on your device. You can switch off your network after the page loads and it keeps working.

### What if objects have different keys?

The header holds every key found in any object. An object that lacks a key gets an empty cell in that column.

### Why does my JSON give an error?

CSV needs rows, so the input must be an array of objects like \[{"a": 1}\]. A single object, an array of numbers or an array of arrays is rejected with a message that says so.

### How are nested objects handled?

They are not flattened. The whole nested value is written into its cell as compact JSON text and properly quoted, and a note under the result tells you it happened.

[Read the JSON to CSV guide](https://toolsugar.com/blog/how-to-convert-json-to-csv)

## Related tools

- [CSV to JSON](https://toolsugar.com/tools/csv-to-json)
- [JSON Formatter](https://toolsugar.com/tools/json-formatter)
- [JSON to YAML](https://toolsugar.com/tools/json-to-yaml)
- [XML to JSON](https://toolsugar.com/tools/xml-to-json)
