Tabular Operations (Free Online Tool)

Shape and slice 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.

Output✓

{
  "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

Supported tabular primitives

Tabular Operations supports these row-level primitives. Operations run in order, so each row starts from the output of the previous primitive.

Primitive	What it does	Config	DSL example
Filter rows `filter`	Keep only rows where the condition evaluates to true.	`condition`	`FILTER {{ age >= 18 }}`
Add column `addColumn`	Create or overwrite a field on each row from a formula.	`name, formula`	`ADD COLUMN total = {{ price * qty }}`
Rename column `renameColumn`	Rename a field while preserving the rest of the row.	`from, to`	`RENAME COLUMN firstName TO first_name`
Remove columns `removeColumn`	Delete one or more fields from every row.	`columns`	`REMOVE COLUMN tempId, debugFlag`
Sort rows `sort`	Order rows by a field in ascending or descending order.	`by, direction`	`SORT BY age DESC`
Deduplicate rows `deduplicate`	Keep the first row for each unique key or key combination.	`by`	`DEDUPLICATE BY email`
Slice rows `sliceRows`	Return a window of rows using offset and limit.	`offset, limit`	`SLICE ROWS OFFSET 10 LIMIT 25`
Insert row `insertRow`	Append a new object row before later operations run.	`row`	`INSERT ROW { "name": "Alice" }`
Update rows where `updateWhere`	Set one or more fields on rows matching a condition.	`where, set`	`UPDATE WHERE {{ age >= 30 }} SET status = "active"`
Delete rows where `deleteWhere`	Remove rows matching a condition.	`where`	`DELETE WHERE {{ age < 18 }}`

Example: input → output

Input / OutputInputOutput

Related tools

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

Name	Type	Default	Description
Mode	`enum`	`document-row`	document-row treats an object document as one formula row. array-path edits each item in a selected nested array. `document-row` `array-path`
Source Array	`path-picker`		Select the nested array whose items should be edited as tabular rows.
Operations	`tabular-operations`	`[]`	Build a sequence of spreadsheet-like row operations. Switch to DSL mode for a text-based interface.

Supported tabular primitives

Tabular Operations supports these row-level primitives. Operations run in order, so each row starts from the output of the previous primitive.

Primitive	What it does	Config	DSL example
Filter rows `filter`	Keep only rows where the condition evaluates to true.	`condition`	`FILTER {{ age >= 18 }}`
Add column `addColumn`	Create or overwrite a field on each row from a formula.	`name, formula`	`ADD COLUMN total = {{ price * qty }}`
Rename column `renameColumn`	Rename a field while preserving the rest of the row.	`from, to`	`RENAME COLUMN firstName TO first_name`
Remove columns `removeColumn`	Delete one or more fields from every row.	`columns`	`REMOVE COLUMN tempId, debugFlag`
Sort rows `sort`	Order rows by a field in ascending or descending order.	`by, direction`	`SORT BY age DESC`
Deduplicate rows `deduplicate`	Keep the first row for each unique key or key combination.	`by`	`DEDUPLICATE BY email`
Slice rows `sliceRows`	Return a window of rows using offset and limit.	`offset, limit`	`SLICE ROWS OFFSET 10 LIMIT 25`
Insert row `insertRow`	Append a new object row before later operations run.	`row`	`INSERT ROW { "name": "Alice" }`
Update rows where `updateWhere`	Set one or more fields on rows matching a condition.	`where, set`	`UPDATE WHERE {{ age >= 30 }} SET status = "active"`
Delete rows where `deleteWhere`	Remove rows matching a condition.	`where`	`DELETE WHERE {{ age < 18 }}`

Examples

AI Prompt

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

Output✓

{
  "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}

Love the result?

Supported tabular primitives

Example: input → output

Related tools

Read more on the blog

Tabular Operations

Description

Tabular Operations

Operations

FILTER

ADD COLUMN

RENAME COLUMN

REMOVE COLUMN

SORT BY

DEDUPLICATE BY

DSL Mode

Expressions

Configuration

Supported tabular primitives

Examples

API Usage

Related Tools

Rename Keys

Find & Replace

Filter

Flatten / Nest

Pick Fields