Forge Json

Tabular Operations (Free Online Tool)

Shape tabular JSON rows with spreadsheet-like operations before later transforms or export

Paste your JSON → Get results instantly (no signup)

⚡ Instant resultsNo signupRuns in your browser
Try examples:

→ Apply tabular operations to the items array and calculate each item's line total.

{
"order_id": "ord_1049",
"customer": {
"name": "Maya Chen",
"email": "maya@example.com"
},
"items": [
{
"sku": "tee_black_m",
"qty": 2,
"price": "24.00"
},
{
"sku": "cap_white",
"qty": 1,
"price": "18.00"
}
],
"payments": [
{
"status": "failed",
"amount": 66
},
{
"status": "paid",
"amount": 66
}
]
}
Output✓
1{
2  "order_id": "ord_1049",
3  "customer": {
4    "name": "Maya Chen",
5    "email": "maya@example.com"
6  },
7  "items": [
8    {
9      "sku": "tee_black_m",
10      "qty": 2,
11      "price": "24.00",
12      "line_total": 48
13    },
14    {
15      "sku": "cap_white",
16      "qty": 1,
17      "price": "18.00",
18      "line_total": 18
19    }
20  ],
21  "payments": [
22    {
23      "status": "failed",
24      "amount": 66
25    },
26    {
27      "status": "paid",
28      "amount": 66
29    }
30  ]
31}

Love the result?

Use this exact pipeline in your app, backend, or LLM workflow.

No setup needed. Works with curl, Node, Python.

Uses example data. For edited input, copy from the playground.

Read integration guide

Works with:

  • API responses
  • Nested JSON
  • Arrays & objects

Example: input → output

Input / Output
Input
{
  "order_id": "ord_1049",
  "customer": {
    "name": "Maya Chen",
    "email": "maya@example.com"
  },
  "items": [
    {
      "sku": "tee_black_m",
      "qty": 2,
      "price": "24.00"
    },
    {
      "sku": "cap_white",
      "qty": 1,
      "price": "18.00"
    }
  ],
  "payments": [
    {
Output
{
  "order_id": "ord_1049",
  "customer": {
    "name": "Maya Chen",
    "email": "maya@example.com"
  },
  "items": [
    {
      "sku": "tee_black_m",
      "qty": 2,
      "price": "24.00",
      "line_total": 48
    },
    {
      "sku": "cap_white",
      "qty": 1,
      "price": "18.00",
      "line_total": 18
    }
  ],

Related tools

Read more on the blog

Advanced usage (optional)

Tabular Operations

v1.0.0
Structure
arraydestructive

Description

Tabular Operations

Build a sequence of spreadsheet-like row operations on JSON arrays. Works like a mini data pipeline — operations execute in order, each transforming the output of the previous step.

Operations

FILTER

Keep rows matching a condition expression.

FILTER {{ age >= 18 }}
FILTER {{ status === "active" }}

ADD COLUMN

Create a new column from an expression.

ADD COLUMN fullName = {{ firstName + " " + lastName }}
ADD COLUMN tax = {{ salary * 0.1 }}

RENAME COLUMN

Rename a column, preserving row field order.

RENAME COLUMN firstName TO first_name

REMOVE COLUMN

Delete one or more columns from all rows.

REMOVE COLUMN tempId, debugFlag

SORT BY

Sort rows by a field. Default direction is ASC. Nulls sort to end.

SORT BY age DESC
SORT BY name ASC

DEDUPLICATE BY

Keep only the first occurrence per unique key combination.

DEDUPLICATE BY email
DEDUPLICATE BY firstName, lastName

DSL Mode

Switch to DSL mode for a text-based interface. One operation per line, comments start with #.

# Clean up user data
FILTER {{ age >= 18 }}
REMOVE COLUMN tempId, debugFlag
ADD COLUMN fullName = {{ firstName + " " + lastName }}
SORT BY fullName ASC
DEDUPLICATE BY email

Expressions

Expressions use {{ }} syntax and support field references, arithmetic, string concatenation, and comparisons:

  • {{ age >= 18 }} — boolean comparison
  • {{ firstName + " " + lastName }} — string concatenation
  • {{ price * quantity }} — arithmetic

Configuration

NameTypeDefaultDescription
Modeenumdocument-rowdocument-row treats an object document as one formula row. array-path edits each item in a selected nested array. document-row array-path
Source Arraypath-pickerSelect the nested array whose items should be edited as tabular rows.
Operationstabular-operations[]Build a sequence of spreadsheet-like row operations. Switch to DSL mode for a text-based interface.

Examples

AI Prompt
Apply tabular operations to the items array and calculate each item's line total.
{
"order_id": "ord_1049",
"customer": {
"name": "Maya Chen",
"email": "maya@example.com"
},
"items": [
{
"sku": "tee_black_m",
"qty": 2,
"price": "24.00"
},
{
"sku": "cap_white",
"qty": 1,
"price": "18.00"
}
],
"payments": [
{
"status": "failed",
"amount": 66
},
{
"status": "paid",
"amount": 66
}
]
}
Output✓
1{
2  "order_id": "ord_1049",
3  "customer": {
4    "name": "Maya Chen",
5    "email": "maya@example.com"
6  },
7  "items": [
8    {
9      "sku": "tee_black_m",
10      "qty": 2,
11      "price": "24.00",
12      "line_total": 48
13    },
14    {
15      "sku": "cap_white",
16      "qty": 1,
17      "price": "18.00",
18      "line_total": 18
19    }
20  ],
21  "payments": [
22    {
23      "status": "failed",
24      "amount": 66
25    },
26    {
27      "status": "paid",
28      "amount": 66
29    }
30  ]
31}
Config
Mode
array-path
Source Array
items
Operations
ADD COLUMN line_total = {{ qty * price }}

API Usage

POST /api/v1/utilities/structure.tabular-ops
Example:
curl -X POST https://your-domain.com/api/v1/utilities/structure.tabular-ops \
  -H "Authorization: Bearer YOUR_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{"inputs":{"primary":{"order_id":"ord_1049","customer":{"name":"Maya Chen","email":"maya@example.com"},"items":[{"sku":"tee_black_m","qty":2,"price":"24.00"},{"sku":"cap_white","qty":1,"price":"18.00"}],"payments":[{"status":"failed","amount":66},{"status":"paid","amount":66}]}},"config":{"mode":"array-path","sourcePath":"items","operations":[{"type":"addColumn","name":"line_total","formula":"{{ qty * price }}"}]}}'
Response
1{
2  "order_id": "ord_1049",
3  "customer": {
4    "name": "Maya Chen",
5    "email": "maya@example.com"
6  },
7  "items": [
8    {
9      "sku": "tee_black_m",
10      "qty": 2,
11      "price": "24.00",
12      "line_total": 48
13    },
14    {
15      "sku": "cap_white",
16      "qty": 1,
17      "price": "18.00",
18      "line_total": 18
19    }
20  ],
21  "payments": [
22    {
23      "status": "failed",
24      "amount": 66
25    },
26    {
27      "status": "paid",
28      "amount": 66
29    }
30  ]
31}