JSON to CSV Converter

Paste an array of JSON objects to instantly convert them into a flat CSV (Comma Separated Values) format, ready to be opened in Microsoft Excel, Google Sheets, or imported directly into a relational SQL database.

Nested objects and arrays are dynamically flattened into dot-notation columns (e.g., address.city or user.profile.name). Processing happens instantly in memory and your highly sensitive JSON payloads are never stored, never logged, and never sent anywhere else.

How it works

JSON is inherently hierarchical and deeply nested, while CSV is completely flat and two-dimensional. To successfully bridge this gap, this tool comprehensively scans the entire JSON payload to discover all possible keys across every single object before writing the final CSV headers. This guarantees that even if a specific key only appears in the very last object of an array, it still gets a dedicated column in the resulting spreadsheet.

Flattening: If an object contains another nested object, the keys are seamlessly combined with a dot. For example, {"user": {"name": "Alice"}} becomes a single column cleanly named user.name. If an array of simple string or integer values is found, it is joined with commas so you don't lose any nested data.

Encoding: The resulting CSV is perfectly compliant with the standard RFC 4180 format. Quotes, commas, and multiline string newlines inside your data values are safely escaped so that spreadsheet software imports the file flawlessly without breaking rows.

Frequently asked questions