JSON to CSV Converter

How to use

1. 1Paste your JSON into the input on the left, or click Load sample to try a small example with nested fields.
2. 2Pick a delimiter (comma, semicolon, tab, or pipe) and a line ending (LF or CRLF) to match the spreadsheet or downstream tool you are exporting for.
3. 3Choose how nested values should be handled: Flatten with dotted keys to expand them into columns, or Keep as JSON strings to keep one cell per value.
4. 4Toggle Include header row, Quote every field, and Add UTF-8 BOM as needed; the BOM helps Excel for Windows open Unicode CSVs without garbled accents.
5. 5Use Copy CSV to copy the result to your clipboard, or click Download .csv (or .tsv with the tab delimiter) to save the file directly.

About this tool

JSON to CSV Converter turns any JSON document into a clean, RFC 4180-compliant CSV that opens correctly in Excel, Google Sheets, Numbers, and any data tool that consumes CSV. Paste a JSON array of objects (the canonical export shape from most APIs), an array of arrays, an array of values, a single object, or a wrapped envelope like { "data": [ ... ] } and the tool detects the shape automatically and emits one CSV row per element. Nested objects and arrays are the usual sticking point in this conversion, so the tool offers two strategies: flatten with dotted keys turns a value like { address: { city: "London" } } into a column named address.city and an array like { tags: ["a", "b"] } into columns tags.0 and tags.1, while keep as JSON strings preserves the nested structure inside a single cell so downstream tools can re-parse it later. CSV output options cover every common spreadsheet quirk: switch the delimiter between comma, semicolon, tab, or pipe; pick LF or CRLF line endings; toggle whether the first row is a header; choose to quote every field for strict consumers; and prepend a UTF-8 byte order mark so Excel for Windows opens accented characters and emoji correctly instead of mojibake. Headers are built from the union of keys across every row in first-seen order, so a ragged dataset still produces a complete CSV with no missing columns. The result panel shows live row count, column count, byte size, and the detected JSON shape, plus a one-click download for .csv (or .tsv when the tab delimiter is chosen) and a copy-to-clipboard button. Useful for exporting API responses to spreadsheets, preparing JSON data for analytics pipelines, converting NDJSON-style logs after pasting them as an array, building Excel-friendly downloads from web app state, sharing structured data with non-technical teammates, and seeding databases or BI tools that import CSV. Conversion is performed entirely in your browser, so confidential payloads (API tokens inside JSON, customer records, transaction data, internal config) never leave your device.

Free to use. Works in your browser. No signup, no login.