CSV to JSON Converter

CSV to JSON Converter is a free tool that converts CSV files and spreadsheet exports into JSON. It uses the header row for property names, turns numbers and true/false into real values, and correctly handles quoted fields with commas and line breaks. The separator (comma, semicolon or tab) is detected automatically. Your data stays in your browser.

How to convert CSV to JSON

1. Paste CSV or open a .csv file. From Excel or Google Sheets, first save or download the sheet as CSV.
2. The JSON appears on the right, with the number of rows and columns.
3. Adjust the options if needed, then copy or download data.json.

Example

name,email,age
"Lee, Ann",ann@example.com,34
Bob Stone,bob@example.com,

becomes:

[
  { "name": "Lee, Ann", "email": "ann@example.com", "age": 34 },
  { "name": "Bob Stone", "email": "bob@example.com", "age": "" }
]

Options

• First row is headers: each row becomes an object with those names. Untick it to get an array of arrays instead.
• Convert numbers and true/false: 34 becomes a number rather than the text "34". Values with leading zeros, such as zip codes and phone numbers, always stay text.
• Separator: detected automatically, or choose comma, semicolon or tab.

Things to watch for

• Duplicate or empty column names get unique names (name_2, column3) so no data is lost.
• Rows with more values than headers are reported, and the extra values are dropped.
• Empty cells become empty strings. Replace them with null afterwards if your system needs that.

To check or tidy the result, paste it into the JSON Formatter. To go back the other way, use JSON to CSV, and to generate TypeScript types for the rows, useJSON to TypeScript.

Frequently asked questions

Last updated 26 September 2026