JSON to CSV Converter
Convert JSON data to CSV format instantly. Paste JSON array of objects and get clean CSV output. Handles nested objects, arrays, and various delimiters. Free online JSON to CSV converter.
Frequently Asked Questions
How does the JSON to CSV converter work?
Paste a JSON array of objects, click Convert, and the tool extracts all unique keys across all objects to form the CSV column headers. Each JSON object becomes a row in the CSV output. Values are properly quoted and escaped according to RFC 4180 standards.
How are nested objects and arrays handled?
By default, nested objects and arrays are serialized as JSON strings within the CSV cell (e.g., {"key":"value"}). Enable "Flatten nested objects" to expand nested object properties into individual columns using dot notation (e.g., address.city, address.zip). Arrays are always serialized as JSON strings since CSV has no native array type.
What if the JSON objects have different keys?
The tool automatically collects all unique keys across all objects in the array. If an object is missing a key, the corresponding CSV cell is left empty. This ensures no data is lost when objects have inconsistent schemas โฆa common scenario with real-world JSON data from APIs.
What delimiters are supported?
Comma (default), semicolon, tab, and pipe. Semicolon is commonly used in European locales where the comma is the decimal separator. Tab-delimited output is useful for pasting directly into spreadsheet applications like Excel or Google Sheets.
How are special characters handled in CSV?
If a value contains the delimiter, double quotes, or newlines, it is automatically wrapped in double quotes. Embedded double quotes are escaped by doubling them (""). This follows the RFC 4180 specification, ensuring compatibility with Excel, Google Sheets, and all standard CSV parsers.
Can I convert JSON that is not an array?
The tool expects a JSON array of objects (e.g., [{...}, {...}]). If you pass a single object, it will be treated as one row. If you pass a JSON object containing an array property, extract that array first โfor example, if your API returns {"data": [...]}, paste just the array part [...].
Is this tool free?
Yes, completely free with no sign-up required. All conversion happens in your browser โฆyour data is never uploaded to any server.