所有 JSON 工具
格式化器、转换器和验证器集于一身。
格式化和验证
- JSON Formatter Pretty print JSON with two spaces, four spaces or tabs, and see exactly which line broke it.
- JSON Validator Check JSON against the specification and get the exact line and column of anything wrong.
- JSON Minifier Strip every optional byte of whitespace and see exactly how much smaller the result is.
- JSON 修复 Fix trailing commas, unquoted keys, single quotes and comments, and see exactly what changed.
查看和探索
- JSON Viewer Explore a document as a collapsible tree, with the path and the source line of every value.
- JSON Diff Compare two documents by value and get the exact path of everything that differs.
- JSONPath Tester Run a JSONPath query against your document and see every match with its own path.
- JSON Pointer Evaluator Resolve an RFC 6901 pointer against your document, with a real explanation when it does not resolve.
- JSON Search Find a key or a value anywhere in a document by exact text, fuzzy match or regular expression, and replace what you find inside string values.
- Query Workbench Run a JSONPath or JMESPath query against your JSON and see the result, both languages in one place.
转换
- JSON to CSV Converter Turn an array of objects into a spreadsheet, and a CSV export back into JSON.
- JSON to NDJSON Converter Split an array into one JSON value per line, or collect those lines back into an array.
- JSON to Base64 Converter Encode a document as Base64 text, or decode Base64 back into the JSON it holds.
- JWT Decoder Decode a JSON Web Token's header and payload, read its standard claims, and see at a glance whether it has expired. Decoding only, never verification.
- JSON to YAML Converter Turn JSON into indented YAML and read YAML back into JSON, in the browser.
- JSON to JavaScript Converter Turn JSON into a JavaScript object literal and read a literal back into JSON, in the browser.
- JSON to XML Converter Convert JSON to XML and XML back to JSON, with the mapping stated on the page.
- JSON to Markdown Converter Turn JSON into a Markdown table, a nested bullet list, a fenced code block, or a short field summary.
- JSON to SQL Converter Turn JSON into a CREATE TABLE and INSERT statements for PostgreSQL, MySQL, SQLite or SQL Server.
- JSON to Excel Converter Turn JSON into a real .xlsx workbook, with flattened columns, multiple sheets and a bold header row.
转义和编码
转换
- JSON Key Sorter Put every object key in order, at every level, without touching the values.
- JSON Flattener Turn a nested document into one level of paths and values, and build it back.
- JSON Patch Playground Apply an RFC 6902 patch, write one from two documents, or reverse one to undo a change.
- JSON Merge Combine two documents into one, choose how conflicts and arrays are handled, or generate an RFC 7386 merge patch.
- JSON Cleaner Strip nulls and empty containers, trim strings, deduplicate arrays, rename or redact keys, and keep or delete whole paths, all from one page.
- JSON Redact Find what looks like an email, an IP address, a phone number, an API key or a name, and replace each with a fixed placeholder, live as you type.
Schema 和代码生成
- JSON Schema Generator Infer a JSON Schema from a sample document, with optional keys reported as optional.
- JSON to TypeScript Turn a sample document into TypeScript interfaces, with optional keys marked optional.
- JSON Schema Validator Check a JSON document against a JSON Schema and see each problem with the keyword and path that caused it.
- JSON Schema Diff Compare two JSON Schemas and see exactly what changed, with every change marked breaking or not.
- API Response Analyzer Paste an API response and see suspicious nulls, inconsistent types, duplicate keys and large sections, plus a candidate schema, TypeScript types and JSONPath examples.
- OpenAPI Helpers Write a document as an OpenAPI schema, build an example from a schema, or check an example against one, all in OpenAPI 3.0 or 3.1.
格式化和验证
- JSON Formatter Pretty print JSON with two spaces, four spaces or tabs, and see exactly which line broke it.
- JSON Validator Check JSON against the specification and get the exact line and column of anything wrong.
- JSON Minifier Strip every optional byte of whitespace and see exactly how much smaller the result is.
- JSON 修复 Fix trailing commas, unquoted keys, single quotes and comments, and see exactly what changed.
查看和探索
- JSON Viewer Explore a document as a collapsible tree, with the path and the source line of every value.
- JSON Diff Compare two documents by value and get the exact path of everything that differs.
- JSONPath Tester Run a JSONPath query against your document and see every match with its own path.
- JSON Pointer Evaluator Resolve an RFC 6901 pointer against your document, with a real explanation when it does not resolve.
- JSON Search Find a key or a value anywhere in a document by exact text, fuzzy match or regular expression, and replace what you find inside string values.
- Query Workbench Run a JSONPath or JMESPath query against your JSON and see the result, both languages in one place.
转换
- JSON to CSV Converter Turn an array of objects into a spreadsheet, and a CSV export back into JSON.
- JSON to NDJSON Converter Split an array into one JSON value per line, or collect those lines back into an array.
- JSON to Base64 Converter Encode a document as Base64 text, or decode Base64 back into the JSON it holds.
- JWT Decoder Decode a JSON Web Token's header and payload, read its standard claims, and see at a glance whether it has expired. Decoding only, never verification.
- JSON to YAML Converter Turn JSON into indented YAML and read YAML back into JSON, in the browser.
- JSON to JavaScript Converter Turn JSON into a JavaScript object literal and read a literal back into JSON, in the browser.
- JSON to XML Converter Convert JSON to XML and XML back to JSON, with the mapping stated on the page.
- JSON to Markdown Converter Turn JSON into a Markdown table, a nested bullet list, a fenced code block, or a short field summary.
- JSON to SQL Converter Turn JSON into a CREATE TABLE and INSERT statements for PostgreSQL, MySQL, SQLite or SQL Server.
- JSON to Excel Converter Turn JSON into a real .xlsx workbook, with flattened columns, multiple sheets and a bold header row.
转义和编码
转换
- JSON Key Sorter Put every object key in order, at every level, without touching the values.
- JSON Flattener Turn a nested document into one level of paths and values, and build it back.
- JSON Patch Playground Apply an RFC 6902 patch, write one from two documents, or reverse one to undo a change.
- JSON Merge Combine two documents into one, choose how conflicts and arrays are handled, or generate an RFC 7386 merge patch.
- JSON Cleaner Strip nulls and empty containers, trim strings, deduplicate arrays, rename or redact keys, and keep or delete whole paths, all from one page.
- JSON Redact Find what looks like an email, an IP address, a phone number, an API key or a name, and replace each with a fixed placeholder, live as you type.
Schema 和代码生成
- JSON Schema Generator Infer a JSON Schema from a sample document, with optional keys reported as optional.
- JSON to TypeScript Turn a sample document into TypeScript interfaces, with optional keys marked optional.
- JSON Schema Validator Check a JSON document against a JSON Schema and see each problem with the keyword and path that caused it.
- JSON Schema Diff Compare two JSON Schemas and see exactly what changed, with every change marked breaking or not.
- API Response Analyzer Paste an API response and see suspicious nulls, inconsistent types, duplicate keys and large sections, plus a candidate schema, TypeScript types and JSONPath examples.
- OpenAPI Helpers Write a document as an OpenAPI schema, build an example from a schema, or check an example against one, all in OpenAPI 3.0 or 3.1.
格式化和验证
查看和探索
转换
转义和编码
转换
Schema 和代码生成
没有工具与您的搜索匹配。
完全在您的浏览器中运行。