CSV / JSON Converter
Convert CSV or TSV to clean JSON, JSON arrays to Excel-friendly CSV (with UTF-8 BOM), and format, validate or minify JSON — with precise line/column error reporting. Everything runs locally: your data never leaves the browser.
CSV, JSON and the details that break conversions
CSV looks trivial until a cell contains a comma, a quote, or a newline — the three cases the RFC 4180 standard defines. This converter implements that standard: quoted fields, escaped quotes, and multi-line cells all round-trip correctly, which is what generic split-on-commas snippets get wrong. The auto-detected separator handles the comma/semicolon/tab divide that varies between US and European exports.
When converting JSON to CSV, nested objects are flattened with dot notation (cat.name becomes a column), and the UTF-8 BOM prefix is added automatically so accented characters open correctly in Excel. Without that BOM, Excel assumes a legacy code page and mangles every non-ASCII character — the single most common complaint about CSV exports.
The validator panel reports syntax errors with their exact line and column, which turns a frustrating unexpected-token hunt into a two-second fix. The formatter, minifier and key sorter operate on the same validation, so you never accidentally destroy a working payload while pretty-printing it.