JSON ↔ CSV Converter

JSON and CSV are the two most common data interchange formats in web development. JSON is preferred for APIs (nested objects, arrays, typed values), while CSV is preferred for spreadsheets, database exports, and bulk import tools. This converter handles both directions: JSON array to CSV with proper quoting and escape, and CSV back to a JSON array using the header row as keys.

JSON to CSV rules

Only flat JSON arrays are supported (arrays of objects with consistent keys). Nested objects are stringified into the cell value. Values containing the delimiter, quotes, or newlines are automatically wrapped in double quotes per RFC 4180. Missing keys in a row output an empty string for that column.

CSV to JSON rules

The first row is used as property names (headers). All values are treated as strings — the converter does not attempt type inference for numbers and booleans (this avoids incorrectly converting strings like "001" or "true" that should remain as strings). If you need typed values, use the JSON output as a starting point and parse numbers in your application.

The semicolon delimiter option is useful for European locales where comma is the decimal separator (e.g. Excel defaults to semicolons in German, French, and Dutch regional settings). Tab-delimited is the TSV format, often used in data science pipelines and Google Sheets exports.