# JSON to CSV Converter

URL: https://tools.otaku-dojo.com/en/json-to-csv
Updated: 2026-10-03

The JSON to CSV converter turns each object in a JSON array into a row and each field into a column. Nested objects are flattened into columns such as "address.city", and arrays are kept as JSON strings. The downloaded CSV includes a UTF-8 BOM so Excel displays non-English text correctly.

## How to use the JSON to CSV Converter

1. Paste a JSON array on the left, such as data returned by an API.
2. Choose a delimiter and whether to flatten nested fields and include a header row.
3. Switch between "CSV" text and a "Table" preview of the first 100 rows.
4. Press "Download" to save a .csv you can open in Excel or Google Sheets.

## Specs & key facts

- **Input**: A JSON array, or an object containing an array field (e.g. {"data": [...]})
- **Nested fields**: Flattened to a.b.c columns; arrays kept as JSON strings
- **Delimiters**: Comma, semicolon, tab
- **Output standard**: RFC 4180 with proper quoting
- **Excel**: Downloads include a UTF-8 BOM
- **Processing**: In your browser (nothing is uploaded)

## Examples: Flatten nested objects

```json
[{"id":1,"name":"Amy","address":{"city":"Taipei"}},{"id":2,"name":"Ben","address":{"city":"Tokyo"}}]
```

→

```csv
id,name,address.city
1,Amy,Taipei
2,Ben,Tokyo
```

## FAQ

### What if objects have different fields?

All fields found in any object become columns; missing values are left empty.

### Excel puts everything in one column. Why?

In some regions Excel expects semicolons. Switch the delimiter to semicolon, or import with Excel's Data → From Text/CSV.

### How large a JSON file can it handle?

It depends on your device memory; tens of megabytes are fine on a typical computer. The preview shows 100 rows but the download includes everything.