Convert JSON to CSV Online
JSON arrays of objects are a standard output format for REST APIs, database queries, and data exports, but spreadsheet tools like Excel and Google Sheets, data analysis pipelines, and reporting systems all work with CSV. Converting JSON to CSV bridges this gap, turning each JSON object into a row with the object keys as column headers. This tool accepts a JSON array of objects, extracts all unique keys as headers, and outputs a properly formatted CSV with comma separators and correct quoting for values that contain commas or newlines. The result can be downloaded directly as a .csv file or copied to the clipboard. Nested objects are flattened using dot notation so no data is silently lost. This is the fastest way to turn an API response into a spreadsheet-ready format without writing any code.
FAQ
- What JSON structure does the converter expect?
- The converter expects a JSON array of objects, like [{"name":"Alice","age":30}, {"name":"Bob","age":25}]. Each object becomes one CSV row, and all unique keys across all objects become columns.
- How are nested objects handled?
- Nested objects are serialized as JSON strings in the CSV cell, or flattened using dot notation depending on the tool mode. Arrays within objects are also serialized.
- Does the output handle special characters?
- Yes. Values containing commas, double quotes, or newlines are wrapped in double quotes and any internal double quotes are escaped by doubling them, per the CSV spec.