CSV to JSON converter

Paste CSV to get a JSON array of objects, or paste JSON to get CSV you can open in Excel or Google Sheets. Files are read on your device.

CSV to JSON

Each row becomes a JSON object, using the first row as keys. Values in quotes can contain commas, quotes (written as "") and line breaks. Numbers, true and false are converted to JSON types unless you untick that option; empty cells become null.

id,name,active          [
1,Ada,true        →       { "id": 1, "name": "Ada", "active": true }
                        ]

JSON to CSV

Paste an array of objects. Every key found in any object becomes a column. Nested objects are flattened to dot paths, so {"address": {"city": "London"}} becomes a column called address.city. Arrays of simple values are joined with semicolons.

Excel and European CSV files

Excel in many European locales saves CSV with semicolons because the comma is the decimal separator. The delimiter is detected automatically, or you can choose it.

Frequently asked questions

How do I convert a CSV file to JSON?
Click Open file and choose the CSV, or paste its contents. The JSON appears on the right; copy or download it.
Why are my numbers in quotes?
Tick 'Detect numbers and true/false' to turn values that look like numbers into JSON numbers. Values with leading zeros, such as 007 or phone numbers, always stay as text so nothing is lost.
Can it handle large files?
Yes, files of several megabytes convert in your browser in a second or two.
Is my data uploaded?
No. Files are read and converted on your device.