JSON to CSV Converter

Convert JSON arrays of objects to CSV format with automatic nested key flattening.

JSON Input

CSV Output

About This Tool

JSON (JavaScript Object Notation) and CSV (Comma-Separated Values) are two of the most widely used data interchange formats. JSON excels at representing hierarchical and nested data structures, making it the default choice for APIs and configuration files. CSV, on the other hand, is the lingua franca of tabular data — universally supported by spreadsheets, databases, and data analysis tools.

Converting JSON to CSV is a common task when you need to import API data into Excel, Google Sheets, or a SQL database. The main challenge lies in flattening nested structures into a two-dimensional table. This tool handles that automatically by creating dot-notation column headers for nested keys.

Common use cases include exporting API responses for business analysis, preparing datasets for machine learning pipelines, migrating data between systems that speak different formats, and creating human-readable reports from structured data.

Frequently Asked Questions

How does nested JSON get converted to CSV?

Nested objects are flattened using dot notation. For example, {"address": {"city": "Paris"}} becomes a column named "address.city" with the value "Paris".

What happens to arrays inside JSON objects?

Array values are serialized as JSON strings within the CSV field. For instance, [1,2,3] becomes the literal text [1,2,3] in the cell.

Are special characters handled properly?

Yes. Fields containing commas, double quotes, or newlines are wrapped in double quotes, and internal double quotes are escaped by doubling them, per RFC 4180.

Is my data sent to a server?

No. All conversion happens entirely in your browser. Your data never leaves your machine.