Egide Calculs
Financial Tools & Invoicing

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.

100% local: your data never leaves your browser
CSV / TSV data

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.

Frequently asked questions

What is RFC 4180?
The IETF standard describing CSV: fields may be quoted, quotes inside fields are doubled, and line breaks inside quoted fields are part of the value. This converter implements it, so tricky cells round-trip intact.
Why does my exported CSV start with strange characters in some editors?
That is the UTF-8 BOM (byte order mark), added intentionally: it tells Excel the file is UTF-8 so accented characters survive. Plain-text editors may display it as an invisible prefix; it is harmless and standard.
Can JSON be converted to CSV if the objects have different keys?
Yes — the converter collects the union of all keys across the array and fills missing values with empty cells, so the resulting table is rectangular and Excel-ready.
Is my data uploaded anywhere?
No. Parsing, conversion and validation all run in your browser. Nothing transits a server, which makes the tool suitable for customer exports and other sensitive data.
Does the converter handle very large files?
Files of several megabytes convert instantly on a modern laptop. Very large inputs are limited only by browser memory; the preview table caps at 200 rows for responsiveness.
Gerer les cookies