JSON ↔ CSV Converter

How to Use Paste a JSON array into the input field (it must be an array of objects with consistent keys). Click 'Convert' to transform it into CSV format. Switch the direction to convert CSV back to a JSON array. Download the result as a file or copy it to the clipboard. Who Is This For Data analysts who need to open API JSON responses in Excel or Google Sheets, developers uploading spreadsheet data to an API in JSON format, and engineers handling data migration between systems. Key Features • JSON array ↔ CSV bidirectional conversion • Automatic header extraction from JSON keys • Nested object flattening option • Delimiter selection (comma, tab, semicolon) • File download Frequently Asked Questions Q: What happens with deeply nested JSON objects? A: Enable the 'Flatten' option to expand nested objects using dot notation (e.g., user.name becomes a column header). Q: What if I paste a single JSON object instead of an array? A: The tool automatically wraps it in an array and processes it. Q: How are null values represented in the CSV output? A: Null values appear as empty cells or the literal string 'null', depending on the conversion option you select. Tips After converting, open the CSV in Excel and check that numeric fields didn't get misidentified as dates. When downloading, enable UTF-8 BOM to prevent Korean character encoding issues in Excel.