JSON tools
Pretty-print or minify JSON, validate payloads, and diff changes—then go deeper with string helpers, compare, interop (XML, YAML, TOML, CSV, NDJSON), sort keys, schema validation, pointer/patch, JSONPath, flatten, properties, table editing, big-number parsing, Base64 previews, and codegen to several languages—all run in your tab; generators infer from one sample (first array element for arrays).
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
Cards follow the same order as the hub index—start from format and compare, then open interop or codegen tools as needed.
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 → 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.