Convert JSON to CSV online without any software or signup. Paste a JSON array and this free browser tool flattens it into a comma-separated spreadsheet you can download or copy. It handles nested fields gracefully and is useful for exporting API data into Excel, Google Sheets, or any tool that accepts CSV input.
The JSON to CSV Converter transforms JSON arrays into CSV format for use in spreadsheets, data analysis tools, and database imports. Many APIs return data as JSON arrays of objects, but spreadsheet applications like Excel and Google Sheets, and data analysis tools like R and Python's pandas library, work more naturally with CSV files. This converter automatically detects the keys of the first object in the array and uses them as column headers, then outputs each object as a row. Nested objects are flattened by default (dot notation for nested keys) or can be serialized as JSON strings. It also converts in the reverse direction: CSV to JSON, parsing the header row as property names and each data row as an object. The conversion runs entirely in your browser and you can download the output as a file or copy it to clipboard.
Converting between JSON and CSV requires handling several edge cases that can cause problems if not addressed carefully. Values containing commas must be wrapped in double quotes. Values containing double quotes must have those quotes escaped by doubling them (""). Values containing newlines must also be quoted. This converter follows RFC 4180 (the de facto CSV standard) for all of these cases. Nested JSON objects present a choice: flatten them (user.address.city becomes a column named user.address.city) or serialize the nested object as a JSON string in the cell. Flattening works well for one level of nesting but creates very wide tables for deeply nested data. Arrays within objects are typically serialized as JSON strings since CSV has no native representation of arrays. For large datasets, CSV is often more efficient than JSON because it has less overhead: JSON encodes every property name for every object, while CSV encodes property names once as headers. A 10,000-row dataset of objects with ten properties might be 40 percent smaller as CSV than as JSON. For database imports, most databases (PostgreSQL COPY, MySQL LOAD DATA, SQLite .import) accept CSV directly. For Google Sheets, File > Import > Upload accepts CSV with automatic delimiter detection.