CSV is the language of spreadsheets, and JSON is the language of web APIs and JavaScript. Moving data between the two comes up all the time: importing a product list into an app, seeding a database, feeding a chart library, or turning an API response into something you can open in Excel or Google Sheets. This free CSV to JSON converter works in both directions. Paste CSV (or open a .csv file) and get a clean JSON array of objects, using the first row as keys, or an array of arrays if you prefer. Paste JSON and get CSV back, ready to download. The parser handles the awkward cases that break quick split-on-comma scripts: quoted fields containing commas, quotes escaped as "", line breaks inside a cell, and a byte-order mark at the start. It auto-detects whether the delimiter is a comma, semicolon (common in European Excel exports), tab or pipe, and you can override it. Optionally convert numbers and true/false into real JSON types, trim spaces, and skip empty lines. For JSON to CSV, nested objects are flattened into dot-notation columns like address.city, and every key across all rows becomes a column. Your data is processed entirely in your browser.
Convert
How to convert CSV to JSON
- Paste CSV or open a file.
- Check the delimiter and header options.
- Copy or download the JSON.
JSON to CSV
Switch the direction, paste an array of objects, and download a .csv that opens in Excel or Google Sheets. Nested objects become parent.child columns.
FAQ
My Excel CSV uses semicolons. Will it work?
Yes. Auto-detect picks up semicolons, or choose it manually.
What about commas inside values?
Values wrapped in double quotes can contain commas, quotes ("") and line breaks; they’re parsed correctly.
How large a file can I convert?
Several MB is fine; very large files depend on your device’s memory.
Is my data uploaded?
No. The conversion runs in your browser.
Comments
Post a Comment