tool hub Tool Hub

CSV to JSON

CSV to JSON — runs in your browser. Inputs are not stored.

Runs in your browser No sign-up Free to use

CSV → JSON

Supports comma-separated CSV. Quoted fields and escaped quotes are handled. Input is processed only in your browser.

How to use

  1. Paste a comma-separated table into the CSV box. Content saved from Excel or Google Sheets works as-is.
  2. Use first row as header (array of objects) is on by default. Leave it on for key-value objects; turn it off if you only need a 2D array.
  3. Press Convert and check the result in the JSON box. A status message appears if the format is invalid.
  4. Use Copy result to put the JSON on the clipboard for your code.
  5. Reset clears input and output together when you want a new table.

Key concepts

CSV to JSON turns spreadsheet lists, product catalogs, or a slice of a log into objects you can drop into frontend code or an API mock. Parsing runs only in the browser, so customer contacts and internal tables never go to a server. The delimiter is a comma; tab-separated TSV is not this tool’s job. If the table has column names, keeping the header option on usually makes later code easier.

With headers on, the first row becomes object keys and every later row becomes an object. With headers off, every row is an array of strings. If a cell contains a comma, wrap that cell in double quotes; a quote inside a field is written twice, following CSV rules. Values that look numeric stay strings in JSON—cast them yourself after conversion if you need numbers.

Example

If the input is name,age then hong,30, kim,25 and headers are on, you get [{"name":"hong","age":"30"},{"name":"kim","age":"25"}]. The same input without headers becomes three arrays. Quote cells that contain commas, like "Seoul, Gangnam". Lowercase English header names are easier to read with dot notation in JavaScript. If an export has ragged column counts, pad empty cells first so keys are not missing.

Related: JSON → CSV · JSON formatter · TSV/CSV → HTML table

Frequently asked questions

Do I have to turn on the first-row header for CSV to JSON?

Turn it on for an array of objects. Turn it off for data without column names, such as coordinates. It is on by default.

Can I convert tab-separated TSV to JSON here?

This screen is comma-based. For tabs, use the markdown table generator or the TSV/CSV HTML table tool.

How are CSV fields with mixed quotes and commas handled?

Wrap the field in double quotes and write an inner quote twice so it reads as one cell.

Is the CSV-to-JSON result stored on a server?

No. Conversion runs only in the browser and is not sent or saved.

What happens to rows with a different number of columns?

Empty cells become empty strings for header keys, or short rows fill only the keys they have. Align column counts when you can.

Can I paste CSV saved from Excel as-is?

Yes. Some Excel builds use a semicolon delimiter or a BOM. If it is not commas, fix the delimiter first.

CSV to JSON cover image
Your input is not sent to the server and disappears when you close the page.

Last reviewed: 2026-09-04