Data
Convert, validate, query, and transform data: JSON, YAML, TOML, XML, CSV, MessagePack, CBOR, Parquet, plus SQLite (WASM) — all in your browser.
Cleaner
Clean datasets: remove duplicates, empty rows/columns, nulls; trim, fill, and replace values.
Fill Empty Values Online
Clean Fill Empty Values instantly and for free in your browser. Fill empty/null values with a default value you choose.
Remove Duplicate Rows Online
Clean Remove Duplicate Rows instantly and for free in your browser. Remove duplicate rows from a JSON array, keeping only unique ones.
Remove Empty Columns Online
Clean Remove Empty Columns instantly and for free in your browser. Remove columns whose values are all empty from a JSON array.
Remove Empty Rows Online
Clean Remove Empty Rows instantly and for free in your browser. Remove empty rows (all values blank/null) from a JSON array.
Remove Null Values Online
Clean Remove Null Values instantly and for free in your browser. Remove null-valued fields from objects in JSON.
Replace Values Online
Clean Replace Values instantly and for free in your browser. Replace every occurrence of a value with another across the JSON.
Trim All Values Online
Clean Trim All Values instantly and for free in your browser. Trim leading/trailing whitespace from all string values in JSON.
Converter
Convert between data formats: JSON, YAML, TOML, XML, CSV, TSV, and Markdown tables.
CSV ⇄ TSV Online
Convert CSV ⇄ TSV instantly and for free in your browser. Two-way conversion between CSV (comma) and TSV (tab).
Excel ⇄ CSV Online
Convert Excel ⇄ CSV instantly and for free in your browser. Convert Excel (.xlsx) files to CSV and back, in the browser.
JSON ⇄ CSV Online
Convert JSON ⇄ CSV instantly and for free in your browser. Two-way conversion between JSON (array of objects) and CSV.
JSON ⇄ TOML Online
Convert JSON ⇄ TOML instantly and for free in your browser. Two-way conversion between JSON and TOML.
JSON ⇄ TSV Online
Convert JSON ⇄ TSV instantly and for free in your browser. Two-way conversion between JSON and TSV (tab-separated).
JSON ⇄ XML Online
Convert JSON ⇄ XML instantly and for free in your browser. Two-way conversion between JSON and XML.
JSON ⇄ YAML Online
Convert JSON ⇄ YAML instantly and for free in your browser. Two-way conversion between JSON and YAML.
Markdown Table ⇄ CSV Online
Convert Markdown Table ⇄ CSV instantly and for free in your browser. Two-way conversion between a Markdown table and CSV.
YAML ⇄ TOML Online
Convert YAML ⇄ TOML instantly and for free in your browser. Two-way conversion between YAML and TOML.
Database (SQLite)
Run SQL in the browser with SQLite (WASM): query, browse tables, import CSV, export JSON.
SQL Query Runner Online
Run SQL Query Runner instantly and for free in your browser. Run SQL on a SQLite database inside your browser (no server).
SQLite Browser Online
Browse SQLite Browser instantly and for free in your browser. Build a SQLite database and browse its tables and schemas.
SQLite Export JSON Online
Export SQLite Export JSON instantly and for free in your browser. Build a SQLite table then export its contents as JSON.
SQLite Import CSV Online
Import SQLite Import CSV instantly and for free in your browser. Load CSV into a SQLite table in the browser, ready to query.
SQLite Query Runner Online
Run SQLite Query Runner instantly and for free in your browser. Execute SQLite queries and view results, entirely in the browser.
Query
Query data: JSONPath and JMESPath for JSON, XPath for XML.
JMESPath Query Online
Query JMESPath Query instantly and for free in your browser. Query and transform JSON with JMESPath (used by the AWS CLI).
JSONPath Query Online
Query JSONPath Query instantly and for free in your browser. Extract data from JSON with JSONPath expressions ($.store.book[*]).
XPath Query Online
Query XPath Query instantly and for free in your browser. Select nodes from an XML document with XPath expressions.
Schema
Generate JSON Schema from sample data, and validate JSON against a schema.
JSON Schema Generator Online
Generate JSON Schema Generator instantly and for free in your browser. Build a JSON Schema (draft-07) automatically from a JSON sample.
JSON Schema Validator Online
Validate JSON Schema Validator instantly and for free in your browser. Validate JSON data against a JSON Schema (ajv).
Serialization
Parse & serialize YAML, TOML, CSV, plus the binary formats MessagePack and CBOR.
CBOR Online
Serialize CBOR instantly and for free in your browser. Encode JSON to CBOR (binary) and decode back — hex & Base64.
CSV Parser Online
Serialize CSV Parser instantly and for free in your browser. Parse CSV into JSON (array of objects), and back.
MessagePack Online
Serialize MessagePack instantly and for free in your browser. Encode JSON to MessagePack (binary) and decode back — hex & Base64.
TOML Parser & Serializer Online
Serialize TOML Parser & Serializer instantly and for free in your browser. Parse TOML into JSON, and serialize JSON into TOML.
YAML Parser & Serializer Online
Serialize YAML Parser & Serializer instantly and for free in your browser. Parse YAML into JSON, and serialize JSON into YAML.
Transformer
Reshape data: flatten/unflatten, rename keys, sort, filter, select, group by, merge.
Filter Rows Online
Transform Filter Rows instantly and for free in your browser. Filter JSON array rows by a column condition (=, ≠, >, contains…).
Flatten JSON Online
Transform Flatten JSON instantly and for free in your browser. Flatten nested JSON into a single-level object with dotted-path keys.
Group By Online
Transform Group By instantly and for free in your browser. Group JSON array rows by the value of a column.
Merge JSON Online
Transform Merge JSON instantly and for free in your browser. Deep-merge two JSON documents into one.
Rename JSON Keys Online
Transform Rename JSON Keys instantly and for free in your browser. Rename a key throughout an entire JSON structure at once.
Select Columns Online
Transform Select Columns instantly and for free in your browser. Keep only specific columns/fields from a JSON array of objects.
Sort Dataset Online
Transform Sort Dataset instantly and for free in your browser. Sort a JSON array by a column/key, ascending or descending.
Unflatten JSON Online
Transform Unflatten JSON instantly and for free in your browser. Turn dotted-path flat JSON back into a nested object.
Tree
Interactive JSON tree viewer — explore collapsible JSON structure.
Validator
Validate the syntax of JSON, YAML, TOML, CSV, and XML.
CSV Validator Online
Validate CSV Validator instantly and for free in your browser. Check whether your CSV text parses without errors.
JSON Validator Online
Validate JSON Validator instantly and for free in your browser. Check whether your JSON text is valid and find syntax errors.
TOML Validator Online
Validate TOML Validator instantly and for free in your browser. Check whether your TOML text is syntactically valid.
XML Validator Online
Validate XML Validator instantly and for free in your browser. Check whether your XML text is well-formed (valid syntax).
YAML Validator Online
Validate YAML Validator instantly and for free in your browser. Check whether your YAML text is valid and find indentation errors.
Viewer
View binary data files: an Apache Parquet viewer (in-browser, no upload).