Loading...
Convert JSON arrays to CSV format and CSV to JSON. Handles nested objects and auto-detects types.
JSON-CSV conversion transforms data between JavaScript Object Notation (structured key-value pairs) and Comma-Separated Values (tabular rows). It's commonly used for data migration, spreadsheet imports/exports, and API integrations.
JSON to CSV: Converts an array of JSON objects into CSV format. Each object becomes a row, and object keys become column headers.
CSV to JSON: Parses CSV data where the first row contains column headers. Each subsequent row becomes a JSON object.
Nested objects are flattened using dot notation. Numbers and booleans are automatically detected and converted to proper types.
[{"name":"Alice"},{"name":"Bob"}]name,age
Alice,30
Bob,25| CSV Value | JSON Type |
|---|---|
| 123, 45.67 | number |
| true, false | boolean |
| (empty) | null |
| "Hello" | string |
Formula
Each JSON object becomes a row, and the union of all keys becomes the headerQuoting = a field holding a comma, a quote or a newline must be wrapped in double quotes, and an inner quote is doubled
Nesting = CSV is flat, so nested objects have to be flattened into dotted keys or serialised back into a cell
Ragged objects = a key missing from one object still needs its column, left empty
Types = CSV has none, so every value arrives back as text
Did you know? CSV has no character encoding field, which is why a file with accented names opens correctly in one program and as mojibake in another. Excel on Windows assumes the system code page unless the file opens with a UTF-8 byte order mark.
Sources
Convert text to ASCII codes and back. Supports decimal, hex, binary, and octal formats.
Calculate required internet bandwidth based on devices and activities in your household.
Encode and decode Base64 strings. Convert text for data URIs, APIs, and safe data transmission.
Create CSS border-radius with visual controls for each corner. Generate circles, pills, and custom shapes.
Create CSS box shadows with multiple layers, live preview, and copy-ready code.
Preview how colors appear with different types of color blindness. Test accessibility for color vision deficiency.