No file open
Create a new file or open an existing one from the sidebar
Paste your CSV and press To JSON in the Convert panel.
No file open
Create a new file or open an existing one from the sidebar
To convert CSV to JSON, paste your CSV above, open Convert and press To JSON in the CSV section. The first row becomes the keys and every row after it becomes an object, so you get an array that's ready to drop into code or an API request.
Quoted fields can hold commas, quotes and line breaks, the way the CSV standard describes. The converter also works out whether your file is separated by commas, semicolons or tabs, which covers Excel exports in most regions.
id,name,zip,notes
1,Alice,02134,"Prefers email, weekdays only"
2,Bob,75001,
3,Carol,100-0001,"Said ""hi"" at the meetup"[
{
"id": "1",
"name": "Alice",
"zip": "02134",
"notes": "Prefers email, weekdays only"
},
{
"id": "2",
"name": "Bob",
"zip": "75001",
"notes": ""
},
{
"id": "3",
"name": "Carol",
"zip": "100-0001",
"notes": "Said \"hi\" at the meetup"
}
]Every value stays a string. That keeps zip codes, phone numbers and IDs with leading zeros exactly as they were, like 02134 in the example. If you need real numbers, convert the columns you care about in your code.
Yes, including the byte order mark Excel adds to UTF-8 files and semicolon separated exports.
The first row is always used for the keys, so add a header row first. Empty header cells get names like column3 so nothing is lost.
No, this runs entirely in your browser, so nothing you paste is sent to a server. The only feature that sends data anywhere is the optional AI assistant, and only when you actually ask it something.