CSV to JSON Converter

Convert in the other direction

What is CSV to JSON conversion?

CSV (Comma-Separated Values) is a plain text format used by spreadsheets, databases, and data exports. JSON (JavaScript Object Notation) is the standard format for APIs and web applications. Turning a CSV into JSON is one of the most common data tasks developers face, whether you are seeding a test database from a spreadsheet, preparing fixture data for an API, or loading a report export into a script. This converter reads the CSV the way Excel and Google Sheets write it, including quoted fields that contain commas or line breaks. You can choose the delimiter or let it be detected. You can tell the tool whether the first row contains column headers, which decides whether each row becomes a keyed object or a plain array. Numbers and booleans come out as real JSON types rather than quoted strings, so the result is ready to use without a cleanup pass. All processing happens in your browser with no data uploaded to any server.

How to use

1. Paste your CSV into the input panel, or paste rows copied straight from a spreadsheet.
2. Pick a delimiter, or leave it on Auto-detect for files exported from Excel, Google Sheets, or a database client.
3. Toggle First row is header off if the file has no header row. Each row then becomes a plain array instead of a keyed object.
4. Numbers and booleans are typed automatically, including quoted ones, so check columns such as zip codes or IDs with leading zeros.
5. Copy the output, or download it as a .json file.

Example conversion

id,name,active
1,Ada,true
2,Grace,false

[
  { "id": 1, "name": "Ada", "active": true },
  { "id": 2, "name": "Grace", "active": false }
]

Note that id and active came out as a number and a boolean, not strings, because values are typed automatically. That is what you want for counts, prices, and flags. It is not what you want for an ID that only looks numeric, like a zip code with a leading zero, so check those columns in the output.

Frequently Asked Questions