JSON to CSV
Convert a JSON array of objects to CSV, with delimiter choice and nested-data flattening.
Processed locally in your browser. Your data is never uploaded.
- Handles objects with differing keys by building a superset header row.
- Flattens nested objects into dot-notated columns (`user.id`) by default, or keep nested data as raw JSON text instead.
- Choose comma, semicolon (for European Excel), tab or pipe as the delimiter — the same options as this site's CSV Formatter, so you don't need a second pass through that tool.
- Neutralizes values starting with `=`, `+`, `-` or `@` so Excel/Sheets can't misinterpret a cell as a formula (CSV injection protection).
- Quotes values that contain commas, quotes or newlines so the CSV stays valid.
- Runs in your browser — no upload.
Why this is private
- Processed locally in your browser. Your data is never uploaded.
- Open your browser's DevTools → Network tab while using this tool — you won't see a request carrying your input, because it never leaves your device.
- Nothing you enter is uploaded to a server or shared with us — the processing happens entirely on your device.
Overview
Converts a JSON array of objects into CSV — column headers are taken from the union of all object keys, nested objects are flattened into dot-notated columns by default, and you can pick comma, semicolon, tab or pipe as the delimiter.
How to use it
- 1Paste a JSON array of objects.
- 2Pick a delimiter and how nested data should be handled.
- 3Copy or download the CSV output.
Frequently asked questions
What people use it for
Open an API response in a spreadsheetConvert a JSON list to CSV to sort, filter and chart it in Excel or Sheets — nested fields become their own columns automatically.
Convert for European ExcelPick the semicolon delimiter directly instead of converting to comma-CSV and re-running it through the CSV Formatter.
Hand data to a non-technical colleagueCSV is easier to share than raw JSON, and injection protection keeps a stray `=` value from becoming a formula in their spreadsheet.
Import JSON data into a tool that only takes CSVMany CRMs and BI tools import CSV but not JSON.
Related tools
All data toolsCSV to JSONConvert CSV data to a JSON array of objects, with a delimiter choice and a header-row toggle.CSV ViewerView a CSV file as a formatted table.CSV FormatterClean up CSV formatting and convert between delimiters.JSON Viewer & FormatterView, format, validate, edit and beautify JSON with an interactive tree view, plus a shareable link.
Ready to use JSON to CSV?
JSON to CSV