CSV to JSON

The CSV to JSON converter transforms spreadsheet exports and other comma-separated data into JSON — either an array of objects (using the first row as keys) or an array of arrays. It handles the tricky parts of real-world CSV correctly: quoted fields, doubled/escaped quotes inside values, and commas or line breaks embedded inside a single field, all of which trip up naive split-on-comma parsing.

Typical uses: pulling an export from Excel or Google Sheets and pasting it straight into a JavaScript app as mock API data, converting a CRM or analytics export into JSON for a script or database import, migrating a legacy data dump into a format a modern JSON API expects, and quickly checking what a messy CSV file actually contains before writing code around it. Because the delimiter is configurable, it also works as a straightforward csv to json converter for semicolon-delimited exports common in European locales and for tab-separated (.tsv) files, so you can convert csv to json regardless of where the export came from.

Parsing follows the RFC 4180 conventions that Excel and Google Sheets actually produce: a field wrapped in double quotes can contain commas and newlines without breaking the row, and a doubled quote inside a quoted field represents a literal quote character. On top of parsing, values are automatically typed — clean numbers become JSON numbers, 'true'/'false' become booleans, and empty cells become null — so the output is ready to use rather than a wall of quoted strings.

Values that aren't unambiguously numeric are left as strings on purpose: a code like '007' with a leading zero, or a formatted figure like '1,000', would lose information if silently converted to a number, so those stay as text. Conversion and parsing happen entirely in the browser — your data is never uploaded — which matters for exports containing customer records or other sensitive fields.