CSV to JSON

Overview

• Converts CSV-formatted data into JSON in the form of an array of objects.
• Treats the first line as the header (key names) and converts each subsequent line into one object.
• Correctly parses values enclosed in double quotes, including those containing commas, newlines, or escaped quotes, following the CSV specification.

Usage

1. Enter the CSV you want to convert into the text area. The first line is treated as the header.
2. Click the "Convert to JSON" button.
3. The formatted JSON array is displayed below. Use the "Copy" button to copy the result to the clipboard.

Example

name,age
Taro,20
Jiro,25

[
  {
    "name": "Taro",
    "age": "20"
  },
  {
    "name": "Jiro",
    "age": "25"
  }
]

Use Cases

• Converting data exported from Excel or a spreadsheet into JSON that is easy for a system to import
• Converting CSV master data into JSON for use as an API request body or test data
• Bringing in the content of a CSV file shared by another department as structured data an application can use

FAQ

Notes

• All values are output as strings. If you need numbers or booleans, convert the types separately after conversion.
• A row whose column count does not match the header results in an error. Check beforehand that every row has the same number of columns.
• Converting very large CSV data may make browser processing slow.