JSON to CSV Converter

Convert JSON arrays to CSV — download, copy, and customise delimiter

Instant conversion | 100% client-side
JSON Input
CSV Output

How the JSON to CSV Converter Works

Three simple steps to turn your JSON data into a spreadsheet-ready CSV file

1

Paste Your JSON

Paste a JSON array of objects into the input panel. Click the Example button to load sample data and see the expected format instantly.

2

Choose Options

Select your delimiter (comma, tab, semicolon, or pipe), toggle headers, and choose whether to quote all fields — the CSV updates in real time.

3

Download or Copy

Click "Download .csv" to save the file, or copy the CSV to your clipboard and paste it straight into Excel, Google Sheets, or any text editor.

Supported JSON Formats

This converter handles the most common JSON structures you'll encounter in APIs and data exports

Array of Objects

The most common format. Each object in the array becomes one CSV row. Object keys are collected across all rows to form the column headers.

[
  {"name":"Alice","age":30},
  {"name":"Bob","age":25}
]

Nested Objects

Nested objects are automatically flattened using dot notation. Deep nesting is resolved recursively so every value reaches a CSV column.

[
  {"name":"Alice",
   "address":{"city":"NY"}}
]
→ name, address.city

Primitive Arrays

Arrays of strings or numbers (not objects) are supported too. Each element becomes a row under a single "value" column.

["apple","banana","cherry"]

→ value
apple
banana

Frequently Asked Questions

Common questions about converting JSON to CSV online

This tool supports JSON arrays of objects — the most common format returned by REST APIs and data exports. Each object becomes a CSV row, and the object keys become column headers. Nested objects are automatically flattened using dot notation (e.g. address.city). Arrays of primitive values (strings or numbers) are also supported.
Yes. Click the Download .csv button to save the converted file, then open it in Microsoft Excel, Google Sheets, LibreOffice Calc, or any other spreadsheet application. CSV is a universally supported interchange format that all major spreadsheet tools can import without any additional steps.
Nested objects are flattened using dot notation. For example, {"address": {"city": "NY", "zip": "10001"}} produces two columns: address.city and address.zip. The flattening is applied recursively, so deeply nested structures are fully resolved. Arrays inside objects are serialised as JSON strings in the corresponding cell.
You can choose from four delimiters: comma (standard CSV, compatible with most tools), tab (produces a TSV file, useful when values contain commas), semicolon (common default in European locales of Excel), and pipe (useful for data that already contains commas and semicolons). Select the delimiter that best suits your target application.
Yes, completely. All JSON parsing and CSV generation happens entirely in your browser using JavaScript. No data is transmitted to any server, stored in any database, or logged anywhere. You can verify this by opening your browser's Developer Tools Network tab — no requests are made when you convert. The tool also works offline once the page has loaded.