JSON Query & Transformation Tool

Private structured-data workspace

Query JSON, YAML and JSONL locally, inspect canonical paths and export structured results.

0Matches

0Rows

0Columns

0Value types

0Structured values

orders.jsonParsing and evaluation stay in this browser.

{
  "store": {
    "region": "APAC",
    "orders": [
      {
        "id": "ord_1001",
        "customer": {
          "name": "Avery Chen",
          "tier": "pro"
        },
        "total": 128.5,
        "status": "paid",
        "items": [
          {
            "sku": "NOTE-01",
            "quantity": 2
          }
        ]
      },
      {
        "id": "ord_1002",
        "customer": {
          "name": "Morgan Li",
          "tier": "free"
        },
        "total": 42,
        "status": "pending",
        "items": [
          {
            "sku": "LAMP-02",
            "quantity": 1
          }
        ]
      },
      {
        "id": "ord_1003",
        "customer": {
          "name": "Riley Wang",
          "tier": "team"
        },
        "total": 310,
        "status": "paid",
        "items": [
          {
            "sku": "PACK-03",
            "quantity": 3
          }
        ]
      }
    ],
    "metadata": {
      "generatedAt": "2026-09-01T00:00:00Z",
      "source": "fictional"
    }
  }
}

How to use it

01
Load structured data
Paste or open bounded JSON, YAML, JSONL or NDJSON without uploading it.
02
Run a query
Use JSONPath, JSON Pointer or the documented JMESPath subset and inspect exact canonical paths.
03
Transform and export
Flatten matching values into rows and download JSON, CSV, NDJSON or TypeScript.

Frequently asked questions

Is the source uploaded?

No. Parsing, querying and export run in this browser.

Is JSONPath standards based?

The evaluator covers common RFC 9535 selectors, recursive descent, slices, unions and simple filters, while rejecting unsupported expressions explicitly.

Does it implement all of JMESPath?

No. It provides a clearly labelled practical member, projection, index and wildcard subset.

How are large inputs handled?

Byte, depth, node and match limits prevent a static page from becoming unresponsive.

Keep working with other focused browser utilities.

All tools

How to use it

Load structured data

Run a query

Transform and export

Frequently asked questions

Related tools

Config Format Converter & Validator

CSV & Data Analyzer

JSON Schema Validator & Mock Data Generator