Paste CSV to get a JSON array of objects, one per row, using the first row as keys; or switch direction to turn JSON into CSV for a spreadsheet. Commas, semicolons, tabs and quoted fields are handled.
This CSV:
| CSV | JSON |
|---|---|
name,age,member | [{"name":"Ann","age":31,"member":true},{"name":"Bo","age":null,"member":false}] |
With Numbers and true/false ticked, 31 becomes a number, true a boolean and an empty cell null; untick it to keep every value as text.
Paste an array of objects. Every key found becomes a column, and nested objects are flattened with dots, so {"address": {"city": "Leeds"}} becomes a column address.city. Lists inside a row are written as JSON in one cell.
The separator is detected from the first lines (comma, semicolon, tab or pipe). Excel in many European countries saves with semicolons; pick it by hand if detection gets it wrong.
Yes. "Smith, Jo" stays one value, and "" inside quotes is a literal quote, as in RFC 4180.
No. It’s converted in your browser.
Open all 35 Dev Tools. Everything runs in your browser; nothing you paste is uploaded.