Free · Put JSON records in a useful order

JSON Array Sorter

Sort an array by text or numbers with JSONata's order-by operator.

Real JSONata 2.2 query
Private in your browser
Time and result safety caps

Sort JSON array

Paste JSON, edit the JSONata expression, and run it locally with time, depth, and result limits.

Add JSON and a queryBoth stay in this browser tab

JSON data 1,255 / 120,000 characters

{
  "store": {
    "name": "Little Leaf Market",
    "currency": "CAD"
  },
  "orders": [
    {
      "id": "A-100",
      "customer": "Mia",
      "city": "Toronto",
      "status": "paid",
      "total": 84.5,
      "items": 3,
      "tags": [
        "gift",
        "new"
      ]
    },
    {
      "id": "A-101",
      "customer": "Noah",
      "city": "Ottawa",
      "status": "pending",
      "total": 42,
      "items": 1,
      "tags": [
        "new"
      ]
    },
    {
      "id": "A-102",
      "customer": "Ava",
      "city": "Toronto",
      "status": "paid",
      "total": 126.25,
      "items": 4,
      "tags": [
        "vip",
        "gift"
      ]
    },
    {
      "id": "A-103",
      "customer": "Liam",
      "city": "Montreal",
      "status": "refunded",
      "total": 58.75,
      "items": 2,
      "tags": [
        "return"
      ]
    },
    {
      "id": "A-104",
      "customer": "Emma",
      "city": "Ottawa",
      "status": "paid",
      "total": 199,
      "items": 5,
      "tags": [
        "vip"
      ]
    },
    {
      "id": "A-105",
      "customer": "Mateo",
      "city": "Toronto",
      "status": "pending",
      "total": 72.25,
      "items": 2,
      "tags": [
        "gift"
      ]
    }
  ]
}

JSONata expression 15 / 1,000 characters

Bounded local queryJSONata 2.2.2 · 800 ms timeout · $eval off

See the resultReady when you are

Your query result will appear here

JSONata can filter, sort, group, calculate, and reshape the sample without an upload.

Three simple steps

How to use it

Paste the JSON array.
Choose a field and sort direction.
Review the newly ordered records.

Your JSON stays on this device

JSONata reads and transforms the JSON inside this browser tab. Bookify does not upload or save the data or expression. Every run has time, sequence, stack, input, and output limits, and $eval stays disabled.