Does the first row have to be headers?

Yes, the first row gives the keys. Empty header cells are named column1, column2 and so on.

Why did my zip codes lose their leading zero?

They were read as numbers. Values with a leading zero, like 0123, stay text, but turn Detect types off if a column should never be a number.

Is there a size limit?

The conversion runs on your device, so files of several megabytes are fine.

Convert CSV to JSON

Paste CSV, or copy cells straight from Excel or Google Sheets, and get a JSON array with one object per row. The separator is detected for you.

How to use the CSV to JSON converter

Paste CSV, copy cells from a spreadsheet, or drop a .csv file on the editor.
A JSON array appears on the right, one object per row.
Turn Detect types off if every value should stay text.
Copy it, or download it as a .json file.

What you get

Comma, semicolon, tab and pipe separators, detected automatically
Quoted fields with commas, quotes and line breaks
Numbers, true, false and null as real JSON types
Dotted headers such as address.city rebuilt as nested objects

About the CSV to JSON converter

Straight from a spreadsheet

Cells copied from Excel or Google Sheets are tab separated. Paste them in and the converter detects that, using the first row as the keys.

Typed values

Columns of numbers come out as JSON numbers, and true, false and null as their JSON values. Large IDs are not rounded. Switch Detect types off to keep every value as text.

Frequently asked questions

Does the first row have to be headers?: Yes, the first row gives the keys. Empty header cells are named column1, column2 and so on.
Why did my zip codes lose their leading zero?: They were read as numbers. Values with a leading zero, like 0123, stay text, but turn Detect types off if a column should never be a number.
Is there a size limit?: The conversion runs on your device, so files of several megabytes are fine.