JSON to CSV Converter
Browser processing — files never leave your device
Convert a JSON array of objects into CSV that opens cleanly in Excel or Google Sheets, with correct quoting and a stable column order.
Loading tool…
How to use this tool
- Paste a JSON array of objects (or a single object).
- Click Convert to CSV.
- Preview the output.
- Copy it or download a .csv file ready for Excel or Sheets.
About this tool
API responses arrive as JSON; stakeholders want spreadsheets. This converter takes an array of objects, builds the column set from the union of all keys (objects may have different keys), and emits standards-compliant CSV: values containing commas, quotes or line breaks are quoted and escaped so spreadsheets import them intact. Nested objects and arrays are serialized as JSON strings inside their cell, keeping the data lossless.
Frequently asked questions
- What happens to nested objects?
- They are written into their cell as a JSON string, so no data is lost. If you need them flattened into separate columns, restructure the JSON before converting.
- My objects don't all have the same keys — is that a problem?
- No. The columns are the union of every key found; objects missing a key get an empty cell in that column.
- Will Excel mangle values like phone numbers?
- Excel applies its own type guessing on import (e.g. stripping leading zeros). The CSV itself is correct; import the column as text in Excel to preserve such values.
Related tools
CSV to JSONTurn CSV data — pasted or from a file — into a JSON array of objects, using the header row as keys. Quoted fields and embedded commas are handled correctly.JSON FormatterPaste minified or messy JSON and get a cleanly indented, readable version. Invalid JSON produces an error with the line and position of the problem.JSON MinifierStrip every unnecessary space and line break from JSON to get the smallest valid representation — with the size saving shown.