Otaku Dojo Tools
English

JSON to CSV Converter

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.

  • Free
  • No sign-up
  • Runs in your browser
Delimiter
JSON
CSV
Results appear as you typeShortcut: Ctrl + Enter to run

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.

Examples

Flatten nested objects

Input
[{"id":1,"name":"Amy","address":{"city":"Taipei"}},{"id":2,"name":"Ben","address":{"city":"Tokyo"}}]
Output
id,name,address.city
1,Amy,Taipei
2,Ben,Tokyo

Specs & key facts

InputA JSON array, or an object containing an array field (e.g. {"data": [...]})
Nested fieldsFlattened to a.b.c columns; arrays kept as JSON strings
DelimitersComma, semicolon, tab
Output standardRFC 4180 with proper quoting
ExcelDownloads include a UTF-8 BOM
ProcessingIn your browser (nothing is uploaded)

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.