JSON TOOL · CLIENT-SIDE
JSON to CSV Converter
Convert an array of JSON objects into a clean CSV spreadsheet. Preview the result, then download or copy. Handles nested objects with dot-notation flattening.
JSON Input
CSV Output
How JSON to CSV conversion works
The tool parses your JSON array, extracts all unique keys as column headers, and writes each object as a CSV row.
Nested objects are flattened using dot-notation (e.g., address.city).
Arrays within objects are serialized as JSON strings inside the cell.
API exports
Convert REST API responses into spreadsheets for analysis.
Database dumps
Export MongoDB or Firestore documents to CSV for Excel.
Data migration
Move data between systems using CSV as an interchange format.
Frequently Asked Questions
What format should my JSON be in?
The JSON should be an array of objects, where each object represents a row and its keys become column headers. Example: [{"name":"Alice","age":30},{"name":"Bob","age":25}].
Can I convert nested JSON?
Nested objects are flattened into dot-notation columns (e.g., address.city). Deeply nested arrays are converted to JSON strings within the CSV cell.
How do I import CSV to a spreadsheet?
Download the CSV file and open it in Excel, Google Sheets, or any spreadsheet application. Most apps auto-detect the comma delimiter and column headers.