JSON to CSV Converter

Convert JSON arrays to CSV — preview, reorder columns, download, and customise delimiter

Instant conversion | 100% client-side
JSON Input
CSV Output
Reorder Columns — drag order affects the preview and downloaded file
Preview

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), quote character, toggle headers and nested flattening — the CSV updates in real time.

3

Preview, Reorder & Download

Verify your data in the live preview table, drag columns into the right order, then click "Download .csv" or "Excel (UTF-8 BOM)" to save the file.

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 and open it in Microsoft Excel, Google Sheets, LibreOffice Calc, or any spreadsheet application. For best results with special characters and accents, use the Excel (UTF-8 BOM) button — it prepends the Unicode BOM marker so Excel auto-detects UTF-8 encoding without a manual import wizard.
By default, nested objects are flattened using dot notation. For example, {"address": {"city": "NY", "zip": "10001"}} produces two columns: address.city and address.zip. Toggle Flatten nested off to instead JSON-stringify the nested object into a single 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. After conversion, the Reorder Columns panel appears below the editor. Use the left/right arrow buttons next to each column name to rearrange them. The preview table updates instantly, and the downloaded CSV reflects the new column order.
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.