CSV ⇄ JSON Converter

How it works

Parsing uses Papa Parse, which follows RFC 4180: fields containing the delimiter, quotes or line breaks are wrapped in double quotes, and a quote inside a field is doubled ("").

• CSV → JSON: with a header row you get an array of objects, otherwise an array of arrays. “Detect numbers” turns 10 into 10 but leaves 4,7 or 007 as text.
• JSON → CSV: takes an array of objects; nested objects and arrays are written as JSON inside their cell.
• Change delimiter: re-quotes as needed, so it’s safe on fields that contain the old or new delimiter.

Excel in many European locales (including French) writes CSV with semicolons, because the comma is the decimal separator; auto-detect handles both.

References

• RFC 4180 — CSV format