CSV to JSON Converter

Convert CSV data to JSON output

Conversion options
Delimiter
CSV data
JSON data
Read-only

What is CSV to JSON Converter?

CSV to JSON Converter turns CSV data into JSON. You can inspect a CSV export from a spreadsheet or database as an array of objects, and check the data before passing it to an API.

The conversion runs in your browser, and the result updates as you type.

How to Use

  1. Paste CSV data into the input.
  2. Choose the delimiter.
  3. Turn JSON formatting on or off as needed.
  4. Review the JSON result.

Main Settings

Delimiter

Choose the character that separates the CSV columns. Use a comma for standard CSV and a tab for tab-separated data. For other delimiters, such as a semicolon, choose Custom and enter one character.

Format JSON

Turn this on for JSON with line breaks and indentation, or off for JSON on a single line. Use the formatted output when reviewing the data, and the compact output when copying it elsewhere.

Input and Output Example

id,name,age
1,Taro Yamada,25
2,Hanako Suzuki,30

This CSV becomes the following JSON.

[
  {
    "id": "1",
    "name": "Taro Yamada",
    "age": "25"
  },
  {
    "id": "2",
    "name": "Hanako Suzuki",
    "age": "30"
  }
]

Use Cases

  • Reviewing a spreadsheet or CSV export as an array of JSON objects
  • Checking column names and values before sending CSV data to an API
  • Inspecting tab-separated or custom-delimited text as structured data

Things to Keep in Mind

  • The first row is treated as the header and becomes the JSON keys
  • Values stay strings; numbers and booleans are not inferred
  • Empty lines are skipped
  • Conversion fails when a quote is not closed, when a row has a different number of columns from the header, or when header names are duplicated
  • If the delimiter does not match the data, columns are not split and the result may become a single-column JSON