Skip to content
Utilerio

JSON to CSV

Flatten a JSON array into a CSV that opens cleanly in Excel.

Without it, Excel on Windows can show accented characters incorrectly.

CSV output

The result will appear here.

Was this tool useful?

About this tool

Exporting JSON to CSV is what you do when the data has to reach a spreadsheet: an accountant, a marketplace bulk upload, a supplier who works in Excel. The conversion is straightforward for a flat array of objects and needs a decision as soon as the objects are nested.

This tool flattens nested objects into dotted column names, so { customer: { name: "…" } } becomes a customer.name column rather than a JSON blob inside a cell. Union of all keys across rows becomes the header, so a field missing from one row still gets its column.

How to use it

  1. Paste a JSON array of objects, or upload a .json file.
  2. Choose the delimiter. Semicolon is safer if the file will be opened in Excel on a Turkish or European locale.
  3. Leave the UTF-8 BOM on unless you know the consumer rejects it — it is what makes Excel read accented characters correctly.
  4. Turn flattening off if you would rather keep nested objects as JSON text in a single cell.
  5. Convert and download the .csv file.

Examples

Nested objects flattened to dotted columns

[{ "sku": "TL-001", "stock": { "warehouse": 12, "shelf": 3 } }]
sku,stock.warehouse,stock.shelf
TL-001,12,3

Common problems

Turkish characters appear as mojibake in Excel.
Excel on Windows assumes the system codepage unless the file starts with a UTF-8 byte-order mark. Keep the BOM option on.
Everything lands in column A.
Excel splits on the list separator from your regional settings, which is a semicolon in Turkish Windows. Export with semicolons, or use Data → From Text and pick the delimiter.
The input is refused because it is not an array.
CSV is a table, so it needs a list of rows. Wrap a single object in square brackets, or select the array inside your document first.

Frequently asked questions

Related tools

File Conversion Tools

CSV to JSON

Convert a CSV file or pasted rows into a JSON array.

Developer Tools

JSON Formatter

Pretty-print or minify JSON, with the exact position of any syntax error.

File Conversion Tools

JSON to XML

Turn JSON into well-formed XML with a root element you choose.

File Conversion Tools

Excel ↔ CSV / JSON Converter

Export an Excel sheet as CSV or JSON, or build a new .xlsx file from CSV or JSON data.