Data
JSON, CSV, YAML — format, validate, convert · 98 tools
Render CSV as a bordered ASCII or Unicode box-drawing table for READMEs, code comments, and terminals.
Prepend or append a sequential ID / row-number column to a CSV with a configurable start, step, padding, and prefix/suffix.
Add a computed column to a CSV using an arithmetic expression over existing numeric columns, evaluated safely without eval.
Keep, drop, or reorder CSV columns by header name or index.
Compute per-column statistics (type, count, nulls, distinct, min/max, mean, median, std-dev) for every column in a CSV.
Infers each CSV column's data type (integer, float, boolean, date, string) from its values.
Remove duplicate rows from CSV, either fully identical or matching on selected key columns.
Re-delimit tabular data between comma, tab, semicolon, or pipe while preserving quoting.
Fill empty cells in a CSV by forward-fill, back-fill, a constant value, or per-column mean/median.
Group CSV rows by a column and compute count, sum, avg, min, and max on another.
Rename, reorder, and apply naming-convention transforms to CSV column headers.
Concatenate two or more CSV columns into a single column using a chosen separator and template.
Build a spreadsheet-style pivot table from CSV by choosing row, column, and value fields with an aggregation.
Keep or drop CSV rows that match conditions on chosen columns (equals, contains, regex, numeric ranges).
Extract the first N, last N, every Nth, or a random sample of rows from a CSV.
Sort CSV rows by a chosen column with numeric/text mode and ascending or descending order.
Split one CSV column into multiple columns on a delimiter, regex, or fixed character position.
Convert CSV into fixed-width / column-aligned text with per-column widths and alignment.
Convert CSV into a clean HTML table element with a header row, ready to paste into a page.
Convert CSV (with header row) into a JSON array of objects.
Convert CSV with a header row into newline-delimited JSON (one JSON object per line).
Generate SQL INSERT statements from CSV with a configurable table name and quoting.
Swap rows and columns of a CSV so the first column becomes the header row and vice versa.
Paste CSV and view it as a sortable, searchable table.
Reorders, drops, or duplicates columns in CSV/TSV data by index or header name.
Parse fixed-width / column-aligned text into CSV by defining field widths or cut positions.
Extract one or all <table> elements from pasted HTML into CSV.
Convert an HTML <table> into a JSON array of objects keyed by the header row.
Split a large JSON array into fixed-size chunks of smaller arrays.
Pluck one or more fields from each object in a JSON array.
Remove duplicate elements from a JSON array, optionally by key.
Converts a JSON array of objects to CSV, exploding nested objects into dotted columns.
Convert a JSON array of objects into a keyed lookup object using one field as the key.
Index a JSON array of objects into a keyed object/map.
Recursively strip null, empty, or falsy values from JSON.
Compare two JSON documents (normalized & sorted) and see the changes.
Get, set, or delete a value at a dot/bracket path in JSON.
Flatten nested JSON into dot-notation keys or rebuild nested objects from flattened keys.
Pretty-print, minify, and validate JSON with configurable indentation.
Recursively convert all JSON object keys to a chosen case.
List every unique key path in a JSON document, optionally with the inferred type of each.
Derive a unified CSV/flat header row from JSON array of objects.
Validates each line of an NDJSON/JSONL file as standalone JSON and reports line-level errors.
Deep-merge two JSON objects, with options for how arrays and conflicting keys are combined.
Apply an RFC 7386 JSON Merge Patch to a document.
Strip whitespace from JSON to produce the smallest valid output.
Flattens deeply nested JSON arrays into a single flat array to a chosen depth.
Apply an RFC 6902 JSON Patch to a JSON document.
Generate an RFC 6902 JSON Patch between two JSON documents.
Pull values out of JSON with a dot/bracket path like data.items[0].name.
Resolve an RFC 6901 JSON Pointer against a JSON document.
Query JSON with a JMESPath-style path and filter expression.
Fix broken JSON with single quotes, trailing commas, unquoted keys, and comments, then output valid JSON.
Infer a JSON Schema (draft-07) from a sample JSON document with types and required fields.
Generate a sample JSON instance that satisfies a JSON Schema.
Recursively sort all object keys in a JSON document alphabetically.
Escape text into a JSON string literal, or unescape one back to raw text.
Turn raw text into an escaped JSON string literal, or parse a JSON string back to its raw value.
Summarize a JSON document's structure, depth, and type counts.
Flatten a JSON object into dotenv KEY=VALUE lines.
Generate C# classes with System.Text.Json attributes from JSON.
Convert a JSON array of objects into CSV, with a chosen delimiter.
Generate Dart classes with fromJson/toJson from a JSON sample.
Generate GraphQL SDL type definitions from a JSON sample.
Convert a JSON object to HCL2 (Terraform-style) syntax.
Generate JSDoc @typedef comments from a JSON sample.
Generate Kotlin data classes with kotlinx.serialization from JSON.
Render an array of JSON objects as a GitHub-flavored Markdown table.
Generate a Mongoose schema definition from a JSON sample.
Convert between a JSON array and newline-delimited JSON (NDJSON / JSON Lines).
Generate a proto3 .proto message definition from a JSON sample.
Generate Pydantic v2 BaseModel classes from a JSON sample.
Generate Python @dataclass definitions from a JSON sample.
Convert a flat JSON object into a URL query string, with array and encoding options.
Generate Rust structs with serde derives from a JSON sample.
Generate Swift structs conforming to Codable from a JSON sample.
Convert JSON into TOML config format with tables, arrays, and typed scalars.
Infer TypeScript interfaces from a JSON sample.
Generate a Zod validation schema from a JSON sample.
Explore JSON as a collapsible tree with type badges and value counts for large documents.
Validate JSON and pinpoint the exact line, column, and reason for any syntax error.
Strip comments and trailing commas from JSONC or JSON5 to produce strict, valid JSON.
Remove duplicate JSON objects from JSON Lines input, optionally keyed by selected fields.
Splits Markdown into its YAML/TOML front matter and body, and parses the front matter to JSON.
Reformat a messy Markdown table into clean column-aligned pipes with chosen alignment.
Convert a Markdown table into a JSON array of objects keyed by the header row.
Select, drop, or rename fields across NDJSON records.
Convert newline-delimited JSON objects into a CSV table with a unified header.
Convert NDJSON / JSON Lines to a single JSON array and back.
Flatten an array of nested JSON objects into CSV using dot-path column headers.
Generate a CREATE TABLE statement (with inferred column types) from a CSV header and sample rows.
Generate a CREATE TABLE statement by inferring columns and types from a JSON array of objects.
Format and indent SQL queries with keyword casing.
Generate INSERT statements from a JSON array of objects with type-aware value quoting.
Visually build a SELECT query with columns, WHERE conditions, ORDER BY, and LIMIT, then copy the SQL.
Build a safe parameterized UPDATE statement from column=value pairs and WHERE conditions.
Convert tab-separated values into a GitHub-flavored Markdown table.
Resolve YAML anchors and aliases by inlining their referenced values.