Converter Knowledge Base

JSON to CSV Converter: Flatten JSON Arrays to CSV Instantly

Convert JSON arrays to CSV spreadsheets online. Handles nested objects, custom delimiter, and header auto-detection. Free, 100% client-side, no upload required.

Why Convert JSON to CSV?

JSON is ideal for API data exchange but difficult to analyse in spreadsheet tools like Excel, Google Sheets, or Tableau. Converting JSON arrays to CSV unlocks pivot tables, charts, and data analysis workflows without writing code.

How JSON-to-CSV Flattening Works

Each object in the JSON array becomes one row. Each unique key across all objects becomes a column header. Nested objects are flattened using dot notation (e.g., address.city). Missing values are left blank.

Supported Input Formats

  • Array of flat objects: [{"id":1,"name":"Alice"}, ...]
  • Array of nested objects (auto-flattened with dot notation)
  • Single object (outputs one data row)

Step-by-Step: Export JSON to CSV

  1. Paste your JSON array or upload a .json file.
  2. Preview the column headers auto-detected from the data.
  3. Select delimiter: comma, semicolon, or tab.
  4. Click Download CSV to get a ready-to-open spreadsheet file.

Try Our Free Client-Side Developer Tools

Zero latency, 100% data privacy, and Web Worker performance.

Launch Tool

Frequently Asked Questions

Can I convert nested JSON to CSV?

Yes. Nested objects are flattened using dot notation. For example, {"address":{"city":"London"}} becomes a column named address.city.

What delimiters are supported?

Comma (standard CSV), semicolon (European locale), and tab (TSV) delimiters are all supported.

Does the converter handle arrays inside objects?

Arrays of primitive values are joined as a single cell value. Arrays of objects create additional flattened columns.

Can I open the CSV directly in Excel?

Yes. The downloaded CSV file opens directly in Microsoft Excel, Google Sheets, LibreOffice Calc, and Numbers.

Related JSON Topics & Reference Articles