JSON to CSV & CSV to JSON Converter
Bi-directional, zero-telemetry dataset converter. Transforms nested JSON arrays into tabular RFC 4180 spreadsheets, and CSV exports back into type-inferred JSON objects.
id,name,role,department,isActive,salary,contact.email,contact.city 101,Jane Cooper,Lead Architect,Infrastructure,true,145000,[email protected],San Francisco 102,Cody Fisher,Systems Engineer,Platform,false,118000,[email protected],Austin 103,Esther Howard,Security Specialist,SecOps,true,132000,[email protected],Seattle
RFC 4180 CSV Architecture, Quoting Norms & Relational Flattening
CSV (Comma-Separated Values) is the most ubiquitous interchange format for relational databases and tabular spreadsheets. However, because CSV lacks a native type system, strictly conforming to RFC 4180 parsing rules is essential to prevent column drift and field corruption.
RFC 4180 Escaping Rules
Whenever a cell contains the delimiter, line breaks (CRLF), or double quotes, the entire field must be enclosed in double quotes. Any internal quote character must be escaped by prefixing an identical double quote ("").
Hierarchical Flattening
JSON naturally supports recursive tree structures (nested objects and arrays), while CSV is strictly 2D flat. Our engine traverses nested nodes recursively, producing compound column identifiers (e.g., contact.email, geo.lat).
Type Inference Recovery
When converting CSV back into JSON, all tokens arrive as raw strings. GenStack automatically restores boolean literals (true/false), null tokens (null), and IEEE-754 floating points without string pollution.