What if my JSON isn't an array?

The tool will wrap a single object into a one-row CSV; anything else surfaces a clear error.

How are commas inside strings handled?

PapaParse escapes and quotes them per RFC 4180.

How are nested objects handled?

They are flattened into dotted column names such as user.address.city, so the original hierarchy stays readable in the header row and can be reconstructed later.

What happens to arrays inside a record?

Arrays are serialised into a single cell as JSON text. CSV has no native concept of a repeated value, so preserving the original notation is the only lossless option.

Will Excel mangle my data?

Fields are quoted and escaped per RFC 4180, which covers commas, quotes and newlines. Excel may still reformat values that look like dates or long numbers — import the file rather than double-clicking it, and set those columns to Text.

JSON to CSV Converter

Turn arrays of JSON objects into spreadsheet-ready CSV. Nested objects can be flattened using dot notation so every property gets its own column.

Last updated: 2026-07-21 · Runs 100% in your browser

flatten nested

Input0 chars · 0 lines

Output

Result will appear here.

// What is the JSON to CSV?

The JSON to CSV converter turns an array of objects into a spreadsheet-ready table. It walks every record to build the complete column set, so a field that only appears in some objects still gets its own column with empty cells elsewhere rather than silently disappearing. Nested objects are flattened using dotted paths such as user.address.city, which keeps the relationship visible in the header row. Values containing commas, quotes or newlines are escaped according to RFC 4180 so the file opens correctly in Excel, Numbers, Google Sheets and any standard CSV parser. Conversion happens entirely in your browser, which means customer exports and internal reports never touch a third-party server on their way to a spreadsheet.