How to use the CSV to JSON
- Paste CSV, or copy rows directly from Excel or Google Sheets (tab-separated works too).
- The delimiter is detected automatically; override it if needed.
- Keep “First row is header” on to get an array of objects.
- Copy or download the JSON.
Real CSV is messier than commas
A naive split on commas breaks on the first address or description field. This converter follows RFC 4180: fields wrapped in double quotes can contain commas, line breaks and escaped quotes (""). A byte-order mark from Excel exports is removed automatically.
name,quote
"Smith, Jane","She said ""hi"""becomes
[{ "name": "Smith, Jane", "quote": "She said \"hi\"" }]Type inference
With “Detect numbers and booleans” on, 42 becomes a number and true a boolean. Values with leading zeros — ZIP codes, phone numbers, IDs like 007 — deliberately stay strings, because converting them would silently destroy data.
Frequently asked questions
Can I paste directly from Excel or Google Sheets?
Yes. Copied cells are tab-separated; the delimiter is detected automatically.
What if my CSV uses semicolons?
European Excel exports often use semicolons. They are detected automatically, or you can pick the delimiter manually.
Is the data uploaded?
No. Conversion happens in your browser, which makes it safe for customer lists and internal exports.