Converters
JSON to CSV Converter
Turn a JSON array of objects into clean, quoted CSV.
Paste valid JSON above and click Convert to CSV.
What is the JSON to CSV Converter?
APIs speak JSON, but spreadsheets speak CSV. When you need to open API data in Excel or Google Sheets, this free converter turns a JSON array of objects into clean, properly quoted CSV — commas inside values get quoted, quotes get escaped, and nested objects become compact JSON strings, so your spreadsheet columns stay perfectly aligned.
How to use it
- Paste your JSON array of objects into the input box.
- Click Convert to CSV.
- Review the output, then Copy it or Download it as a .csv file.
- Open the file in Excel or Google Sheets — columns line up automatically.
Key features
- Proper RFC-style quoting: commas, quotes and newlines inside values are escaped.
- Handles ragged data — missing keys become empty cells, extra keys become columns.
- Nested objects and arrays are preserved as JSON strings in their cell.
- Single objects are auto-wrapped into a one-row table.
- Clear, specific error messages for invalid JSON.
- UTF-8 BOM in downloads so Excel shows non-English text correctly.
Real-world use cases
- Turning API responses into spreadsheets for reporting.
- Preparing product or customer lists for import into other tools.
- Sharing structured data with colleagues who only use Excel.
- Quickly inspecting JSON data in a familiar grid view.
Practical tips
- If your JSON is one giant object instead of an array, the tool wraps it into a single row automatically.
- Validate tricky JSON first — the error message tells you exactly where parsing failed.
- For deeply nested data, flatten it first or expect JSON strings in those cells.
- Google Sheets: File → Import → Upload the downloaded CSV for the cleanest result.
Frequently Asked Questions
What JSON format does it accept?
An array of objects, like [{"name":"Komil"},{"name":"Saba"}]. A single object also works — it becomes one row. Arrays of plain numbers or strings are rejected with a clear message.
How are commas inside values handled?
Any value containing a comma, quote or line break is wrapped in double quotes, and inner quotes are doubled — the standard CSV escaping that Excel and Google Sheets expect.
What happens to nested objects?
They are converted to compact JSON strings inside their cell, so no data is lost. If you need each nested field as its own column, flatten the JSON first.
Why does the download include a BOM?
The UTF-8 byte-order mark tells Excel to read the file as UTF-8, so Urdu, Arabic and other non-English text displays correctly instead of as garbled characters.
Is my data uploaded anywhere?
No. Conversion runs entirely in your browser with JavaScript. Your JSON never leaves your device.