Tool

JSON Tool

Validate, format, minify, sort keys, query with JSONPath-lite, and convert to / from CSV.

Input

✓ Valid JSONIndent470 bytes

5Objects2Arrays7Strings7Numbers4Booleans0Nulls3Max depth470 BFormatted284 BMinified

Pretty

{
  "project": "PLC upgrade",
  "owner": "Cameron",
  "tasks": [
    {
      "id": 1,
      "title": "Backup PLC",
      "done": true,
      "hours": 0.5
    },
    {
      "id": 2,
      "title": "Stage program",
      "done": true,
      "hours": 1.5
    },
    {
      "id": 3,
      "title": "Cutover & test",
      "done": false,
      "hours": 4
    }
  ],
  "meta": {
    "revision": 3,
    "approved": false,
    "tags": [
      "control",
      "ot"
    ]
  }
}

Minified

{"project":"PLC upgrade","owner":"Cameron","tasks":[{"id":1,"title":"Backup PLC","done":true,"hours":0.5},{"id":2,"title":"Stage program","done":true,"hours":1.5},{"id":3,"title":"Cutover & test","done":false,"hours":4}],"meta":{"revision":3,"approved":false,"tags":["control","ot"]}}

Sorted keys (deep)

{
  "meta": {
    "approved": false,
    "revision": 3,
    "tags": [
      "control",
      "ot"
    ]
  },
  "owner": "Cameron",
  "project": "PLC upgrade",
  "tasks": [
    {
      "done": true,
      "hours": 0.5,
      "id": 1,
      "title": "Backup PLC"
    },
    {
      "done": true,
      "hours": 1.5,
      "id": 2,
      "title": "Stage program"
    },
    {
      "done": false,
      "hours": 4,
      "id": 3,
      "title": "Cutover & test"
    }
  ]
}

CSV (top-level must be array of flat objects)

Provide a JSON array of objects with primitive values to export as CSV. Example: [{"a":1,"b":2}, ...].

JSONPath-lite query

Supports $ root, .key, [index],[*] wildcard, .. recursive descent. Example: $.tasks[*].title.

[
  "Backup PLC",
  "Stage program",
  "Cutover & test"
]

CSV → JSON

Paste CSV with a header row — each row becomes an object keyed by the header columns.

[
  {
    "name": "Alice",
    "role": "Eng",
    "ext": "2101"
  },
  {
    "name": "Bob",
    "role": "Tech",
    "ext": "2102"
  }
]

tool