JSON tools
Start with format, validate, or compare when you need quick JSON cleanup. Then open focused tools for XML, YAML, TOML, CSV, NDJSON, Schema, JSONPath, Pointer, Patch, table editing, Base64 previews, or codegen. These JSON utilities run in your tab; generators infer types from one sample, using the first item when the input is an array.
Not sure which card to open? Read Which JSON tool do I need?—a short task map with links to the right pages.
Learn more: JSON & this workspace
This hub lists focused tools for JSON and nearby formats. Each card opens a separate page so you can bookmark or share a specific task.
What JSON is
JSON (JavaScript Object Notation) is a text format for structured data: objects as `{ "key": value }`, arrays as `[ … ]`, and values that are strings, numbers, booleans, or null. It is widely used for APIs, config, and logs because it is easy for both people and programs to read.
JSON is not the same as a JavaScript object literal in every detail (for example keys must be double-quoted strings), but the mental model is similar.
Privacy & how these tools run
The utilities linked from this hub run in your browser: paste or type on your device, and the page transforms data locally unless a tool’s label says otherwise. That keeps routine formatting and conversion off a server.
Browse JSON utilities
Start with formatter and compare for everyday work. Use conversion, query, schema, and codegen cards when the payload needs a more specific workflow.
JSON formatter
ClientJSON format: pretty-print, minify, escape/unescape string literals, copy, download .json—all in your browser.
JSON syntax rules
ClientRFC 8259 reference with a JSON.parse checker—parse errors plus hints for commas, quotes, and comments.
String & Unicode helpers
ClientMinify, escape quotes for embedding, Unicode ↔ UTF-8, CJK punctuation in values—sample pre-filled.
Compare JSON
ClientTwo panels, structural diff paths, format both—pre-filled example, all client-side.
JSON tree viewer
ClientCollapsible tree—filter keys, copy JSONPath or JSON Pointer paths; read-only exploration.
JSON sort keys
ClientCanonical key order at every object level—pretty or minified output for diffs and hashing—local only.
JSON canonicalization (JCS)
ClientRFC 8785 JCS string for signing—deterministic bytes plus SHA-256 fingerprint, local only.
JSON ↔ XML
ClientConvert both ways, pretty-print or minify XML—sample JSON pre-filled, client-side.
plist XML ↔ JSON
ClientApple property list XML ↔ JSON—Info.plist-style dicts; XML text only, not binary blobs.
YAML ↔ JSON
ClientConvert both ways, format JSON and YAML—sample JSON pre-filled, js-yaml in the browser.
JSON ↔ KDL
ClientKDL node documents beside JSON arrays—pairs with YAML/TOML when you prefer node syntax.
JSON ↔ MessagePack / CBOR
ClientBinary compact formats: encode JSON to MessagePack or CBOR, decode Base64 bytes back—client-side.
JSON ↔ BSON
ClientMongoDB-style BSON: encode a JSON object to bytes or decode Base64 BSON back—client-side.
TOML ↔ JSON
ClientConvert both ways, format JSON and TOML—sample JSON pre-filled, parsed in the browser.
INI ↔ JSON
ClientLegacy config.ini ↔ JSON—nested objects map to sections, arrays repeat keys; npm ini in the browser.
HOCON ↔ JSON
ClientHuman-Optimized Config Object Notation ↔ JSON—JVM-friendly configs in the browser.
HCL ↔ JSON
ClientHashiCorp Configuration Language ↔ JSON—Terraform / OpenTofu blocks parsed locally.
CSV ↔ JSON
ClientTable paste to JSON objects or arrays, JSON arrays to CSV—comma, tab, or semicolon; optional header row.
Excel (XLSX) → JSON
ClientPick a workbook—export one sheet as a JSON row array or every sheet as named arrays; local only.
JSON → Excel (XLSX)
ClientPaste JSON—arrays of objects, grids, or a map of sheet names to arrays—download a workbook locally.
NDJSON / JSON Lines
ClientOne JSON value per line: merge into an array, split arrays back to lines, validate and format—local only.
JSON array chunks
ClientSplit a JSON array into fixed-size batches or merge nested arrays into one list—pagination and batch helpers, local only.
JSON flatten / unflatten
ClientDot paths for nested objects and array indices—round-trip flat map.
JSON Schema validate
ClientValidate instances, format schemas, infer draft-07 from sample data—Ajv in the browser.
JSON Schema $ref expand
ClientResolve same-document #/ pointers and inline refs—no network fetch; cycles stop at $ref.
JSON Schema multi-file bundle
ClientPaste primary + named schema files; expand $ref across files locally—no HTTP, no CORS.
JSON Schema → sample JSON
ClientDraft example JSON from pasted schemas—minimal or full object keys, enums, defaults—client-side.
JSON Pointer & Patch
ClientRFC 6901 resolve, RFC 6902 apply, generate diffs between two documents—local only.
JSON5 / JSONC → JSON
ClientComments, trailing commas, JSON5 keys—convert to strict JSON for APIs and tests.
JSON repair
ClientFix almost-JSON (trailing commas, minor delimiter issues) to strict JSON—browser-only.
JSON Merge Patch
ClientRFC 7396 merge into a base document—null removes keys; differs from JSON Patch ops.
JSONPath & JMESPath
ClientQuery with JSONPath or JMESPath—results as JSON, no upload.
jq filter
ClientFull jq syntax in the browser—filters, pipes, and functions; lazy-loaded WebAssembly.
JSONata
ClientDeclarative transforms and aggregates with JSONata—alternative to jq for integration-style payloads.
JSON Logic
ClientPortable rule trees on JSON—if, var, comparisons, map—evaluate locally against your payload.
JSON ↔ Properties
ClientJava .properties style key=value lines with dot nesting—two-way.
JSON ↔ HTML table
ClientArray of objects as an editable table; export JSON when done.
JSON ↔ Markdown table
ClientPipe tables for READMEs and docs—round-trip array of objects; escape | as |.
JSON big integers
ClientSee standard vs bigint-safe parsing for large integers—side by side.
Base64 in JSON
ClientFind string fields that decode as Base64 and preview UTF-8 text.
JSON statistics
ClientNesting depth, key totals, object/array counts, and string vs number vs null tallies.
JSON → SQL INSERT
ClientArray of objects to a multi-row INSERT—table name you choose, columns from key union.
SQL INSERT → JSON
ClientParse INSERT … VALUES into a JSON array of row objects—strings, NULL, booleans.
JSON → SQL CREATE TABLE
ClientInfer CREATE TABLE from sample rows—SQLite or PostgreSQL types, client-side.
JSON → URL query string
ClientEncode flat key/value JSON into a query string for links and APIs.
URL query string → JSON
ClientDecode application/x-www-form-urlencoded text into a JSON object.
JSON → curl command
ClientMinify JSON and build a curl --data line with Content-Type for quick API repro.
JSON → OpenAPI draft
ClientSample JSON to a minimal OpenAPI 3.0 spec snippet—inferred schema, request or response role.
JSON → AsyncAPI draft
ClientSample JSON to AsyncAPI 2.6 with one channel—inferred message payload, producer or consumer role.
JSON → GraphQL SDL
ClientDraft GraphQL object types from sample JSON—inferred fields, first array element only.
JSON → Protocol Buffers (proto3)
ClientDraft proto3 messages from sample JSON—snake_case fields, repeated arrays, nested messages.
JSON → Apache Avro schema
ClientAvro schema JSON from sample data—record and array roots, nested records, client-side.
JSON deep merge
ClientTwo JSON objects with nested merge—arrays and scalars from the right win.
JSON → .env lines
ClientNested JSON to dot-separated KEY=value lines for config snippets.
.env lines → JSON
ClientBuild nested JSON from dot-separated keys in env-style lines.
JSON path list
ClientList paths from $ to every primitive—pair with Pointer or JSONPath.
Extract JSON from text
ClientFirst {...} or [...] in logs or mixed paste—strict JSON, pretty-print.
JSON redact keys
ClientReplace values for password, token, and other keys you list with [REDACTED].
JSON pick or omit keys
ClientKeep or remove top-level keys on an object or on each object in an array—case-sensitive names.
JSON cleaner
ClientRemove null and optional empty strings, objects, or arrays—recursive cleanup in the browser.
JSON rename keys
ClientMap old key names to new at every object level—one line per mapping, local only.
JSON group by field
ClientBucket a root array of objects by one property—output an object of arrays.
JSON unique by field
ClientDeduplicate array rows using one field—keep first or last match per value.
Sort JSON array by field
ClientReorder array rows by one property—ascending or descending, local only.
JSON apply defaults
ClientFill missing keys from a defaults template—never overwrite existing values.
JSON → Go structs
ClientGo structs with json tags from a sample object or array element.
JSON → Kotlin data classes
ClientData classes from sample JSON—nested types from the first example.
JSON → C# classes
ClientPaste a JSON object to generate C# POCOs with System.Text.Json-friendly property names.
JSON → Java classes
ClientPaste a JSON object to generate simple public-field POJOs and nested types.
JSON → TypeScript interfaces
ClientPaste JSON to generate export interfaces—camelCase keys, nested types, arrays from the sample.
JSON → Zod schemas
ClientEmit z.object trees and z.infer types from sample JSON—runtime validation scaffolding, client-side.
JSON → Valibot schemas
ClientEmit v.object trees and InferOutput types from sample JSON—modular validators, client-side.
JSON → TypeBox schemas
ClientEmit Type.Object and Static types from sample JSON—JSON Schema–friendly validators, client-side.
JSON → Python TypedDict
Clienttyping.TypedDict from sample JSON—snake_case or camelCase keys, nested types from one example.
JSON → Rust structs (serde)
ClientSerde structs with rename attributes from sample JSON—browser-side scaffolding.
JSON → Swift structs (Codable)
ClientSwift structs with Codable from sample JSON—CodingKeys when keys differ.
JSON → PHP classes
ClientPHP 8+ typed properties and list phpdoc from a sample object or array element.
JSON → Ruby classes
ClientRuby classes with attr_accessor—snake_case symbols from JSON keys.
JSON → Clojure records
Clientdefrecord scaffolding with kebab-case fields—keywordize keys when decoding.
JSON → Elixir structs
Clientdefstruct modules with Jason.Encoder from sample JSON—snake_case atoms, client-side.
JSON → Scala case classes
Clientfinal case class scaffolding from sample JSON—Seq/circe-friendly, client-side.
JSON → Dart classes
ClientDart immutable classes with required constructors from sample JSON.
JSON → Nim types
ClientNim object types from sample JSON—exported fields, seq for arrays, client-side.
JSON → Haskell records
ClientRecord types with aeson Generic codecs from sample JSON—adjust jsonOpts for your key style.
JSON camelCase keys
ClientConvert every object key to camelCase recursively—in your browser, no upload.
JSON snake_case keys
ClientConvert object keys to snake_case at every level—local JSON key normalization.
JSON kebab-case keys
ClientConvert JSON object keys to kebab-case throughout nested structures—client-side only.
JSON pluck field
ClientFrom a JSON array of objects, output an array of one field's values—browser-only.
JSON count by field
ClientCount occurrences of each value for one property across a JSON object array—local only.
JSON filter by field
ClientKeep objects in a JSON array where one field equals a value—client-side row filter.
JSON dedupe array
ClientRemove duplicate elements from a JSON array—first occurrence wins, order preserved.
JSON shuffle array
ClientRandomly shuffle a JSON array in the browser—Fisher–Yates, new order each click.
JSON reverse array
ClientReverse the order of elements in a JSON array—non-destructive copy, local only.
JSON slice array
ClientTake a slice of a JSON array by start and optional end index—like Array.slice.
JSON concat arrays
ClientFlatten one level: concatenate arrays from a JSON array-of-arrays—client-side.
JSON wrap in array
ClientWrap any JSON value in a one-element array if it is not already an array—local helper.
JSON unwrap single element
ClientIf the root is an array with exactly one item, output that item—otherwise report an error.
JSON limit depth
ClientTruncate JSON nesting at a maximum depth—replace deeper nodes with {} or []—local only.
JSON double parse
ClientParse a JSON string value twice when APIs double-encode JSON as a string—browser-only.
JSON object to entries
ClientConvert a JSON object to an array of [key, value] pairs—Object.entries in the browser.
JSON entries to object
ClientBuild an object from an array of [key, value] pairs—Object.fromEntries locally.
JSON uppercase strings
ClientUppercase every string leaf in JSON—keys unchanged, numbers and booleans untouched.
JSON trim strings
ClientTrim leading and trailing whitespace from every string value in JSON—local cleanup.
JSON flatten arrays (one level)
ClientFlatten a JSON array by one level—[[1,2],3] becomes [1,2,3]—client-side.
JSON sort array values
ClientSort a JSON array of primitives or mixed values—asc or desc, in your browser.
JSON unique key names
ClientList every distinct object key in a JSON document—sorted alphabetically, local only.
JSON delete key
ClientDelete one property name recursively from objects—values gone at every depth, local only.
JSON prefix keys
ClientPrepend the same string to all object keys recursively—client-side rename helper.
JSON suffix keys
ClientAppend a suffix to each object key throughout nested JSON—in the browser only.
JSON lowercase keys
ClientLowercase every object key recursively—distinct from snake_case or camelCase transforms.
JSON coerce numbers
ClientConvert numeric strings to JSON numbers recursively—local type cleanup for imports.
JSON coerce booleans
ClientTurn "true" and "false" strings into JSON booleans at any depth—browser-only.
JSON null to empty string
ClientReplace JSON null leaves with empty strings—recursive, local transformation.
JSON empty string to null
ClientConvert empty string values to JSON null recursively—in your browser.
JSON object values array
ClientOutput Object.values order as a JSON array—root must be an object, local only.
JSON object keys array
ClientList object property names as a JSON string array—Object.keys in the browser.
JSON array to indexed object
ClientMap array indices to string keys—0, 1, 2… as object properties, client-side.
JSON pad array
ClientExtend a JSON array with null until it reaches a target length—truncate if longer.
JSON take first N
ClientKeep only the first N elements of a JSON array—non-negative count, local only.
JSON root type
ClientReport whether JSON root is object, array, string, number, boolean, or null—local.
JSON minify
ClientMinify JSON to a single line with no extra whitespace—in your browser.
JSON merge arrays by key
ClientJoin rows from left and right arrays on a shared field—spread merge, browser-only.
JSON zip columns
ClientTurn an object of parallel arrays into an array of row objects—local ETL helper.
JSON rotate array
ClientRotate JSON array elements by N positions—positive shifts left, local only.
JSON lowercase strings
ClientLowercase every string value in JSON—keys and numbers unchanged, in your browser.
JSON drop nulls
ClientDelete JSON null from objects and arrays recursively—local cleanup before export.
JSON drop empty values
ClientPrune empty strings, null, and empty arrays/objects recursively—browser-only.
JSON sum field
ClientSum one numeric field across an array of objects—local quick aggregate.
JSON average field
ClientCompute the average of one numeric field in a JSON array—client-side only.
JSON min max field
ClientFind minimum and maximum for one numeric field in a JSON array—local only.
JSON sort by field
ClientSort an array of objects by one property—asc or desc, in your browser.
JSON invert object
ClientFlip a flat JSON object so values become keys—scalar values only, local.
JSON filter nulls from array
ClientRemove null entries from a root JSON array—does not walk nested objects.
JSON filter array by type
ClientKeep array elements matching one JSON type—string, number, boolean, object, array, or null.
JSON skip first N
ClientSkip the first N items of a JSON array—non-negative count, browser-only.
JSON take last N
ClientKeep only the last N elements of a JSON array—local list trimming.
JSON interleave arrays
ClientInterleave left and right JSON arrays—{left, right} input, browser-only.
JSON diff object keys
ClientList keys only in A, only in B, or in both—{a, b} objects, local.
JSON replace values
ClientReplace every value equal to from with to—use from|to, JSON or plain text.
JSON set field on rows
ClientSet one field on every object in a JSON array—field=value, value may be JSON.
JSON node count
ClientCount every value node in JSON—including nested objects and arrays, local.
JSON array type counts
ClientCount how many string, number, object, array, boolean, and null items are in a JSON array.
JSON unique field values
ClientList distinct values for one field across object rows—order preserved, local.
JSON nest under key
ClientWrap any JSON value under a single property name—local envelope helper.
JSON omit keys
ClientDelete listed object keys recursively—comma-separated names, browser-only.
JSON rename one key
ClientRename a single property name at every object level—local rename helper.
JSON shallow merge rows
ClientMerge an array of objects into one shallow object—later keys overwrite, local.
JSON flatten to dot keys
ClientFlatten nested JSON into dot-path keys such as user.name—browser-only.
JSON unflatten dot keys
ClientExpand flat dot keys back into nested JSON—in your browser.
JSON get by dot path
ClientRead a single value with dot notation such as user.name—local JSON pointer lite.
JSON add row index
ClientAdd an index field to each object in a JSON array—default name index.
JSON join string array
ClientJoin a JSON array of strings with a delimiter—root array only, local.
JSON stringify numbers
ClientConvert every JSON number to its string form recursively—browser-only.
JSON compact array
ClientRemove null and undefined from a root JSON array—does not recurse into objects.
JSON partition by field
ClientSplit an object array into matched and rest by field=value—local only.
JSON unzip rows to columns
ClientConvert an array of objects into an object of parallel arrays—inverse of zip.
JSON merge two objects
ClientShallow merge left and right objects—right keys overwrite, {left, right} input.
JSON clamp numbers
ClientClamp every numeric leaf between min and max—use min|max, browser-only.
JSON capitalize strings
ClientCapitalize the first character of every string leaf—keys unchanged, local.
JSON array to lines
ClientFormat each array element as one minified JSON line—NDJSON-style output.
JSON count missing field
ClientCount how many objects in an array lack a given property—local QA helper.
JSON fill missing field
ClientAdd a default value only when a field is missing on object rows—field=value.
JSON strip row fields
ClientRemove listed fields from each object in a JSON array—comma-separated names.
JSON pick row fields
ClientKeep only selected fields on each object in a JSON array—local column pick.
JSON sum numeric array
ClientSum numbers in a root JSON array—numeric strings coerced, browser-only.
JSON average numeric array
ClientAverage numeric elements in a JSON array—local aggregate helper.
JSON min max array
ClientMinimum and maximum of numeric array elements—in your browser.
JSON product numeric array
ClientMultiply numeric elements in a JSON array—client-side math helper.
JSON reject by field
ClientFilter out object rows where field=value—inverse of filter-by-field, local.
JSON all rows have field
ClientTest whether every object row includes a property—boolean summary, local.
JSON any row has field
ClientTrue if at least one object row contains a field—local QA helper.
JSON compare two values
ClientCompare JSON values a and b for deep equality—{a, b} input, browser-only.
JSON key count
ClientCount and list top-level object keys—root must be an object, local.
JSON array length
ClientReturn the length of a root JSON array—simple metadata, local.
JSON sort numeric array
ClientSort a JSON array numerically—asc or desc order parameter, browser-only.
JSON collect scalars
ClientExtract all string, number, and boolean leaves into separate arrays—local walk.
JSON object to key-value array
ClientConvert an object to an array of {key, value} objects—local ETL helper.
JSON key-value array to object
ClientBuild an object from rows with key and value properties—browser-only.
JSON stringify booleans
ClientConvert JSON boolean leaves to "true" and "false" strings—recursive, local.
JSON flip booleans
ClientToggle every JSON boolean leaf—recursive NOT, in your browser.
JSON set by dot path
ClientSet a nested value using dot.path=value—value may be JSON, browser-only.
JSON map with lookup
ClientReplace scalar values using a JSON lookup object—recursive map, local.
JSON shallow diff objects
ClientDiff two objects at one level—onlyLeft, onlyRight, changed keys, local.
JSON explode array field
ClientExpand an array field on each object row into multiple rows—local flatten.
JSON collapse field values
ClientGroup object rows by one field and collect duplicates into arrays—local ETL.
JSON absolute numbers
ClientApply Math.abs to every numeric leaf in JSON—recursive, browser-only.
JSON round numbers
ClientRound numeric leaves to N decimal places—parameter 0–10, local only.
JSON truncate strings
ClientCut every string leaf to a maximum character count—recursive cleanup.
JSON first array element
ClientReturn the first element of a root JSON array—errors if empty, local.
JSON last array element
ClientReturn the last element of a root JSON array—browser-only.
JSON nth array element
ClientRead array[index] from root JSON—integer index parameter, local.
JSON index of value
ClientFind zero-based index of a value in a root array—JSON or plain parameter.
JSON includes value
ClientCheck whether a JSON value appears anywhere in the document—local walk.
JSON remove value
ClientRemove every node equal to a value—arrays filtered, objects pruned, recursive.
JSON max depth
ClientMeasure maximum nesting depth of JSON objects and arrays—metadata only.
JSON deep clone
ClientDeep-copy JSON via parse/stringify—detached clone in your browser.
JSON unwrap single-key objects
ClientRecursively unwrap objects that have only one property—local cleanup.
JSON coalesce fields
ClientPick first defined non-null field per row—comma-separated names, array output.
JSON concat fields
ClientConcatenate object fields with a delimiter—field1,field2|sep syntax, local.
JSON split field on rows
ClientSplit a string field on a delimiter for each row—field|delimiter parameter.
JSON transpose matrix
ClientTranspose a JSON array of equal-length arrays—2D matrix helper, local.
JSON array to CSV lines
ClientConvert an array of objects to CSV text with header row—browser-only.
JSON parse int strings
ClientParse numeric strings to integers with parseInt—recursive, local.
JSON is empty
ClientTest whether JSON is empty—empty array/object/string or null, local.
JSON floor numbers
ClientApply Math.floor to every numeric leaf in JSON—recursive, browser-only.
JSON ceil numbers
ClientApply Math.ceil to numeric leaves recursively—in your browser.
JSON negate numbers
ClientMultiply every numeric leaf by −1—recursive sign flip, local only.
JSON sign numbers
ClientReplace numeric leaves with their sign—recursive, browser-only.
JSON normalize whitespace
ClientCollapse runs of whitespace and trim string leaves—local cleanup.
JSON replace substrings
ClientReplace all occurrences of one substring in string leaves—from|to parameter.
JSON prefix strings
ClientPrepend the same text to every string leaf—recursive, local.
JSON suffix strings
ClientAppend text to every string leaf recursively—in your browser.
JSON merge arrays unique
ClientMerge left and right arrays with unique values—{left, right} input, local.
JSON intersect arrays
ClientKeep items appearing in both left and right arrays—browser-only.
JSON diff arrays
ClientItems in left not present in right array—{left, right} input, local.
JSON repeat array
ClientRepeat a root JSON array N times—non-negative count, browser-only.
JSON range array
ClientBuild [start…end] with optional step—parameter only; input JSON ignored.
JSON sort keys alphabetically
ClientSort object keys alphabetically at every level—distinct from sort-keys hub page.
JSON validate required fields
ClientCheck that every object row includes listed fields—comma-separated names.
JSON rename keys with map
ClientRename keys using a JSON map at every object level—local transform.
JSON count booleans
ClientCount true and false boolean leaves anywhere in JSON—metadata walk.
JSON top N by field
ClientSort object rows by one field and keep top N—field:n:asc|desc syntax.
JSON default for null
ClientSet a default when a row field is null—does not overwrite missing keys.
JSON fingerprint
Clientdjb2-style hex fingerprint and serialized length—local metadata, not crypto.
JSON multiply field
ClientMultiply one numeric field on each object row by a factor—local array transform.
JSON divide field
ClientDivide a numeric row field by a divisor—browser-only table math.
JSON add to field
ClientAdd a number to one field on every object row—local JSON array helper.
JSON subtract from field
ClientSubtract a number from one field on each row—in your browser.
JSON random sample rows
ClientShuffle and take N rows from a JSON array—local random subsample.
JSON distinct rows by field
ClientDeduplicate object rows by one field value—first row wins, local only.
JSON cumulative sum
ClientAdd a running cumulative sum column for one numeric field—browser-only.
JSON percent of total
ClientAdd each row's share of the column total as `{field}_pct`—local analytics.
JSON bucket rows by field
ClientGroup array rows into an object keyed by one field—local group-by preview.
JSON round field
ClientRound one numeric field to N decimal places on each row—local cleanup.
JSON abs field
ClientApply Math.abs to a single numeric column on each row—in your browser.
JSON chunk rows
ClientSplit a root JSON array into sub-arrays of fixed size—local pagination mock.
JSON swap row fields
ClientExchange two property names on each object row—local column swap.
JSON trim field strings
ClientTrim whitespace on a single string column—local import cleanup.
JSON uppercase field
ClientUppercase a single string column on each object row—browser-only.
JSON lowercase field
ClientLowercase a single string column on each row—local normalization.
JSON concat field values
ClientJoin one field from every row with a delimiter—outputs plain text.
JSON unique field check
ClientTest whether values in one column are unique—reports duplicates, local only.
JSON running average
ClientAdd expanding average column `{field}_runavg` for one numeric field—local stats.
JSON null to zero on field
ClientTurn null in one column into 0 on each row—does not change missing keys.
JSON merge unique arrays
ClientMerge two JSON arrays and drop duplicate values—local set union.
JSON wrap scalar
ClientWrap a JSON scalar root value under one property name—in browser.
JSON reverse shallow keys
ClientReverse the order of keys on a shallow JSON object—local only.
JSON normalize whitespace
ClientCollapse repeated whitespace in every JSON string leaf—browser-only.
JSON objects to CSV
ClientConvert an array of JSON objects to CSV text with a header row—local.
JSON map lookup
ClientReplace JSON values using a lookup object map—runs locally.
JSON shallow object diff
ClientCompare two JSON objects at one level—keys only in left, right, or changed.
JSON product numeric array
ClientMultiply all numbers in a JSON array—local aggregate.
JSON object to key-value rows
ClientTurn a JSON object into [{key,value},…] rows—browser helper.
JSON key-value rows to object
ClientBuild a JSON object from key/value row array—local only.
JSON set dot path
ClientSet a nested JSON value using a dot path—local transform.
JSON count root keys
ClientCount and list keys on a JSON object root—local metadata.
JSON default null field
ClientFill null values in one row field with a default—array of objects.
JSON flatten to dot keys
ClientFlatten nested objects to dot-path keys—local structure tool.
JSON unflatten dot keys
ClientRebuild nested JSON from dot-path keys—browser-only.
JSON get dot path
ClientRead one nested value by dot path from JSON—local.
JSON diff object keys
ClientList keys only in a, only in b, or in both—pair of objects.
JSON rename key everywhere
ClientRename one JSON property name at every depth—local.
JSON object keys array
ClientReturn object property names as a JSON string array—local.
JSON object values array
ClientReturn object property values as a JSON array—browser-only.
JSON array to indexed object
ClientMap array indices to object keys {0:…,1:…}—local.
JSON sum numeric array
ClientSum finite numbers in a JSON array—local aggregate.
JSON average numeric array
ClientMean of numeric JSON array elements—client-side.
JSON min max numeric array
ClientMin, max, and count for numeric JSON arrays—local.
JSON count nodes
ClientCount every value and container node in JSON—local stats.
JSON count field values
ClientHistogram of one row field's values—array of objects.
JSON wrap in array
ClientWrap any JSON root value in a single-element array—local.
JSON unwrap single array
ClientIf root is a one-item array, return that item—browser helper.
JSON array length meta
ClientReturn {length:n} for a JSON array root—local.
JSON minify
ClientMinify JSON to a compact single-line string—local.
JSON flatten arrays one level
ClientFlatten nested arrays by one level—local list helper.
JSON set field on rows
ClientSet one property to a constant on each object row—local.
JSON extract field array
ClientCollect one field from each row into a JSON array—local.
JSON group count by field
ClientGroup-count object rows by one field—browser histogram.
JSON filter field greater than
ClientKeep object rows whose numeric field is above a threshold—local.
JSON rank field descending
ClientAdd a rank column from one numeric or sortable field—local.
JSON ratio of two fields
ClientAdd numerator/denominator ratio column per row—browser-only.
JSON blank strings to null
ClientTurn empty or whitespace-only row strings into null—local.
JSON dedupe field keep last
ClientDeduplicate object rows by one field, keeping the last row—local.
JSON field numeric stats
ClientMin, max, mean, median, and sum for one numeric column—local.
JSON filter field less than
ClientKeep object rows whose numeric field is less than a threshold—local.
JSON filter field at most
ClientKeep rows with field less than or equal to a number—in browser.
JSON filter field at least
ClientKeep rows with field greater than or equal to a threshold—local.
JSON filter field equals
ClientKeep rows matching one field value—local equality filter.
JSON filter field between
ClientKeep rows whose field falls between min and max inclusive—browser.
JSON lag field
ClientAdd a column with the previous row's field value—time-series helper.
JSON lead field
ClientAdd a column with the next row's field value—local shift.
JSON adjacent field diff
ClientSubtract previous row's numeric field from the current row—local.
JSON adjacent percent change
ClientPercent change of a numeric field versus the prior row—browser.
JSON normalize field to sum 1
ClientDivide each row's numeric field by the column total—local proportions.
JSON min-max scale field
ClientMin-max scale one numeric column per row set—browser.
JSON reverse rows
ClientReverse the order of object rows in an array—local.
JSON sort rows by fields
ClientSort object rows by one or more fields—asc or desc, local.
JSON merge rows with defaults
ClientOverlay a default object onto every row—local schema padding.
JSON count field nulls
ClientCount null or missing values for one row field—metadata.
JSON forward fill field
ClientCarry the last non-null field value forward—local gap fill.
JSON backward fill field
ClientCarry the next non-null field value backward—browser.
JSON rows to Markdown table
ClientRender object rows as a GitHub-flavored Markdown table—local.
JSON min of two fields
ClientAdd min(a,b) column per row—local pairwise math.
JSON max of two fields
ClientAdd max(a,b) column per row—in browser.
JSON sum two fields
ClientAdd a+b column for two numeric fields on each row—local.
JSON field string length
ClientAdd character length for one string field per row—browser.
JSON group sum by field
ClientGroup rows and sum one numeric field—local pivot aggregate.
JSON group average by field
ClientMean of a numeric field within each group key—browser.
JSON group count rows
ClientHistogram row counts grouped by one field—local.
JSON rows to object by field
ClientUse one field value as object keys pointing to rows—local.
JSON inner join rows
ClientInner join left and right row arrays on a key—browser.
JSON left join rows
ClientLeft join row arrays on a shared key—local SQL-style merge.
JSON filter field contains
ClientKeep rows whose string field contains a substring—local.
JSON filter field starts with
ClientKeep rows where a string field starts with a prefix—browser.
JSON filter field ends with
ClientKeep rows where a string field ends with a suffix—local.
JSON coalesce to target field
ClientPick first non-null among fields into a target column—local.
JSON dedupe field keep first
ClientDrop duplicate rows by one field, keeping the first—browser.
JSON modulo field
ClientReplace one numeric field with value mod n on each row—local.
JSON power field
ClientExponentiate a numeric row field—browser math.
JSON square root field
ClientSquare root of one numeric field per row—local.
JSON concat row arrays
ClientAppend right rows after left from {left,right} input—local.
JSON truncate field strings
ClientCut string field to max length on each row—browser.
JSON enumerate rows
ClientAdd a 0-based index field to each object row—local.
JSON fields equal column
ClientAdd boolean column whether two fields are equal—local.
JSON take first rows
ClientKeep the first N rows from an object array—local slice.
JSON take last rows
ClientKeep the last N rows from an object array—in browser.
JSON skip first rows
ClientDrop the first N rows and keep the rest—local.
JSON every Nth row
ClientKeep every Nth row (0-based step)—browser downsampling.
JSON filter field not null
ClientKeep object rows with a non-null field value—local.
JSON filter field is null
ClientKeep rows where a field is null or missing—browser.
JSON filter field by regex
ClientKeep rows whose string field matches a regular expression—local.
JSON filter field in list
ClientKeep rows whose field value is in a comma-separated allow list—browser.
JSON floor numeric field
ClientApply Math.floor to one numeric field per row—browser.
JSON ceil numeric field
ClientApply Math.ceil to one numeric field per row—local.
JSON negate numeric field
ClientMultiply one numeric field by −1 on every row—browser.
JSON sign of numeric field
ClientMap numeric field to −1, 0, or 1 per row—local.
JSON rolling sum field
ClientAdd rolling sum column for a numeric field—browser.
JSON rolling average field
ClientAdd rolling average column for a numeric field—local.
JSON rotate row order
ClientRotate row array by N positions—browser.
JSON unique rows by fields
ClientKeep first row per unique combination of fields—local.
JSON sort rows by numeric field
ClientSort rows by one numeric field asc or desc—browser.
JSON filter field not equal
ClientExclude rows matching one field value—local inequality filter.
JSON count rows
ClientReturn row count metadata for an object array—browser.
JSON rows to HTML table
ClientRender object rows as an HTML table snippet—local.
JSON rows to TSV
ClientExport object rows as TSV for spreadsheets—browser.
JSON anti join rows
ClientLeft rows with no match in right array on a key—local.
JSON cross join rows
ClientCartesian product of left and right rows (capped)—browser.
JSON pad start field strings
ClientLeft-pad string field to length per row—local.
JSON pad end field strings
ClientRight-pad string field to length per row—browser.
JSON regex replace field
ClientRegex replace on one string field per row—local.
JSON cast field to string
ClientCoerce one field to string on each row—browser.
JSON cast field to number
ClientCoerce one field to number where finite—local.
JSON cast field to boolean
ClientMap common truthy/falsy strings to boolean—browser.
JSON drop fields list
ClientStrip comma-listed keys from every object row—local.
JSON validate unique composite fields
ClientReport duplicate composite keys across rows—browser.
JSON group median by field
ClientMedian of a numeric field within each group—local.
JSON group mode by field
ClientMode of a field within each group key—browser.
JSON union all row arrays
ClientAppend right rows after left from {left,right}—local stack.
JSON log10 field
ClientApply log10 to positive numeric field per row—browser.
JSON natural log field
ClientApply natural log to positive numeric field—local.
JSON column range stats
ClientMin, max, range, and count for one numeric column—browser.
JSON pick fields list
ClientProject rows to comma-listed keys—local column select.
JSON title case field
ClientCapitalize each word in a string field per row—local.
JSON snake case field
ClientConvert a string field to snake_case on each row—browser.
JSON filter empty string field
ClientKeep rows where a string field is empty—in browser.
JSON filter non-empty string field
ClientKeep rows where a string field has text—local.
JSON add constant field
ClientAdd the same field value to each object row—browser.
JSON rename field on rows
ClientRename a field key on every row—local.
JSON cumulative product field
ClientMultiply numeric field values down the row list—browser.
JSON rank field ascending
ClientAdd ascending rank column from one field—local.
JSON percent rank field
ClientAdd 0–1 percent rank for a numeric column—browser.
JSON z-score field
ClientStandardize a numeric field to z-scores—local.
JSON distinct field values
ClientReturn unique values from one column—browser.
JSON group keep first row
ClientOne row per group key, keeping the first—local.
JSON group keep last row
ClientOne row per group key, keeping the last—browser.
JSON default field if null
ClientReplace null or missing field with a default—local.
JSON substring field
ClientSlice a string field by start/end indices—browser.
JSON replace substring in field
ClientReplace all occurrences of text in a field—local.
JSON clamp numeric field
ClientBound numeric field to min/max on each row—browser.
JSON zip rows by index
ClientMerge {left,right} row arrays by position—local.
JSON filter field length greater
ClientKeep rows whose string field is longer than N—browser.
JSON filter field length less
ClientKeep rows whose string field is shorter than N—local.
JSON rows to CSV
ClientExport object rows as comma-separated values—browser.
JSON right join rows
ClientRight join on a shared key—local SQL-style merge.
JSON full outer join rows
ClientCombine left and right rows with matches and orphans—browser.
JSON intersect rows on key
ClientKeep left rows whose key exists in right—local.
JSON copy field on rows
ClientCopy field A into field B on each row—browser.
JSON extract digits from field
ClientStrip non-digits from a string field per row—local.
JSON round field decimals
ClientRound one numeric field to fixed decimal places—browser.
JSON std dev field stats
ClientMean and standard deviation for one column—local.
JSON variance field stats
ClientVariance of one numeric column—browser.
JSON covariance two fields
ClientSample covariance for two columns—local.
JSON correlation two fields
ClientCorrelation coefficient for two numeric columns—browser.
JSON running min field
ClientRolling minimum over a window on numeric field—local.
JSON running max field
ClientRolling maximum over a window—browser.
JSON ntile bucket field
ClientAssign n-tile bucket numbers to a numeric field—local.
JSON rows to plaintext lines
ClientFormat each row as key=value text lines—browser.
JSON pairs to object rows
ClientConvert [key,value] entries to {key,value} rows—local.
JSON percent of first row field
ClientExpress each row's numeric field as % of the first row—browser.
JSON interleave row arrays
ClientAlternate rows from left and right arrays—local.
JSON count split parts in field
ClientAdd column with split part count for a delimiter—browser.
JSON IQR field stats
ClientQ1, Q3, and IQR for a numeric column—local.
JSON camelCase field
ClientConvert a string field to camelCase on each row—local.
JSON kebab-case field
ClientConvert a string field to kebab-case per row—browser.
JSON trim start field
ClientRemove leading whitespace from a string field—local.
JSON trim end field
ClientRemove trailing whitespace from a string field—browser.
JSON reverse string field
ClientReverse string field characters on each row—local.
JSON filter field wildcard
ClientKeep rows matching field|pattern with * wildcards—browser.
JSON head and tail rows
ClientReturn first N and last N rows as {head,tail}—local.
JSON batch number field
ClientStamp batch numbers every N rows—browser.
JSON multiply field by constant
ClientMultiply one numeric field by a constant—local.
JSON divide field by constant
ClientDivide numeric field by a constant—browser.
JSON add constant to field
ClientAdd a constant to numeric field values—local.
JSON subtract constant from field
ClientSubtract a constant from numeric field—browser.
JSON fill null with mean
ClientReplace nulls in numeric field with column mean—local.
JSON fill null with median
ClientReplace nulls with column median—browser.
JSON field is numeric flag
ClientAdd is_numeric flag for one field per row—local.
JSON filter all fields present
ClientKeep rows where every listed field is non-null—browser.
JSON filter any field null
ClientKeep rows where any listed field is null—local.
JSON sort by field length
ClientSort rows by character length of one field—browser.
JSON word count field
ClientCount words in a string field per row—local.
JSON pad rows to length
ClientExtend row array to N items with empty objects—browser.
JSON rows to NDJSON
ClientExport object rows as NDJSON lines—local.
JSON lookup merge rows
ClientMerge selected fields from right into left on key—browser.
JSON mask middle of field
ClientMask string field keeping start/end chars—local.
JSON prefix string field
ClientAdd prefix to string field on each row—browser.
JSON suffix string field
ClientAdd suffix to string field per row—local.
JSON validate required fields
ClientReport rows missing any required field—browser.
JSON filter field numeric range
ClientKeep rows whose field is between min and max—local.
JSON unpivot fields to rows
ClientTurn listed fields into long attribute/value rows—browser.
JSON duplicate each row
ClientDuplicate each row a fixed number of times—local.
JSON stagger field by index
ClientAdd rowIndex×step to numeric field—browser.
JSON geometric mean field
ClientGeometric mean stats for positive numeric column—local.
JSON harmonic mean field
ClientHarmonic mean for non-zero numeric field—browser.
JSON collect all row keys
ClientList every distinct object key in the row set—local.
JSON coalesce numeric fields
ClientPick first parseable number among fields—browser.
JSON shuffle field values
ClientRandomly permute one field's values across rows—local.
JSON left N chars of field
ClientTruncate string field to first N chars—browser.
JSON reverse object keys
ClientRebuild each row object with keys in reverse order—local.
JSON semijoin on key
ClientSemijoin: left rows with key in right—browser.
JSON right N chars of field
ClientTake last N characters of string field—local.
JSON monotonic id field
ClientAdd incrementing numeric id column—browser.
JSON collapse whitespace field
ClientCollapse runs of whitespace in a string field—local.
JSON remove punctuation field
ClientRemove punctuation from a string field per row—browser.
JSON slugify field
ClientURL-safe slug from string field—local.
JSON center pad field
ClientCenter-pad string field to length—browser.
JSON repeat field string
ClientRepeat string field value N times per row—local.
JSON capitalize first letter
ClientUppercase first character of string field—browser.
JSON filter number type field
ClientKeep rows whose field typeof is number—local.
JSON filter string type field
ClientKeep rows whose field is a string—browser.
JSON filter boolean type field
ClientKeep rows whose field is boolean—local.
JSON filter array type field
ClientKeep rows whose field is an array—browser.
JSON compact row objects
ClientRemove null and undefined keys from each row—local.
JSON expand missing keys
ClientUnion all keys and fill missing with null—browser.
JSON sort by multiple fields
ClientSort rows by several fields with asc/desc—local.
JSON group concat field
ClientGroup by field and join values with delimiter—browser.
JSON running count field
ClientRunning count of non-null field values—local.
JSON field contains flag
ClientAdd contains flag column for substring—browser.
JSON symmetric diff on key
ClientRows in left or right but not both on key—local.
JSON exp field
ClientApply Math.exp to numeric field—browser.
JSON reciprocal field
ClientReplace field with 1/x where x≠0—local.
JSON square field
ClientReplace field with x² on each row—browser.
JSON key frequency
ClientFrequency of each object key across rows—local.
JSON rows to ASCII table
ClientPlain-text table from object rows—browser.
JSON validate JSON strings in field
ClientParse string field as JSON and report invalid rows—local.
JSON min field value
ClientColumn minimum for one numeric field—browser.
JSON max field value
ClientColumn maximum for one numeric field—local.
JSON join array field
ClientJoin array field with delimiter—browser.
JSON split field to array
ClientSplit string field by delimiter into array—local.
JSON char at index field
ClientExtract one character from string field—browser.
JSON char code at index
ClientUnicode code unit at index—local.
JSON every Nth row with offset
ClientKeep every Nth row starting at offset—browser.
JSON trim chars from field
ClientStrip listed characters from string field—local.
JSON rows to simple XML
ClientWrap rows in simple XML elements—browser.
JSON merge array fields
ClientMerge two array fields into one—local.
JSON running distinct count field
ClientRunning count of distinct field values—browser.
JSON sum field total
ClientTotal sum and count for one numeric field—local.
JSON balance field to zero mean
ClientSubtract column mean from numeric field—browser.
JSON row with min field
ClientReturn row object with minimum numeric field—local.
JSON row with max field
ClientReturn row object with maximum numeric field—browser.
JSON percent of column sum
ClientAdd column percent of sum for numeric field—local.
JSON field length column
ClientAdd character length for string field—browser.
JSON swap case field
ClientToggle upper/lower case per character—local.
JSON replace all in field
ClientGlobal substring replace on a string field—browser.
JSON column median field
ClientMedian summary for one numeric column—browser.
JSON column mode field
ClientMost frequent value in a column—local.
JSON column range field
ClientMin, max, and range for numeric column—browser.
JSON add two fields
ClientSum two columns into a target field—local.
JSON subtract two fields
ClientDifference of two numeric fields—browser.
JSON multiply two fields
ClientProduct of two columns per row—local.
JSON divide two fields
ClientRatio of two numeric fields—browser.
JSON filter field in set
ClientKeep rows whose field matches one of listed values—local.
JSON concat selected fields
ClientConcatenate chosen fields with delimiter—browser.
JSON first occurrence index
ClientAdd index of first row with same field value—local.
JSON repeated value flag
ClientBoolean column if field value appears more than once—browser.
JSON dense rank field
ClientDense ranking without gaps—local.
JSON ordinal rank field
Client1-based rank by sorted field values—browser.
JSON reverse words field
ClientReverse whitespace-separated words—local.
JSON trim start chars field
ClientRemove leading chars from string field—browser.
JSON trim end chars field
ClientRemove trailing chars from string field—local.
JSON alphanumeric only field
ClientStrip non-alphanumeric Unicode letters/digits—browser.
JSON rows to pipe lines
ClientPipe-separated export of object rows—local.
JSON field null count stats
ClientNull count and rate for one field—browser.
JSON field present count stats
ClientNon-empty count and rate—local.
JSON bottom N by field
ClientTake N rows with lowest numeric field—browser.
JSON skip first N rows
ClientSkip head rows from array—local.
JSON take while field less
ClientPrefix rows while numeric field stays under limit—browser.
JSON drop while field less
ClientDrop leading rows until field reaches threshold—local.
JSON swap two fields
ClientSwap two columns on each row—browser.
JSON copy field rename
ClientDuplicate one field into another key—local.
JSON exact duplicate row flag
ClientMark rows that appear more than once—browser.
JSON cube root field
ClientApply Math.cbrt per row—local.
JSON round field to step
ClientRound to nearest increment—browser.
JSON modulo two fields
ClientRemainder of two numeric fields—local.
JSON hypot two fields
ClientMath.hypot on two numeric columns—browser.
JSON geometric mean two fields
ClientSqrt of product for positive pair—local.
JSON MAD field stats
ClientMAD summary for one numeric column—browser.
JSON percentile rank field
ClientPercentile rank of field value in column—local.
JSON EWMA field
ClientEWMA column with alpha smoothing—browser.
JSON quantile field
ClientSingle quantile summary (0–1)—local.
JSON first non-null fields
ClientPick first non-null value from listed fields—browser.
JSON sin field
ClientApply Math.sin to radians in field—local.
JSON cos field
ClientApply Math.cos per row—browser.
JSON tan field
ClientApply Math.tan where defined—local.
JSON degrees to radians field
ClientMultiply field by π/180—browser.
JSON radians to degrees field
ClientMultiply field by 180/π—local.
JSON is even field flag
ClientAdd boolean if field is even integer—browser.
JSON is odd field flag
ClientAdd boolean if field is odd integer—local.
JSON is integer field flag
ClientBoolean column for integer numeric field—browser.
JSON is float field flag
ClientBoolean if numeric field has fractional part—local.
JSON truncate field decimals
ClientTruncate toward zero to N decimals—browser.
JSON significant figures field
ClientRound numeric field to significant figures—local.
JSON GCD two fields
ClientGCD of two integer fields—browser.
JSON LCM two fields
ClientLCM of two integer fields—local.
JSON average two fields
ClientAverage two numeric columns—browser.
JSON Manhattan distance fields
ClientAbs(a−b) per row—local.
JSON clamp to column stats
ClientBound each value to column min and max—browser.
JSON bitwise AND two fields
ClientTruncated integer AND per row—local.
JSON log2 field
ClientMath.log2 on positive numerics—browser.
JSON rows to semicolon CSV
ClientSemicolon-separated export—local.
JSON field distinct values
ClientDistinct values for one column—browser.
JSON field top values
ClientTop N values by count—local.
JSON field bottom values
ClientBottom N values by count—browser.
JSON streak length field
ClientRunning streak length for field—local.
JSON change sign field
ClientMultiply numeric field by −1—browser.
JSON absolute diff two fields
ClientAbsolute difference column—local.
JSON relative diff two fields
ClientRelative change (a−b)/b per row—browser.
JSON is within range field
ClientBoolean if field between min and max—local.
JSON coalesce string fields
ClientPick first non-empty string from two fields—browser.
JSON default empty string field
ClientFill blank strings with default—local.
JSON null to blank field
ClientReplace null with empty string—local.
JSON parse field JSON safe
ClientTry JSON.parse on string field per row—browser.
JSON stringify object field
ClientStringify object values in field—local.
JSON rotate string field left
ClientCyclic left rotation on string—browser.
JSON rotate string field right
ClientCyclic right rotation—local.
JSON insert at field index
ClientSplice text into string field—browser.
JSON append repeated char field
ClientPad end with repeated character—local.
JSON bitwise OR two fields
ClientTruncated integer OR per row—browser.
JSON asin field
ClientApply Math.asin per row on [-1,1]—local.
JSON acos field
ClientApply Math.acos per row—browser.
JSON atan field
ClientApply Math.atan per row—local.
JSON atan2 two fields
ClientAngle from (y,x) pair per row—browser.
JSON factorial field
ClientFactorial for small non-negative integers—local.
JSON is prime field flag
ClientBoolean if field is prime—browser.
JSON is divisible field
ClientTrue if fieldA mod fieldB is zero—local.
JSON modulo scalar field
ClientRemainder after division by constant—browser.
JSON power of ten field
ClientScale by powers of ten—local.
JSON is negative field flag
ClientBoolean if numeric field is below zero—browser.
JSON is positive field flag
ClientBoolean if numeric field is above zero—local.
JSON is zero field flag
ClientBoolean if numeric field equals zero—browser.
JSON copy sign fields
ClientMagnitude of A with sign of B—local.
JSON next power of two field
ClientSmallest 2^k >= value—browser.
JSON previous power of two field
ClientLargest 2^k <= value—local.
JSON popcount field
ClientHamming weight of truncated integer—browser.
JSON XOR two fields
ClientTruncated integer XOR per row—local.
JSON shift left field
ClientLeft shift by N bits—browser.
JSON shift right field
ClientSigned right shift by N bits—local.
JSON bitwise NOT field
ClientOne's complement on truncated integer—browser.
JSON field value histogram
ClientValue frequency map for one column—local.
JSON field entropy approx
ClientEntropy in bits from value frequencies—browser.
JSON duplicate key rows
ClientKeep rows whose key appears more than once—local.
JSON unique key rows
ClientKeep first row per key value—browser.
JSON sort by field desc
ClientStable descending sort on one field—local.
JSON reverse row order
ClientFlip row sequence—browser.
JSON add sequence id
ClientAppend 1-based sequence id column—local.
JSON field length between
ClientBoolean if string length between min and max—browser.
JSON filter numeric between
ClientFilter rows where field is between bounds—local.
JSON coalesce max two fields
ClientPick larger of two numerics when present—browser.
JSON coalesce min two fields
ClientPick smaller of two numerics when present—local.
JSON djb2 hash field
ClientAdd djb2 hash column for strings—browser.
JSON base64 encode field
ClientUTF-8 safe base64 per row—local.
JSON reverse chars field
ClientCharacter-reverse string column—browser.
JSON contains any substring
ClientTrue if field includes any listed needle—local.
JSON rows to simple YAML
ClientMinimal YAML list from object rows—browser.
JSON lerp two fields
Clienta + (b−a)×t per row—local.
JSON count digits field
ClientDigit character count per row—browser.
JSON count letters field
ClientA–Z letter count per row—local.
JSON field line count
ClientLine count from newline splits—browser.
JSON sinh field
ClientApply Math.sinh per row—local.
JSON cosh field
ClientApply Math.cosh per row—browser.
JSON tanh field
ClientApply Math.tanh per row—local.
JSON asinh field
ClientApply Math.asinh per row—browser.
JSON acosh field
ClientApply Math.acosh for values >= 1—local.
JSON atanh field
ClientApply Math.atanh on (-1,1)—browser.
JSON is NaN field flag
ClientBoolean if numeric field is NaN—local.
JSON is finite field flag
ClientBoolean if numeric field is finite—browser.
JSON compare equal fields
ClientTrue if fieldA equals fieldB per row—local.
JSON compare greater fields
ClientTrue if fieldA > fieldB—browser.
JSON compare less fields
ClientTrue if fieldA < fieldB—local.
JSON sum three fields
ClientAdd three numerics per row—browser.
JSON product three fields
ClientMultiply three numerics per row—local.
JSON average three fields
ClientArithmetic mean of three values—browser.
JSON min three fields
ClientSmallest of three numerics—local.
JSON max three fields
ClientLargest of three numerics—browser.
JSON snap to grid field
ClientRound field to nearest grid multiple—local.
JSON fractional part field
ClientKeep decimal portion via trunc—browser.
JSON integer part field
ClientFloor toward zero integer portion—local.
JSON round away from zero field
ClientCeil positive and floor negative—browser.
JSON take first N rows
ClientKeep only the first N rows—local.
JSON take last N rows
ClientKeep only the last N rows—browser.
JSON interleave two string fields
ClientMerge strings character-by-character—local.
JSON pad field to length
ClientRight-pad strings to length—browser.
JSON trim field to length
ClientHard cap string length per row—local.
JSON field word count
ClientWhitespace-separated word count—browser.
JSON field char frequency
ClientFrequency map across all rows—local.
JSON rows to JSON Lines
ClientOne minified JSON object per line—browser.
JSON field unique count stats
ClientUnique value count summary—local.
JSON diff from first row field
ClientSubtract first row value per row—browser.
JSON ratio to first row field
ClientDivide by first row numeric—local.
JSON field truthy flag
ClientJavaScript truthy check per row—browser.
JSON coerce field to number
ClientCoerce string numerics to number type—local.
JSON extract email domain field
ClientDomain after @ per row—browser.
JSON extract URL host field
ClientHostname from URL strings—local.
JSON replace regex in field
ClientGlobal regex replace per row—browser.
JSON split field with limit
ClientLimited split into array—local.
JSON join fields with space
ClientConcatenate fields with space separator—browser.
JSON filter truthy field rows
ClientFilter array to truthy field values—local.
JSON filter falsy field rows
ClientFilter array to falsy field values—browser.
JSON expm1 field
ClientApply Math.expm1 per row—local.
JSON log1p field
ClientApply Math.log1p per row—browser.
JSON field median stats
ClientMedian summary for one numeric column—local.
JSON field mode stats
ClientMost frequent value summary—browser.
JSON field range stats
ClientMin, max, and span summary—local.
JSON compare not equal fields
ClientTrue if fieldA differs from fieldB—browser.
JSON compare gte fields
ClientTrue if fieldA >= fieldB—local.
JSON compare lte fields
ClientTrue if fieldA <= fieldB—browser.
JSON absolute diff two fields
ClientAbsolute numeric delta per row—local.
JSON percent diff two fields
ClientPercent delta relative to fieldB—browser.
JSON cube field
ClientRaise field to third power per row—local.
JSON sign label field
ClientAdd sign label column for numeric field—browser.
JSON offset field by constant
ClientShift field by fixed offset per row—local.
JSON multiply field by scalar
ClientMultiply field by scalar per row—browser.
JSON round to step field
ClientRound field to nearest step size—local.
JSON truncate decimals field
ClientTruncate toward zero at N decimals—browser.
JSON clamp field 0–1
ClientBound field between 0 and 1—local.
JSON field sum of squares stats
ClientΣx² summary for one column—browser.
JSON field coefficient of variation
ClientCoefficient of variation summary—local.
JSON field IQR stats
ClientQ1, Q3, and IQR summary—browser.
JSON skip last N rows
ClientRemove the last N rows from an array—local.
JSON distinct by field first
ClientKeep first row per distinct field value—browser.
JSON distinct by field last
ClientKeep last row per distinct field value—local.
JSON strip prefix from field
ClientStrip leading prefix from string field—browser.
JSON strip suffix from field
ClientStrip trailing suffix from string field—local.
JSON remove all whitespace field
ClientDelete every whitespace char in field—browser.
JSON collapse spaces field
ClientNormalize internal whitespace per row—local.
JSON contains word flag
ClientBoolean if field contains whole word—browser.
JSON is null field flag
ClientBoolean if field is null per row—local.
JSON is empty string flag
ClientBoolean if field is empty string—browser.
JSON default if empty field
ClientFill empty or null field with default—local.
JSON extract URL path field
ClientPath segment from URL strings—browser.
JSON extract URL query field
ClientQuery string from URL values—local.
JSON field min length flag
ClientTrue if string field length >= min—browser.
JSON field max length flag
ClientTrue if string field length <= max—local.
JSON field average length stats
ClientMean character length summary—browser.
JSON field total length stats
ClientSum of string lengths summary—local.
JSON join fields with comma
ClientConcatenate fields with comma separator—browser.
JSON join fields with dash
ClientConcatenate fields with dash separator—local.
JSON first character field
ClientFirst char of string field per row—browser.
JSON last char field
ClientAdd last character column per row—local.
JSON second char field
ClientAdd second character column—browser.
JSON char code sum field
ClientSimple checksum from char codes—local.
JSON numeric bin field
ClientFloor values into fixed-width bins—browser.
JSON ensure prefix field
ClientPrefix string field when absent—local.
JSON ensure suffix field
ClientSuffix string field when absent—browser.
JSON count substring field
ClientNon-overlapping substring count—local.
JSON starts with flag field
ClientBoolean prefix match per row—browser.
JSON ends with flag field
ClientBoolean suffix match per row—local.
JSON includes substring flag
ClientBoolean contains check—browser.
JSON regex match flag field
ClientTest regex against string field—local.
JSON letters only field
ClientStrip non-letters from field—browser.
JSON pad left numeric field
ClientZero or custom left pad—local.
JSON split words array field
ClientWhitespace word tokens as array—browser.
JSON UTF-8 byte length field
ClientByte count for UTF-8 encoding—local.
JSON remove digits field
ClientDelete 0-9 from strings—local.
JSON remove letters field
ClientDelete A-Z from strings—browser.
JSON non-ASCII count field
ClientCount code points above 127—browser.
JSON filter field equals
ClientExact match filter on one field—local.
JSON filter field not equals
ClientExclude exact matches—browser.
JSON filter field contains
ClientSubstring filter on string field—local.
JSON filter field starts with
ClientPrefix filter on string field—browser.
JSON filter field ends with
ClientSuffix filter on string field—local.
JSON filter field greater than
ClientNumeric greater-than filter—browser.
JSON filter field less than
ClientNumeric less-than filter—local.
JSON coalesce two fields
ClientFirst non-empty of two fields—browser.
JSON omit fields list
ClientDrop columns by comma list—local.
JSON count non-null stats
ClientNon-null count summary—browser.
JSON count null stats
ClientNull count summary—local.
JSON percent non-null stats
ClientFill-rate percentage—browser.
JSON rows to compact JSON
ClientMinified JSON string output—local.
JSON field min value stats
ClientColumn minimum summary—browser.
JSON field max value stats
ClientColumn maximum summary—local.
JSON field mean absolute stats
ClientAverage magnitude summary—browser.
JSON left pad field
ClientPad on the left to width—local.
JSON left trim chars field
ClientStrip leading char set—browser.
JSON right trim chars field
ClientStrip trailing char set—local.
JSON append field to array
ClientPush item into array column—browser.
JSON URL scheme field
ClientAdd URL scheme column per row—local.
JSON URL TLD field
ClientAdd top-level domain column—browser.
JSON capitalize words field
ClientCapitalize first letter of each word—local.
JSON double string field
ClientConcatenate field with itself—browser.
JSON truncate middle field
ClientEllipsis in the center when over max length—local.
JSON mask email field
ClientHide most of the local part—browser.
JSON mask phone field
ClientKeep trailing digits only—local.
JSON is email flag field
ClientSimple email regex check per row—browser.
JSON is integer string flag
ClientWhole-number string test—local.
JSON is decimal string flag
ClientNumeric string with optional fraction—browser.
JSON count uppercase field
ClientUppercase letter tally per row—local.
JSON count lowercase field
ClientLowercase letter tally—browser.
JSON count special chars field
ClientSymbol count excluding letters, digits, space—local.
JSON field to hex
ClientHex bytes from UTF-8 text—browser.
JSON hex decode field
ClientParse even-length hex to UTF-8—local.
JSON normalize line endings field
ClientUnify Windows newlines—browser.
JSON replace first field
ClientSingle replacement per row—local.
JSON trim chars both field
ClientStrip a character set from ends—browser.
JSON first word field
ClientLeading token by whitespace—local.
JSON last word field
ClientTrailing token by whitespace—browser.
JSON sort by numeric asc
ClientOrder array rows by number field—local.
JSON sort by numeric desc
ClientOrder array rows by number field—browser.
JSON sort by string asc
ClientLocale-aware string sort ascending—local.
JSON sort by string desc
ClientLocale-aware string sort descending—browser.
JSON rolling min field
ClientWindowed minimum per row—local.
JSON rolling max field
ClientWindowed maximum per row—browser.
JSON cumulative min field
ClientExpanding minimum so far—local.
JSON cumulative max field
ClientExpanding maximum so far—browser.
JSON dense rank asc
Client1-based dense ranks low to high—local.
JSON dense rank desc
Client1-based dense ranks high to low—browser.
JSON union field values
ClientDistinct values across rows—local.
JSON sample first percent
ClientHead sample by percentage—browser.
JSON shallow clone rows
ClientCopy top-level fields per row—local.
JSON trim all string fields
ClientTrim every string property per row—browser.
JSON inline JSON parse field
ClientTry JSON.parse on string values—local.
JSON flatten field one level
ClientMerge nested object keys into row—browser.
JSON array length stats
ClientReturn row count summary—local.
JSON unique ratio stats
ClientDistinct count and ratio for a column—browser.
JSON URL port field
ClientAdd URL port column per row—local.
JSON URL pathname field
ClientAdd path segment column—browser.
JSON URL query field
ClientAdd query string column—local.
JSON strip HTML tags field
ClientStrip angle-bracket tags per row—browser.
JSON ROT13 field
ClientClassic ROT13 on string column—local.
JSON Base64 encode field
ClientUTF-8 Base64 encode per row—browser.
JSON Base64 decode field
ClientDecode Base64 text per row—local.
JSON URI encode field
ClientencodeURIComponent per row—browser.
JSON URI decode field
ClientdecodeURIComponent per row—local.
JSON pad right field
ClientPad on the right with char—browser.
JSON extract letters field
ClientLetters-only filter per row—local.
JSON digits only field
ClientDigit-only filter—browser.
JSON count words field
ClientWord count per row—local.
JSON count lines field
ClientLine count in multiline text—browser.
JSON is URL flag field
ClientBoolean URL shape check—local.
JSON is UUID flag field
ClientUUID v4-ish regex check—browser.
JSON normalize NFC field
ClientNormalize composed Unicode—local.
JSON HTML unescape field
ClientUnescape & < etc.—browser.
JSON sentence case field
ClientCapitalize first char only—local.
JSON djb2 hash field
ClientSync djb2 hash per row—browser.
JSON sample last percent
ClientTail sample by percentage—local.
JSON add index column
ClientIndex column on each row—browser.
JSON field stddev stats
ClientColumn stddev summary—local.
JSON field mean stats
ClientColumn average summary—browser.
JSON field distinct count
ClientUnique value count—local.
JSON export JSON lines
ClientOne JSON object per line—browser.
JSON rows to TSV
ClientHeader row plus TSV body—local.
JSON zip two fields
ClientPair two columns into nested object—browser.
JSON semi join rows
ClientLeft rows with matching right key—local.
JSON running sum field
ClientExpanding sum per row—browser.
JSON running average field
ClientRunning mean per row—local.
JSON percent change field
ClientStep percent change on numeric field—browser.
JSON row number field
ClientHuman-friendly row numbers—local.
JSON dedupe by field
ClientFirst row per distinct field value—browser.
JSON dedupe keep last
ClientLast row per distinct field value—local.
JSON coalesce fields row
ClientFirst non-empty of two fields—browser.
JSON split lines field
ClientNewline split to array—local.
JSON join lines field
ClientArray to multiline string—browser.
JSON trim prefix field
ClientStrip leading prefix if present—local.
JSON trim suffix field
ClientStrip trailing suffix if present—browser.
JSON URL fragment field
ClientAdd hash fragment column per row—local.
JSON URL origin field
ClientAdd scheme+host+port column—browser.
JSON Levenshtein two fields
ClientLevenshtein distance per row—local.
JSON Soundex field
ClientClassic Soundex per row—browser.
JSON Metaphone field
ClientMetaphone key per row—local.
JSON CRC32 field
ClientIEEE CRC32 hex per row—browser.
JSON truncate left field
ClientTail-preserving truncate—local.
JSON truncate right field
ClientHead-preserving truncate—browser.
JSON wrap text field
ClientSoft-wrap text column—local.
JSON escape regex field
ClientLiteral-safe regex strings—browser.
JSON repeat char field
ClientFixed fill pattern per row—local.
JSON insert at index field
ClientSplice text into column—browser.
JSON remove substring field
ClientGlobal substring removal—local.
JSON replace last occurrence field
ClientLast-only replace per row—browser.
JSON count char field
ClientChar tally column—local.
JSON index of substring field
ClientindexOf column per row—browser.
JSON last index of substring field
ClientlastIndexOf column—local.
JSON compare ignore case two fields
ClientBoolean equal-ignore-case—browser.
JSON pad both sides field
ClientSymmetric padding per row—local.
JSON remove whitespace field
ClientDelete spaces/tabs/newlines—browser.
JSON window sum field
ClientTrailing window sum per row—local.
JSON window average field
ClientTrailing window mean—browser.
JSON min-max normalize field
ClientUnit-scale column—browser.
JSON ntile bucket field
ClientQuantile bucket column—local.
JSON group sum by field
ClientAggregate sum table—browser.
JSON group count by field
ClientGroup cardinality table—local.
JSON group average by field
ClientGroup mean table—browser.
JSON filter field outside
ClientExclusive-outside filter—browser.
JSON rows to Markdown list
ClientMarkdown list export—local.
JSON merge row objects
ClientSingle object from array—local.
JSON invert numeric field
ClientUnary minus per row—browser.
JSON abs numeric field
ClientMath.abs per row—local.
JSON ceil numeric field
ClientMath.ceil per row—browser.
JSON floor numeric field
ClientMath.floor per row—local.
JSON round numeric field
ClientFixed decimal rounding—browser.
JSON log base 2 field
ClientMath.log2 per row—browser.
JSON except on key
ClientAnti-join style except on key column—local.
JSON field variance stats
ClientColumn variance summary—browser.
JSON geometric mean stats
ClientGeometric average summary—local.
JSON fill forward field
ClientCarry last non-null forward—browser.
JSON fill backward field
ClientCarry next non-null backward—local.
JSON diff from previous field
ClientSequential delta column—browser.
JSON percent change from previous
ClientSequential percent delta—local.
JSON rolling median field
ClientWindow median column—browser.
JSON rolling std dev field
ClientWindow volatility column—local.
JSON demean field
ClientCenter column around zero—browser.
JSON standardize column field
ClientStandardize using column mean/std—local.
JSON winsorize field
ClientWinsorize at tail percent—browser.
JSON rank percentile field
Client0–100 percentile rank—local.
JSON cumulative distinct field
ClientGrowing unique count—browser.
JSON median three fields
ClientRow-wise median of trio—local.
JSON top N rows by field
ClientHighest values subset—browser.
JSON bottom N rows by field
ClientLowest values subset—local.
JSON rows all fields present
ClientKeep rows where listed fields exist—browser.
JSON rows any field null
ClientFind incomplete rows—local.
JSON replace null with zero
ClientNull-as-zero for math—browser.
JSON replace zero with null
ClientZero-as-null for export—local.
JSON concat fields pipe
ClientPipe-separated composite—browser.
JSON concat fields colon
ClientColon-separated pair—local.
JSON parse boolean field
ClientString to bool column—browser.
JSON scale field to range
ClientMin-max rescale to new bounds—local.
JSON equal width bin field
ClientHistogram bucket column—browser.
JSON split field to array
ClientDelimiter split column—local.
JSON flat map field array
ClientOne row per array element—local.
JSON map field replace value
ClientValue substitution column—browser.
JSON field to fixed string
ClientFixed decimal string column—local.
JSON field outlier IQR flag
ClientTukey outlier boolean—browser.
JSON reverse field chars
ClientChar-reverse per row—local.
JSON duplicate field column
ClientDuplicate column under new key—browser.
JSON drop field if null
ClientOmit null keys per row—local.
JSON keep rows field not null
ClientKeep non-null rows—browser.
JSON field skewness stats
ClientDistribution asymmetry—local.
JSON field kurtosis stats
ClientTail weight summary—browser.
JSON exponential smoothing field
ClientEMA with alpha parameter—local.
JSON running non-null count
ClientRunning present-value count—browser.
JSON ratio to column max
ClientScale values to column maximum—local.
JSON ratio to column min
ClientScale values to column minimum—browser.
JSON normalize by row sum
ClientPart-to-whole per row—local.
JSON normalize by row max
ClientRow-wise max normalization—browser.
JSON linear null interpolate
ClientFill nulls by linear interpolation—local.
JSON clip field positive
ClientNegative values become zero—browser.
JSON sign of numeric field
Client−1, 0, or +1 per value—local.
JSON Jaccard two string fields
ClientToken Jaccard per row—browser.
JSON Hamming two strings
ClientCharacter mismatch count—local.
JSON absolute diff two fields
ClientScalar distance |a−b|—browser.
JSON cosine similarity two fields
ClientDirectional similarity—local.
JSON Pearson correlation stats
ClientColumn correlation summary—browser.
JSON row sum numeric fields
ClientRow total column—local.
JSON row product numeric fields
ClientRow product column—browser.
JSON row min numeric fields
ClientRow-wise min—local.
JSON row max numeric fields
ClientRow-wise max—browser.
JSON blend two fields weighted
ClientLinear mix with weight—browser.
JSON truncate array field
ClientKeep first N array items—local.
JSON count array items field
ClientArray item count per row—browser.
JSON sort array field asc
ClientSort array values per row—local.
JSON reverse array field
ClientReverse array per row—browser.
JSON unique array field items
ClientUnique array elements—local.
JSON join array with space
ClientSpace-joined array text—browser.
JSON extract date year field
ClientYear column from ISO dates—local.
JSON extract date month field
ClientMonth number 1–12—browser.
JSON extract date day field
ClientDay-of-month column—local.
JSON is weekend date field
ClientSaturday/Sunday boolean—browser.
JSON days between date fields
ClientElapsed days column—local.
JSON hours between date fields
ClientElapsed hours column—browser.
JSON format date ISO field
ClientISO-8601 text column—local.
JSON parse ISO date field
ClientParse and reformat dates—browser.
JSON prefix all string fields
ClientBulk string prefix per row—local.
JSON keys sorted objects
ClientStable key order per row—browser.
JSON values only rows
ClientValues array per row—local.
JSON compact number format field
Client1.2K style numbers—browser.
JSON scientific notation field
ClientExponential format column—local.
JSON is empty array field
ClientBoolean if array length zero—browser.
JSON join array comma
ClientComma list from array—local.
JSON flat map array field
ClientUnnest nested lists—browser.
JSON minutes between dates
ClientElapsed minutes column—local.
JSON seconds between dates
ClientElapsed seconds column—browser.
JSON is weekday date field
ClientMon–Fri boolean—local.
JSON extract date quarter
ClientQ1–Q4 column—browser.
JSON extract date week
ClientApproximate UTC week—local.
JSON extract date hour
Client0–23 hour column—browser.
JSON extract date minute
Client0–59 minute column—local.
JSON sort array field desc
ClientReverse lex sort per row—browser.
JSON sum array numeric field
ClientArray total column—local.
JSON min array numeric field
ClientArray min column—browser.
JSON max array numeric field
ClientArray max column—local.
JSON average array numeric field
ClientArray average column—browser.
JSON split string to array
ClientTokenize text column—local.
JSON array contains item
ClientContains check per row—browser.
JSON hypotenuse two fields
Client√(a²+b²) per row—local.
JSON ratio two fields
Clienta÷b with zero guard—browser.
JSON power two fields
Clienta^b per row—local.
JSON percent of column sum
ClientPercent of sum column—browser.
JSON suffix all string fields
ClientBulk suffix per row—local.
JSON extract numbers from string
ClientNumeric tokens array—browser.
JSON merge two fields string
ClientConcatenate with separator—local.
JSON conditionally set field
ClientTernary constant per row—browser.
JSON field equals constant
ClientBoolean match column—local.
JSON field greater than constant
ClientThreshold exceed boolean—browser.
JSON field less than constant
ClientBelow-threshold boolean—local.
JSON field between constants
ClientMin–max window boolean—browser.
JSON round to nearest step
ClientSnap to increment—local.
JSON ceil to multiple
ClientRound up to step—browser.
JSON floor to multiple
ClientRound down to step—local.
JSON cumulative sum square
ClientΣx² running total—browser.
JSON extract hostname URL
ClientHost column from URLs—local.
JSON extract path URL
ClientPath column from URLs—browser.
JSON is valid URL field
ClientParseable URL boolean—local.
JSON is valid email field
ClientSimple email regex check—browser.
JSON filter array gt value
ClientNumeric array filter—local.
JSON double array numerics
ClientScale list values—browser.
JSON string length field
ClientString length per row—local.
JSON remove empty strings
ClientOmit blank strings per row—browser.
JSON milliseconds between dates
ClientElapsed ms column—local.
JSON weeks between dates
ClientElapsed weeks column—browser.
JSON extract date day of year
Client1–366 DOY column—local.
JSON extract weekday name
ClientMonday–Sunday label—browser.
JSON is leap year date field
ClientGregorian leap boolean—local.
JSON array first item field
ClientHead-of-list extract per row—browser.
JSON array last item field
ClientTail-of-list extract per row—local.
JSON array slice field
Clientstart/end index slice—browser.
JSON array append item field
ClientPush value onto list—local.
JSON array prepend item field
ClientUnshift value onto list—browser.
JSON string contains substring
ClientContains check per row—local.
JSON string starts with prefix
ClientstartsWith boolean—browser.
JSON string ends with suffix
ClientendsWith boolean—local.
JSON replace first substring
ClientSingle replace per row—browser.
JSON pad string left field
ClientpadStart per row—local.
JSON pad string right field
ClientpadEnd per row—browser.
JSON field absolute value
ClientMath.abs per row—local.
JSON field reciprocal value
Client1/x column with zero skip—browser.
JSON field natural log
Clientln(x) column—local.
JSON column variance stats
ClientColumn variance object—browser.
JSON column stddev stats
ClientColumn stddev object—local.
JSON divide field by constant
ClientScalar division per row—browser.
JSON subtract constant from field
ClientOffset numeric column—local.
JSON field max with constant
ClientClamp floor per row—browser.
JSON field min with constant
ClientClamp ceiling per row—local.
JSON copy field if null from
ClientFill null dest from source—browser.
JSON to percent display field
ClientFormat as percent text—local.
JSON parse percent string field
ClientParse % strings to decimal—browser.
JSON pick numeric fields only
ClientStrip non-number keys—local.
JSON pick string fields only
ClientStrip non-string keys—browser.
JSON rank unique asc field
ClientCompetition rank up—local.
JSON rank unique desc field
ClientCompetition rank down—browser.
JSON normalize L2 row fields
ClientUnit vector per row—local.
JSON dot product two fields
Clienta·b per row—browser.
JSON truncate string middle field
ClientShorten long strings—local.
JSON remove prefix if present
ClientConditional prefix strip—browser.
JSON remove suffix if present
ClientConditional suffix strip—local.
JSON keys count field
ClientNested object key count—browser.
JSON field square value
Clientx² column per row—local.
JSON months between dates
ClientApproximate month span—local.
JSON add days to date field
ClientAdd days and emit ISO—browser.
JSON add hours to date field
ClientAdd hours and emit ISO—local.
JSON add minutes to date field
ClientAdd minutes and emit ISO—browser.
JSON array compact field
ClientDrop null/undefined items—local.
JSON flat array one level
Clientflat(1) per row—browser.
JSON string trim field
ClientTrim strings per row—local.
JSON string replace all field
ClientGlobal replace per row—browser.
JSON count regex matches field
ClientPattern match count—local.
JSON match regex field
ClientBoolean regex test—browser.
JSON field is null flag
ClientMissing value boolean—local.
JSON field is not null flag
ClientNon-null boolean—browser.
JSON field type name
ClientType label per row—local.
JSON field to string field
ClientString cast column—browser.
JSON field to number field
ClientNumeric cast column—local.
JSON column min stats
ClientColumn min object—browser.
JSON column max stats
ClientColumn max object—local.
JSON column sum stats
ClientColumn total object—browser.
JSON column mean stats
ClientColumn average object—local.
JSON column median stats
ClientColumn median object—browser.
JSON multiply field by constant
ClientScalar multiply per row—local.
JSON field ceil value
ClientMath.ceil per row—browser.
JSON field floor value
ClientMath.floor per row—local.
JSON field round value
ClientMath.round per row—browser.
JSON compare fields less than
ClientRow-wise less-than—local.
JSON compare fields greater than
ClientRow-wise greater-than—browser.
JSON compare fields equal
ClientRow-wise equality—local.
JSON swap field values
ClientExchange columns per row—browser.
JSON explode object field
ClientUnnest object keys—local.
JSON filter rows field null
ClientNull-only subset—browser.
JSON filter rows field not null
ClientNon-null subset—local.
JSON take first N rows
ClientKeep first rows—browser.
JSON drop last N rows
ClientTrim tail rows—local.
JSON drop first N rows
ClientTrim head rows—browser.
JSON slice string field
ClientSlice string per row—local.
JSON repeat string field
ClientString repeat per row—browser.
JSON field is array flag
ClientArray check boolean—local.
JSON field is object flag
ClientObject check boolean—browser.
JSON field is boolean flag
ClientBoolean check column—local.
JSON subtract days from date field
ClientSubtract days and emit ISO—local.
JSON subtract hours from date field
ClientSubtract hours and emit ISO—browser.
JSON subtract minutes from date field
ClientSubtract minutes and emit ISO—local.
JSON field sign value
ClientMath.sign per row—browser.
JSON field square root value
ClientSqrt for non-negative values—local.
JSON field cube value
Clientx³ column per row—browser.
JSON field negate value
ClientFlip sign in place—local.
JSON field modulo constant
ClientRemainder column—browser.
JSON string reverse field
ClientReverse characters per row—local.
JSON array reverse field
ClientReverse list per row—browser.
JSON array unique field
ClientUnique items per row—local.
JSON field is nonempty string flag
ClientNon-empty text boolean—browser.
JSON prefix field with text
ClientPrefix strings per row—local.
JSON suffix field with text
ClientSuffix strings per row—browser.
JSON column distinct count stats
ClientDistinct count summary—local.
JSON column null count stats
ClientNull tally object—browser.
JSON column non-null count stats
ClientNon-null tally object—local.
JSON min of two fields on rows
ClientMin of two columns—browser.
JSON max of two fields on rows
ClientMax of two columns—local.
JSON values join comma field
ClientComma-join nested object values—browser.
JSON divide field by field
ClientRow-wise division—local.
JSON subtract field from field
ClientRow-wise difference—browser.
JSON compare fields not equal
ClientRow-wise not-equal boolean—local.
JSON filter rows empty string field
ClientEmpty-string subset—browser.
JSON filter rows nonempty string field
ClientNonempty text subset—local.
JSON shuffle rows
ClientRandomize row order—browser.
JSON field trunc value
ClientMath.trunc per row—local.
JSON field is even flag
ClientEven check boolean—browser.
JSON field is odd flag
ClientOdd check boolean—local.
JSON multiply field by field
ClientRow-wise product—browser.
JSON field percent of field
Clienta/b×100 per row—local.
JSON field ratio field
Clienta/b per row—browser.
JSON field log10 value
Clientlog10 column—local.
JSON field exp value
Cliente^x column per row—browser.
JSON array sort field
ClientSort list per row—local.
JSON string split field
ClientExtract split segment—browser.
JSON field char count no spaces
ClientLength ignoring whitespace—local.
JSON days between today field
ClientElapsed days to today—browser.
JSON hours between today field
ClientElapsed hours to now—local.
JSON → CUE
ClientCUE definitions from sample JSON—`#Name` structs, lists as `[...T]`, refine with constraints locally.
Nearby workflows on Toolcore
- Which JSON tool do I need? (article) — when the hub grid is large and you want a task-first map with links.
- JSON formatter — when you need pretty-print, minify, or validate before any other JSON tool.
- Compare JSON — for structural diffs after both sides parse.
- YAML ↔ JSON — when config authors edit YAML but APIs expect JSON.
- JSON Schema validate — once syntax is valid but contract rules still matter.
Common use cases
- Start from the formatter when you inherit minified JSON or copy-paste from logs and need readable structure.
- Use compare or structural tools when reviewing config or API diffs—not just line-based text diff.
- Jump to schema validation, JSONPath, or codegen once the payload shape is clear; each subtool focuses on one job.
Common mistakes to avoid
Pasting production secrets into any online tab
Processing is local here, but bad habits travel. Prefer redacted samples for public or shared machines.
Expecting codegen to match every house style
Generators infer types from sample JSON. Adjust names, nullability, and annotations in your project after export.
FAQ
Is my JSON sent to Toolcore?
No. These tools execute in your browser; payloads are not uploaded for transformation.
Which tool should I open first?
There is no single entry: pick the card that matches your task (format, validate, convert, query, or generate code). The collapsible notes above the grid explain hub-wide behavior.
Popular searches in this area
Phrases people search for that match this tool. See the full long-tail keyword index.
- json formatter online
- free json beautifier
- json minifier online
- json validator online
- json pretty print
- format json without upload
More tools
Explore other utilities on Toolcore—useful next steps outside this hub.
Encoding tools
ClientHub index: Base64 & URL, Base64url, Base32, Crockford, LEB128, ASCII85, Z85, Base58, base-36, bencode, Morse, quoted-printable, URI, Punycode/IDN, Unicode escapes, data URLs, MIME, hex, HTML entities, JWT, JSON helpers, crypto.
Regex generator & tester
ClientPresets (US/NANP & E.164 phones, email, URL), JS snippet, local test.
TOML ↔ JSON
ClientTOML to JSON and JSON to TOML online—format, validate, convert locally.
Plain text diff
ClientCompare two text drafts side by side—unified view, sample pre-filled, client-side.