RFC 4180 CSV & TSV to JSON Conversion
Spreadsheet exports, analytics reports, and relational database dumps use comma, semicolon, tab, or pipe delimiters alongside double-quoted fields containing embedded commas, escaped quotes (""), or multiline strings. This converter parses RFC 4180 CSV/TSV strings into structured JSON arrays—or flattens JSON object arrays back into properly escaped CSV rows—entirely inside your browser.
Smart Delimiter Auto-Detection
Automatically inspects header and data rows to distinguish standard comma-separated values (,), European semicolon exports (;), tab-separated values (\t), and pipe-delimited logs (|).
Type & Null Inference
Enable Infer Numbers/Booleans and Null Handling to convert unquoted numeric cells, true/false literals, and empty cells or NULL tokens into native JSON types instead of raw strings.
RFC 4180 Escaping on Export
When converting JSON arrays back to CSV, fields containing delimiters, double quotes, or line breaks are automatically wrapped in quotes and escaped according to RFC 4180 so Excel, Google Sheets, and PostgreSQL COPY import cleanly.
Frequently Asked Questions
How does the converter handle CSV files without a header row?
Uncheck Header Row in the toolbar to parse each CSV line as a positional JSON array of values ([["1", "Alice"], ["2", "Bob"]]) instead of an array of keyed objects.
Are nested JSON objects supported when converting JSON to CSV?
Yes. Every unique key across all objects in your JSON array is collected to build the CSV header union. Nested objects or arrays inside a property are serialized as compact JSON strings within the corresponding CSV cell.