Data Tools

Format, minify, sort, and validate JSON in your browser. Parsing errors include location details, and your data never leaves the page.

Validate JSON syntax, locate parsing errors, inspect structure, and try safe repairs locally in your browser.

Convert JSON to YAML in your browser with 2- or 4-space indentation. Invalid input shows an error, and conversion stays on the page—useful for config migration, API samples, and more readable archives.

Convert YAML to formatted JSON in your browser with two-space indentation by default. Parse failures show the reason, and conversion stays local—useful for config debugging and API handoffs.

Format or minify XML in your browser with 2/4-space or Tab indent, optional same-line attributes, and element counts. Invalid structure shows an error—useful for API debugging and config review.

Extract values from nested JSON with dot paths and array indexes. Queries run locally and results are ready to copy.

Convert CSV tables to JSON arrays in your browser. Supports comma, tab, semicolon, or pipe separators and optional header rows. Processing stays local—useful for exports, API samples, and light imports.

Convert an array of JSON objects to CSV with selectable delimiters and optional nested-object flattening. Everything runs locally.

Compare two JSON documents recursively and list added, removed, and changed paths. Processing stays in your browser.

Minify formatted JSON into a compact single line in your browser. Syntax is checked before output—useful for smaller configs, API payloads, and local storage.

Convert XML to JSON in your browser. Attributes map under @ and text under #text where needed. Invalid XML shows an error—useful for API bridging and config inspection.

Convert JSON to XML in your browser. The root object should have a single key as the XML root. @ attributes and #text are supported—useful for generating simple XML payloads locally.

Extract selected CSV columns by header name or zero-based index and export as CSV, JSON, or a plain list. Processing stays in your browser—useful for trimming wide exports.

Deduplicate CSV rows by whole-line comparison or selected key columns. Runs locally in your browser—useful for cleaning exports and mailing lists.

Minify XML in your browser, optionally stripping comments, and show size savings. Processing stays local—useful for smaller payloads and compact samples.

Convert tab-separated data to comma-separated CSV. Fields containing commas or quotes are escaped automatically in your browser.

Convert comma-separated values to tab-separated values in your browser, preserving quoted fields. Useful for spreadsheet paste and tooling that expects TSV.

Solve common percentage problems in your browser: X as a percent of Y, Y times X%, change between two values, and increase/decrease by a percent. Copy individual results.

Convert file sizes between B, KB, MB, GB, and more using 1024 (binary) or 1000 (decimal) bases. Runs locally—useful for storage planning and ticket estimates.

Pull dates and timestamps from mixed notes, contracts, or logs—including YYYY-MM-DD and Chinese year-month-day forms. Optionally dedupe and sort. Processing stays in your browser.

Extract currency amounts from quotes and finance notes, group by currency, and optionally sum roughly without FX conversion. Runs locally in your browser.

Reorder CSV columns by index or header name, optionally sort ascending by the first output column, and copy the result. Processing stays in your browser.

Split large CSV or line lists into page-sized chunks, optionally repeating a header on every page. Preview and copy the current page locally in your browser.

Mask sensitive JSON fields in your browser by matching key names such as password, token, or phone. Nested objects and arrays are walked recursively, and values are replaced with mask characters so you can share debug payloads more safely.

Convert length, mass, volume, and area units in your browser across common metric and imperial measures. Swap input and output, tune decimals, and list every unit in the active category—handy for shopping sizes and everyday unit checks.

Convert among Celsius, Fahrenheit, and Kelvin in your browser. Change any scale and the other two update together. Adjust precision and copy results for weather checks, device ranges, and lab temperature work.

Convert degrees, radians, gradians, and turns in your browser with linked inputs—useful for CSS rotate(), Canvas, and Three.js work where Math.PI conversions are easy to get wrong. Results stay on the page.

Compute and lock an aspect ratio in your browser. Derive a ratio from width and height, or change one side while the other stays proportional. Includes common presets and a preview for cropping, video frames, and responsive layouts.

Calculate profit, margin, and markup from cost and selling price in your browser. See why doubling cost for the selling price is not a 100% margin, compare breakeven price, and review a clear profit-versus-cost breakdown.

Convert RMB numeric amounts into Chinese capital letters for finance forms. Handles consecutive zeros, jiao/fen, and the trailing 整 (zheng) rule, accepts thousand separators and negatives, and supports up to 13 integer digits—useful for contracts, invoices, and expense claims. The capitalized output stays in Chinese by design.

Convert CREATE TABLE DDL into Prisma models in your browser. Common column types plus primary key, autoincrement, and unique markers are recognized. Processing stays local—useful for bootstrapping a schema from an existing database.

Infer a Zod schema from sample JSON in your browser and emit TypeScript validation code. Nested objects and arrays are supported, with optional strict mode and z.infer type export—useful for API validation work.

Validate JSON instances against JSON Schema Draft-07 in your browser with Ajv. Check required fields, types, and bounds, then review a clear validation result—useful for API debugging and sample verification.

Turn headered CSV into INSERT statements in your browser. Set table name, quote style, empty-value handling, and batch size. Conversion stays local—useful for seed data and bulk-import prep.

Convert between Java Properties and YAML in your browser. Expand dotted keys such as spring.jpa.x=1 into nested YAML, or flatten YAML back to properties—useful for Spring config migrations.

Convert .env text to JSON in your browser. Comment lines are ignored. Optionally nest keys on underscores and coerce numbers or booleans—useful for frontend config, Docker, and CI key maps.

Run AND, OR, XOR, left shift, and right shift on two operands in your browser. Decimal, hex, and binary inputs stay linked, and results show in all three bases—useful for protocol debugging and mask checks.

Convert JSON to TOML in your browser. Invalid JSON shows an error, and conversion stays on the page—useful for Cargo, pyproject, and other TOML-first config workflows.

Convert TOML to formatted JSON in your browser. Parse failures show the reason, and conversion stays local—useful for debugging config and handing data to JSON-only tools.

Validate YAML syntax in your browser, inspect structure details such as indentation and node counts, and review parse errors with location hints. Processing stays local—useful for config and CI file checks.

Normalize spacing, blank lines, comments, and sections in TOML without changing key or value semantics. Processing runs locally.