Query and reshape JSON with JSONata expressions, list every path, or flatten nested keys.
用 JSONata 表达式查询与重塑 JSON 数据，列出全部数据路径，或把嵌套键扁平化。
A JSON reshaping workbench powered by JSONata, the expression language designed for querying structured data. Instead of writing traversal code, you describe the transformation you want — items.{name: name, price: price} — and evaluate it against your data. The tool also lists every path present in a document so you can discover the shape of an unfamiliar payload, and flattens nested objects into dotted keys for logging and spreadsheet imports.
一个用 JSONata 驱动的 JSON 重塑工作台。JSONata 是为结构化数据查询设计的表达式语言——你不用写遍历代码，只要描述想要的转换，例如 items.{name: name, price: price}，直接对数据求值即可。工具还会列出文档中出现的所有路径，方便你摸清陌生响应的结构；也能把嵌套对象压平成带点号的键，便于写日志或导入表格。
Only the basics. Field access is dot notation, functions wrap the path in parentheses, and {} creates a new object. The Pick path button shows exactly which paths exist in your data, which is usually enough to write the expression you need.
只需要基础。字段访问用点号，函数用括号包住路径，花括号用来构造新对象。"提取路径"按钮会列出数据里实际存在的路径，通常足够你写出需要的表达式。
Pick path lists the paths available for querying, while Flatten keys produces a new object where every leaf value sits under one dotted key. The first helps you write expressions, the second is for exporting.
"提取路径"列出可用于查询的路径；"扁平化键"生成一个新对象，每个叶子值都放在一个点号键下。前者帮你写表达式，后者用于导出。
JSONata returns undefined, and the result simply omits that key rather than failing. That makes expressions safe to run against records with inconsistent fields.
JSONata 返回 undefined，结果里直接省略该键而不会报错，这让表达式对字段不统一的记录也很安全。
No. Evaluation happens locally in the browser.
不会。求值在浏览器本地完成。
Open an .xlsx or .csv file, preview the sheet, then export it as…
打开 .xlsx 或 .csv 文件预览表格内容，再导出为 JSON、CSV 或…
Profile every column of a CSV — type, empty rate, unique count, …
逐列统计 CSV 的数据类型、空值率、去重数量与最值，并一键去重、排序、导出干净…
Load a .sqlite database and run SQL queries against it entirely …
载入 .sqlite 数据库，用 WASM 版 SQLite 引擎在浏览器里执行…