---
title: "JSON to CSV Converter - Free Online Tool | CanDoYa"
description: "Free online JSON to CSV converter. Paste a JSON array or object and get downloadable CSV instantly. Private, no upload, no sign-up."
url: https://candoya.com/tools/json-to-csv/
locale: en
type: browser-tool
---

# JSON to CSV Converter

Category: Developer

## How do you convert JSON to CSV?

Paste a JSON array or object into the converter and it turns the data into a CSV table. Object keys become column headers, nested objects can flatten into dotted columns, and strings with commas, quotes or line breaks are escaped correctly. Everything runs in your browser, so your data is not uploaded.

JSON is flexible and can nest objects, arrays and mixed values. CSV is a rectangular table. This tool bridges that gap by reading your JSON, collecting every column name it finds, and writing a header row plus one CSV row per item. Nested objects can become dotted headers such as `address.city`, while arrays and deeper structures stay as compact JSON inside a cell.

The conversion runs locally in JavaScript. You can paste private API responses, exports or config fragments without sending them to a server.

## How to use it

1. **Paste your JSON** - Paste a JSON array, a single object or a scalar value into the input panel.
2. **Choose CSV options** - Pick comma, semicolon or tab output, keep nested objects flattened, and add a UTF-8 BOM if your spreadsheet app needs it.
3. **Copy or download** - The CSV updates live. Copy it to the clipboard or download it as a .csv file.

## Who it's for

- **Developers** turning an API response into a quick spreadsheet for debugging, QA or documentation.
- **Data and operations teams** cleaning lightweight JSON exports before opening them in Excel, Google Sheets or BI tools.
- **Product and support teams** converting event logs, webhook payloads or customer records into a readable table.

## Expert note

CSV has no native nested object type, so the safest default is to flatten objects into dotted headers and keep arrays as JSON strings inside cells. That preserves the original values while still producing a table that spreadsheet apps can open.

## Frequently asked questions

### Is this JSON to CSV converter free?

Yes. The converter is free, runs in your browser and does not require an account. Paste your JSON, adjust the delimiter if needed, then copy or download the CSV output.

### Is my JSON uploaded anywhere?

No. The conversion happens locally in your browser with JavaScript. Your pasted JSON is not sent to CanDoYa or any external service, which makes it suitable for private API responses and internal exports.

### What JSON shape works best for CSV?

An array of objects works best because each object becomes one row and each key becomes a column. A single object is converted into one row, and an array of strings or numbers becomes a one-column CSV with the header value.

### How are nested objects converted?

With Flatten nested objects enabled, nested keys become dotted column names such as address.city or profile.name. If you turn flattening off, nested objects are kept as JSON strings inside a single cell.

### How are commas, quotes and line breaks escaped?

Fields that contain the delimiter, a double quote, a line break or leading or trailing whitespace are wrapped in double quotes. Embedded double quotes are doubled, which is the standard CSV escaping rule used by spreadsheets.

### Why add a UTF-8 BOM?

Some versions of Excel detect UTF-8 more reliably when a CSV file starts with a byte order mark. Leave it off for most tools; turn it on if accents, CJK text or emoji look wrong after opening the file.

## Related tools

- [JSON Formatter](https://candoya.com/tools/json-formatter/)
- [JSON Validator](https://candoya.com/tools/json-validator/)
- [CSV to YAML Converter](https://candoya.com/tools/csv-to-yaml/)
- [JSON to YAML Converter](https://candoya.com/tools/json-to-yaml/)
- [JSON Minifier](https://candoya.com/tools/json-minifier/)

---

*Markdown edition of <https://candoya.com/tools/json-to-csv/>, published for AI agents and other automated readers. Index of key pages: <https://candoya.com/llms.txt>.*