CSV to JSON Converter

First Row Is Header

If this option is selected the first row of your comma separated file is assumed to be the header. The names of the properties are generated using the field values in the first row. If the option is not selected the property names are generated automatically using a numeric pattern: column 1, column 2, column 3, etc. In the latter case the first row is interpreted as raw data.

First Row is Header On

[
  {
    "name": "Robin Hood",
    "department": "Sales",
    "salary": 200
  }
]

First Row is Header Off

[
  {
    "column 1": "Name",
    "column 2": "Department",
    "column 3": "Salary"
  },
  {
    "column 1": "Robin Hood",
    "column 2": "Sales",
    "column 3": 200
  }
]

Delimiter

The delimiter in the input CSV is specified here. In most cases the default setting Auto Detect works fine. But, in really small CSV data with delimiters also occurring as literals, the auto detection logic might not choose the correct delimiter. In such a scenario, the delimiter can be manually specified. Following are the choices for delimiters:-

• Comma
• Tab
• Space
• Pipe
• Semi-Colon

Indent

This setting governs whether or not the output is indented. The indented output is easier for humans to comprehend. On the other hand, a non-indented output is compact & smaller in size (best for transmission). So, JSON is often minified which compacts & compresses the output by removing non-essential whitespace.

Indentation On

{
  "name": "John Doe",
  "age": 69
}

Indentation Off

{"name":"John Doe","age":69}

Header Transform Type

This decides how the property names are transformed in the output JSON. The available strategies are:-

• Camel Case
• Lower Case
• Upper Case
• Snake Case
• None

Camel Case

[
  {
    "name": "Robin Hood",
    "departmentName": "Sales",
    "salary": 200
  }
]

Lower Case

[
  {
    "name": "Robin Hood",
    "departmentname": "Sales",
    "salary": 200
  }
]

Upper Case

[
  {
    "NAME": "Robin Hood",
    "DEPARTMENTNAME": "Sales",
    "SALARY": 200
  }
]

Snake Case

[
  {
    "name": "Robin Hood",
    "department_name": "Sales",
    "salary": 200
  }
]

None

[
  {
    "Name": "Robin Hood",
    "DepartmentName": "Sales",
    "Salary": 200
  }
]

Output Type

This decides how the JSON output is transformed and supports the following modes:-

• Properties (default)
• Column Arrays
• Row Arrays
• Dictionary Object
• Dictionary Array

Name,Department,Manager,Salary
Arsene Wenger,Bar,Friar Tuck,50
Friar Tuck,Foo,Robin Hood,100
Little John,Foo,Robin Hood,100
Dimi Berbatov,Foo,Little John,50

Properties

[
  {
    "Name": "Arsene Wenger",
    "Department": "Bar",
    "Manager": "Friar Tuck",
    "Salary": 50
  },
  {
    "Name": "Friar Tuck",
    "Department": "Foo",
    "Manager": "Robin Hood",
    "Salary": 100
  },
  {
    "Name": "Little John",
    "Department": "Foo",
    "Manager": "Robin Hood",
    "Salary": 100
  },
  {
    "Name": "Dimi Berbatov",
    "Department": "Foo",
    "Manager": "Little John",
    "Salary": 50
  }
]

Column Arrays

{
  "Name": [
    "Arsene Wenger",
    "Friar Tuck",
    "Little John",
    "Dimi Berbatov"
  ],
  "Department": [
    "Bar",
    "Foo",
    "Foo",
    "Foo"
  ],
  "Manager": [
    "Friar Tuck",
    "Robin Hood",
    "Robin Hood",
    "Little John"
  ],
  "Salary": [
    50,
    100,
    100,
    50
  ]
}

Row Arrays

[
  [
    "Arsene Wenger",
    "Bar",
    "Friar Tuck",
    50
  ],
  [
    "Friar Tuck",
    "Foo",
    "Robin Hood",
    100
  ],
  [
    "Little John",
    "Foo",
    "Robin Hood",
    100
  ],
  [
    "Dimi Berbatov",
    "Foo",
    "Little John",
    50
  ]
]

Dictionary Object

{
  "Arsene Wenger": {
    "Department": "Bar",
    "Manager": "Friar Tuck",
    "Salary": 50
  },
  "Friar Tuck": {
    "Department": "Foo",
    "Manager": "Robin Hood",
    "Salary": 100
  },
  "Little John": {
    "Department": "Foo",
    "Manager": "Robin Hood",
    "Salary": 100
  },
  "Dimi Berbatov": {
    "Department": "Foo",
    "Manager": "Little John",
    "Salary": 50
  }
}

Dictionary Array

{
  "Arsene Wenger": [
    "Bar",
    "Friar Tuck",
    50
  ],
  "Friar Tuck": [
    "Foo",
    "Robin Hood",
    100
  ],
  "Little John": [
    "Foo",
    "Robin Hood",
    100
  ],
  "Dimi Berbatov": [
    "Foo",
    "Little John",
    50
  ]
}