CSV to JSON

Turn CSV rows into a JSON array of objects, detecting numbers, booleans and blanks.

Input

The CSV to convert.
Column separator. "auto" detects it from the first line.
The first row holds column names.
Turn numbers, true/false and blanks into typed values.
Spaces per level. 0 gives one compact line.

Result

Fill in the input and press Run.

Your input is processed in memory and then discarded. It is not stored or logged. Even so, don't paste live passwords or keys into any online tool.

Use it from code or an agent

curl -s https://setget.net/v1/tools/csv-to-json \
  -H 'Content-Type: application/json' \
  -d '{"input":{"text":"name,age\nSam,31\nAlex,27","indent":0}}'
import json, urllib.request

body = {'input': {'text': 'name,age\nSam,31\nAlex,27', 'indent': 0}}
request = urllib.request.Request("https://setget.net/v1/tools/csv-to-json", json.dumps(body).encode(),
                                 {"Content-Type": "application/json"})
print(json.load(urllib.request.urlopen(request))["result"])
const response = await fetch("https://setget.net/v1/tools/csv-to-json", {
  method: "POST",
  headers: {"Content-Type": "application/json"},
  body: JSON.stringify({"input":{"text":"name,age\nSam,31\nAlex,27","indent":0}}),
});
console.log((await response.json()).result);
Tool: run_tool
Arguments:
{
  "slug": "csv-to-json",
  "input": {
    "text": "name,age\nSam,31\nAlex,27",
    "indent": 0
  }
}
{
  "input": {
    "text": "name,age\nSam,31\nAlex,27",
    "indent": 0
  }
}

Endpoint: POST /v1/tools/csv-to-json. Over MCP: run_tool with slug: "csv-to-json". Machine-readable: input schema, Markdown. Connect an agent.

Inputs

NameTypeRequiredWhat it does
text string yes The CSV to convert.
delimiter string no Column separator. "auto" detects it from the first line. One of: auto, comma, tab, semicolon, pipe. Default: "auto".
header boolean no The first row holds column names. Default: true.
infer_types boolean no Turn numbers, true/false and blanks into typed values. Default: true.
indent integer no Spaces per level. 0 gives one compact line. Default: 2. From 0 to 8.

Example

Input
{
  "text": "name,age\nSam,31\nAlex,27",
  "indent": 0
}
Result
{
  "text": "[{\"name\":\"Sam\",\"age\":31},{\"name\":\"Alex\",\"age\":27}]",
  "rows": 2,
  "columns": [
    "name",
    "age"
  ]
}

Questions

Why did "007" stay as text?
Values with leading zeros are usually codes, not numbers, so they are left alone.