XJY Editor 帮助
XJY Editor 在浏览器中查看和编辑 XML、JSON、YAML 文档,另有 CSV、SQLite、Excel
三个数据编辑器。本页说明各项功能、保存方式和使用限制。
快速上手
-
打开 XJY Editor,点击「打开文件」选择
.xml、.json 或 .yaml 文件;也可以先点「XML 示例」等按钮体验。
- 左侧目录树选择节点,右侧修改名称、值或属性;进入容器后可在「智能表格」中成批编辑同级节点。
-
修改完成后点击「保存」或按 Ctrl+S。保存时保留原文件的编码和换行符,详见保存、草稿与导出。
页头的「CSV 编辑器」「SQLite 编辑器」「Excel 编辑器」在新标签页中打开对应的数据编辑器,当前编辑内容不受影响。
文件只在你的浏览器中处理,不上传到服务器;例外情况见隐私与数据。
打开文件与编码
点击「打开文件」选择本机文件。格式按扩展名判断:.xml、.json、.yaml / .yml。
编码识别
- 文件带 BOM 时按 BOM 识别(UTF-8、UTF-16 LE / BE)。
- XML 声明中写明的编码(如
encoding="GBK")会被采用。
- 其余文件先按严格 UTF-8 读取。
-
都无法确定时会弹出「选择文件编码」窗口:下拉选择编码,下方预览实时显示读取效果,确认文字正常后再打开。中文界面默认建议
GB18030,英文界面默认建议 Windows-1252。
看起来是二进制内容的文件不会被打开。打开后,页面底部的文件状态行显示关联的文件名、编码和换行符,例如「关联文件:data.xml · GB18030 · CRLF」。
语法错误
文件有语法错误时,内容进入源码修复流程:在「源码」页修改并点击「应用源码」,修复前不能使用树和表格编辑。「✓ 语法校验」可随时检查当前文档或未应用的源码。
浏览与编辑节点
单节点编辑
在左侧目录树选择节点,右侧可修改名称、类型、属性或值;输入完成后移出焦点即应用。节点可以添加、复制、上移 / 下移、移动和删除,也可以在目录树和表格中拖动调整顺序。
导航
- Alt+← / Alt+→ 后退 / 前进,Alt+↑ 进入父节点。
- Ctrl+K 聚焦搜索框,可搜索名称、值、属性或显示路径,点击结果会展开并定位节点。
- 目录树与源码双向定位:在源码中移动光标会选中对应节点,反之亦然。
源码
「〈〉源码」页可直接编辑文本。修改后点击「应用源码」才会更新节点;未应用时暂停定位和节点比较。「⇥ 格式化」按两空格缩进重新排版,可撤销。
更多工具
「⧉ 重复检查」列出 XML 中完全相同的同级元素(只提示,不修改)。此外还有条件查询、检查点、批量预览、模板以及 Schema 子集校验。
智能表格
进入一个容器节点后,「▦ 智能表格」把它的同级子节点显示为表格:XML 的属性和简单子元素、JSON / YAML 的字段各成一列。按
Enter 应用单元格;带子树的字段可以继续进入。
- 首列复选框支持多选,「全选筛选结果」「清除选择」用于批量操作。
- 筛选后,结构相同的记录会重新识别为属性列。
- 在编辑框内拖动是选择文字,不会移动行。
- 同一列中做相似的修改可触发辅助编辑。
辅助编辑
辅助编辑把你在几个单元格中做的相同修改,批量应用到同一列的其他单元格。XJY Editor 和 CSV、SQLite、Excel 编辑器都支持。
自动识别
在同一列中,对三个不同的记录连续做相似的插入或删除(例如都删掉开头的 PRE_),第三次提交后会弹出预览,列出将要修改的其余单元格。
主动发起
点击「辅助编辑」,或右键单元格选择「辅助编辑此列…」,自行指定列、规则、内容和位置。Shift+右键保留浏览器自己的菜单。
规则与范围
- 系统按优先级匹配规则:完全一致 → 忽略大小写 → 等长同模式 → 仅等长。下拉列表可以改选其他兼容规则,也可以恢复初始规则。
- 结束位置从右侧计数;字符按 Unicode 码点计数。
- 范围默认为当前筛选结果,可明确切换到当前目录的全部记录。
- 自动模式不会重复处理你手动修改的那三项。
检查预览后点击确认才写入;整批修改可以一次撤销。
保存、草稿与导出
保存
每个编辑器都只有一个「保存」按钮(Ctrl+S)。保存按打开时的编码、BOM 和换行符写出文件。是否能直接写回原文件,取决于浏览器和打开方式:
| 情况 | 保存结果 |
| Edge 或 Chrome,通过 HTTPS 或本机地址访问,用「打开文件」打开 |
直接写回原文件。第一次保存时浏览器会询问是否允许修改该文件。 |
| 通过本机助手右键打开 | 直接写回原文件。 |
| 其他浏览器、通过普通 HTTP 访问、离线版,或打开的是示例 |
下载一个同名文件,下载即视为已保存。 |
页面底部的文件状态行会说明当前属于哪种情况:「关联文件:…」表示写回原文件,「保存时下载 · …」表示下载。
保存时的提示
- 文件已被其他程序修改:打开后磁盘上的文件又被改过时,保存前会询问是否覆盖。
- 换行符混用:文件中同时有 CRLF 和 LF 时,保存会统一为一种,先询问是否继续。
-
字符无法用原编码保存:例如在 GBK 文件中输入了 emoji,会列出出问题的行,文件不会被写出。请修改这些字符后再保存。
源码草稿
源码页有未应用的修改时,按钮显示为「保存源码」,保存的是源码文本本身,不会自动应用到节点。CSV 和 Excel 编辑器则要求先应用或放弃源码草稿。
本地草稿
「保存本地草稿」「恢复草稿」把内容存在浏览器本地,用于意外关闭后的恢复,不能代替保存文件。草稿属于当前网址,换一个网址或使用离线版时互不相通。
导出
「↓ 导出文件」(XJY Editor)以及表格编辑器中的「导出 CSV…」「导出数据库…」「导出工作簿…」下载一份新文件,不影响原文件,也不清除未保存标记。
转换并导出
「转换并导出…」把正在编辑的内容转换成另一种格式并下载新文件,当前文档保持不变。
| 编辑器 | 转换内容 | 可转换为 |
| XJY Editor | 当前整个文档(包括未应用的源码) | XML、JSON、YAML 中的另两种 |
| CSV | 当前整个表格,包括筛选隐藏的记录 | XLSX、TSV、CSV(可改编码) |
| Excel | 当前工作表的完整使用范围 | CSV、TSV |
| SQLite | 当前表的全部记录 | CSV、TSV、XLSX |
转换前会显示预览和会发生的变化,例如 XML 转 JSON 时注释会丢失、属性写成 @名称。需要勾选「我已了解以上转换规则和内容变化」后才能导出。
会被拒绝的情况
- XML 中有 DTD,或转换后的元素名、属性名不合法。
- YAML 使用锚点 / 别名、自定义标签或多文档。
- 有重复键,或嵌套超过 200 层。
- 表格超过 100 万个单元格,或超出 Excel 的行列限制。
- 目标编码无法表示其中的字符。
与 FindChanged 比较
比较两个节点
- 在智能表格中勾选恰好两个同级节点,点击「比较选中两项」。
- 确认左右顺序(可交换),点击底部「打开 FindChanged」。
- FindChanged 在新标签页中显示两个子树的差异。
在 FindChanged 中点击差异可以回到 XJY Editor 定位:共有的差异回到右侧节点,左侧独有的差异回到左侧节点。来源内容改动后需要重新比较。
比较整个文件
「交给 FindChanged」可以比较基线、当前内容或另一个文档的完整文件。
FindChanged 中的修改不会写回 XJY Editor。XML 只能比较元素;YAML 引用和受保护结构暂不支持比较。每侧最多 5 MiB、10 万行,超出时只提供文件下载。
CSV 编辑器
打开或拖入 .csv、.tsv、.txt 文件,在「解析设置」中确认编码、分隔符和是否把首行作为表头。
- 支持逗号、分号、制表符分隔;编码支持 UTF-8、UTF-16 和 GB18030,识别不了时需要你手动选择并预览。
- 所有字段按文本处理:前导零、长数字、日期和空格都按原样保留。
-
双击单元格在格内编辑:Enter 确认,Shift+Enter 换行,Esc 取消。可插入 / 删除行列、改表头、粘贴矩形区域。
- 拖动或 Shift 扩选、Ctrl 多选;复制为制表符分隔文本,可直接粘贴到 Excel。
- 查找、按列筛选、在选区或全表中替换,替换前有预览。
- 「源码」页直接编辑 CSV 文本,点击「应用源码」后更新表格。
保存时只改动编辑过的记录,其余记录、编码和换行符保持原样。删除整列会连同筛选隐藏的数据一起删除,确认窗口会提示。
SQLite 编辑器
打开 .sqlite、.sqlite3、.db、.db3 数据库文件,左侧选择表或视图,表格每页 100 条,支持多条件组合筛选(包含、不包含、比较运算符、NULL 与空文本判断)和列头点击排序。
- 双击字段编辑,并明确选择写入类型:文本、整数、实数、NULL 或 BLOB(十六进制)。整数按 64 位精确处理,不会被舍入。
- 可添加记录(使用默认值和自动主键)和删除多行。数据库自身的约束、外键和触发器照常生效,失败时整个操作回退。
- 导入 CSV:可将 CSV / TSV 导入为新表或追加到已有表,自动识别编码与分隔符、推断字段类型并逐列调整,一步撤销。
- 结构页:列出数据表、视图、索引与触发器及建表 SQL;支持新建/修改/删除表(优先使用
ALTER TABLE,需要时自动重建表并保留数据、索引、触发器与自增序号)和新建/删除索引。
- SQL页:支持执行全部(Ctrl+Enter)、执行光标所在语句(Shift+Enter)或选中语句;只读查询不产生修改历史,含写入的整批作为一个事务和一步撤销,每个结果集最多显示前 1000 行。
只读与限制
- 视图、虚拟表、系统表、生成列,以及无法唯一定位记录的表不在数据页直接编辑。
- WAL 模式的数据库只允许查询:请先在原应用中关闭数据库(完成检查点)再修改。
- 已有外键错误的数据库在数据页拒绝修改,可在「SQL」页修复外键问题(不允许产生新的外键错误)。
保存写出整个数据库文件。暂不支持打开加密数据库。
Excel 编辑器
打开 .xlsx 工作簿,切换工作表、翻页、按地址定位和筛选。隐藏的行列默认不显示,可以选择显示。
- 双击单元格编辑,可写入文本、数值、布尔、日期、公式或错误值。文本
001 会保留前导零。
- 粘贴制表符分隔文本前会确认,内容一律按文本写入。
- 「源码」页可编辑当前工作表的 XML,只允许修改已有单元格的值和公式。
保存时只修改目标工作表,原有样式、图表、其他工作表都保留。浏览器不计算公式:修改后公式标为「待重算」,请在 Excel 中打开保存后的文件完成重算。
限制
.xls 旧格式只能查看和复制,不能保存;请先在 Excel 中另存为 .xlsx。
- 受保护的工作表、含宏或签名的工作簿只读;合并区域只能改左上角;共享公式和数组公式区域只读。
- 不能插入 / 删除整行整列、修改格式或工作表名。
- 工作簿最大 30 MB,解压后最大 100 MB;单元格文本最多 32767 个字符。不支持加密工作簿。
本机助手(右键打开)
XJY Editor 助手是一个 Windows 小程序。安装后,在资源管理器中右键文件,选择「用 XJY Editor 打开」,即可在浏览器中打开该文件,保存时直接写回原文件。
- 支持
.xml、.json、.yaml、.csv、.tsv、.sqlite、.sqlite3、.db、.db3、.xlsx、.xls,按格式进入对应的编辑器。
- Windows 11 中菜单可能在「显示更多选项」里。只对单个文件显示,多选或文件夹不显示。
- 双击
XJYEditorHelper.exe 安装,不需要管理员权限,也不改变文件的默认打开程序。再次双击安装目录中的助手,或在 Windows「设置 → 应用」中卸载。
- 助手只在本机 127.0.0.1 上工作,只能访问你选中的那一个文件;文件内容不经过网站服务器。单个文件最大 128 MiB。
- 页面停止使用 10 分钟后助手自动退出;刷新页面后不会自动重新关联文件,需要右键重新打开。
CSV、SQLite、Excel 文件的直接写回需要助手 0.3.0 或更新版本;旧版本保存时会改为下载。
快捷键
| 按键 | 作用 | 适用 |
| Ctrl+S | 保存 | 全部编辑器 |
| Ctrl+Z | 撤销(SQLite 编辑器请用工具栏按钮) | XJY Editor、CSV、Excel |
| Ctrl+Shift+Z | 重做 | XJY Editor、CSV、Excel |
| Ctrl+Y | 重做 | CSV、Excel |
| Ctrl+K | 搜索节点 | XJY Editor |
| Alt+← / → | 后退 / 前进 | XJY Editor |
| Alt+↑ | 进入父节点 | XJY Editor |
| Esc | 关闭搜索结果;取消单元格编辑 | 全部编辑器 |
| Enter / Shift+Enter | 确认单元格 / 在单元格内换行 | 表格 |
| Ctrl+D | 选择下一个相同文本(多光标) | 源码编辑 |
| Shift+右键 | 显示浏览器自己的右键菜单 | 表格 |
隐私与数据
- 文件的读取、编辑、转换和保存都在你的浏览器中完成,网站服务器只提供页面,不接收文件内容。
- 本地草稿和界面偏好保存在浏览器本地存储中,只有这台电脑的这个浏览器能读到。
- 使用「打开 FindChanged」「交给 FindChanged」时,所选内容会在浏览器中交给 FindChanged 页面(默认 https://findchanged.com)。只发送选中的节点或文档,不会修改原文件。
- 本机助手只在本机工作,不把文件发给网站。
限制
- XML 不支持 DTD;Schema 校验只支持一部分声明。
- YAML 的锚点、别名和自定义标签受保护,部分操作(比较、转换)不可用。
- 直接写回原文件只在 Edge / Chrome 等支持文件系统访问的浏览器中可用;其他浏览器保存为下载。
- CSV、SQLite、Excel 编辑器目前只有中文界面。
常见问题
为什么点「保存」变成了下载?
当前浏览器或访问方式不能写回原文件,例如普通 HTTP 访问、离线版、非 Edge / Chrome 浏览器,或打开的是示例。可以改用 HTTPS 地址,或通过本机助手打开。
保存时提示「没有权限」?
第一次保存时浏览器会询问是否允许修改文件,请选择允许。如果之前拒绝过,重新用「打开文件」打开该文件即可再次询问。
打开后中文是乱码?
文件没有 BOM 又不是 UTF-8 时,需要在「选择文件编码」窗口中挑选正确的编码,例如 GB18030。确认预览正常后再打开。
提示文件已被其他程序修改?
打开以后,磁盘上的文件被别的程序改过。选择覆盖会用当前内容替换磁盘上的版本;选择取消则保持磁盘文件不变,你可以先导出当前内容再比较。
刷新页面后内容还在吗?
未保存的修改会在离开页面前提示。可用「保存本地草稿」做恢复备份,但它不能代替保存文件。
XJY Editor Help
XJY Editor views and edits XML, JSON and YAML documents in the browser, and adds three data
editors for CSV, SQLite and Excel. This page explains the features, how saving works, and the
limits.
Quick start
-
Open XJY Editor and click
Open file to choose an
.xml, .json or .yaml file, or try one of
the sample buttons first.
-
Select a node in the tree on the left and edit its name, value or attributes on the right. Inside a
container, the Smart table edits sibling nodes together.
-
Click Save or press Ctrl+S. The original encoding and line endings are kept;
see Saving, drafts and export.
The CSV, SQLite and Excel editor links in the header open in a new tab and leave your current work untouched.
Files are processed only in your browser and are not uploaded. See Privacy and data for the exceptions.
Opening files and encodings
Click Open file to choose a local file. The format follows the extension: .xml, .json, .yaml / .yml.
Encoding detection
- A byte order mark decides the encoding (UTF-8, UTF-16 LE / BE).
- An encoding named in the XML declaration (such as
encoding="GBK") is used.
- Otherwise the file is read as strict UTF-8.
-
If none of these works, the Choose the file encoding window opens. Pick an encoding and check the live
preview before opening. The suggestion is Windows-1252 in the English interface and GB18030 in the
Chinese one.
Files that look binary are not opened. The file status line at the bottom shows the linked file, encoding and line endings, for example “Linked file: data.xml · GB18030 · CRLF”.
Syntax errors
A file with syntax errors opens in source repair mode: fix it on the Source tab and click
Apply source. The tree and table are unavailable until then. Validate syntax checks the document or
the unapplied source at any time.
Browsing and editing nodes
Editing a node
Select a node in the tree; edit its name, type, attributes or value on the right. Changes apply when the
field loses focus. Nodes can be added, copied, moved up or down, moved elsewhere and deleted, and you can
drag them in the tree and the table to reorder.
Navigation
- Alt+← / Alt+→ go back / forward; Alt+↑ goes to the parent.
- Ctrl+K focuses search. Search names, values, attributes or display paths; clicking a result reveals the node.
- The tree and the source follow each other: moving the cursor in the source selects the node, and selecting a node highlights its source.
Source
Edit text directly on the Source tab and click Apply source to update the nodes. While the
source has unapplied changes, locating and node comparison pause. Format re-indents with two spaces
and can be undone.
More tools
Check duplicates lists identical sibling elements in XML (report only). There are also condition
queries, checkpoints, batch previews, templates and a subset of Schema validation.
Smart table
Inside a container node, the Smart table shows its children as rows: XML attributes and simple
child elements, or JSON / YAML fields, become columns. Press Enter to apply a cell; fields with
subtrees can be entered.
- Use the first-column check boxes, Select filtered rows and Clear selection for batch actions.
- After filtering, records with the same structure are recognised as columns again.
- Dragging inside an edit box selects text; it does not move rows.
- Similar edits in one column can start assisted editing.
Assisted editing
Assisted editing repeats the change you made in a few cells across the rest of the column. It is available in XJY Editor and in the CSV, SQLite and Excel editors.
Automatic
Make a similar insertion or deletion in three different records of one column (for example, remove a
leading PRE_). After the third edit, a preview lists the other cells that would change.
On request
Click Assisted editing, or right-click a cell and choose Assist editing this column…, to choose the column, rule, text and position yourself. Shift+right-click keeps the browser menu.
Rules and scope
- Rules are tried in order: exact match → ignore case → same length and pattern → same length only. You can pick another compatible rule or restore the first one.
- End positions count from the right; characters are counted as Unicode code points.
- The scope is the current filter result by default; you can switch to all records in the current folder.
- The automatic mode does not repeat your three manual edits.
Nothing is written until you confirm the preview, and the whole batch undoes in one step.
Saving, drafts and export
Save
Every editor has a single Save button (Ctrl+S). It writes the file with the
encoding, byte order mark and line endings it was opened with. Whether it writes back to the original file
depends on the browser and how the file was opened:
| Situation | What Save does |
| Edge or Chrome over HTTPS or a local address, file opened with Open file |
Writes back to the original file. The browser asks for permission the first time. |
| File opened with the local helper | Writes back to the original file. |
| Other browsers, plain HTTP, the offline version, or a sample |
Downloads a file with the same name; the download counts as saved. |
The file status line tells you which applies: “Linked file: …” writes back, “Saving downloads the file · …” downloads.
Questions while saving
- The file was changed by another program: if the file on disk changed after you opened it, you are asked before it is overwritten.
- Mixed line endings: if the file mixes CRLF and LF, saving uses one of them throughout and asks before continuing.
-
Characters the encoding cannot store: for example an emoji in a GBK file. The affected lines are
listed and nothing is written; change those characters and save again.
Source drafts
While the Source tab has unapplied changes, the button reads Save source and saves the source text itself without applying it. The CSV and Excel editors ask you to apply or discard the draft first.
Local drafts
Save local draft and Restore draft keep a copy in browser storage for recovery after an accidental close. They do not replace saving the file, and drafts belong to the current address only.
Export
Export file (XJY Editor) and Export CSV…, Export database…, Export workbook… in the table editors download a new copy. They leave the original file alone and do not clear the unsaved mark.
Convert and export
Convert and export… converts what you are editing into another format and downloads a new file. The current document does not change.
| Editor | What is converted | Targets |
| XJY Editor | The whole document, including unapplied source | The other two of XML, JSON, YAML |
| CSV | The whole table, including filtered-out records | XLSX, TSV, CSV (encoding can change) |
| Excel | The used range of the current sheet | CSV, TSV |
| SQLite | All records of the current table | CSV, TSV, XLSX |
A preview lists what will change, for example XML comments are dropped and attributes become @name keys. Tick the box confirming you understand the conversion before exporting.
Conversions that are refused
- XML with a DTD, or element and attribute names that would be invalid.
- YAML with anchors / aliases, custom tags or several documents.
- Duplicate keys, or nesting deeper than 200 levels.
- Tables over one million cells, or beyond Excel's row and column limits.
- Characters the target encoding cannot represent.
Comparing with FindChanged
Compare two nodes
- In the smart table, tick exactly two sibling nodes and click Compare selected pair.
- Check the left and right sides (you can swap them) and click Open FindChanged.
- FindChanged shows the differences between the two subtrees in a new tab.
Clicking a difference in FindChanged locates it back in XJY Editor: shared differences go to the right
node, differences only on the left go to the left node. Compare again after changing the source.
Compare whole files
Send to FindChanged compares the baseline, the current content or another document as whole files.
Changes made in FindChanged are not written back. XML compares elements only; protected YAML structures
cannot be compared yet. Each side is limited to 5 MiB and 100,000 lines; larger content is offered as a
download instead.
CSV editor
Open or drop a .csv, .tsv or .txt file and confirm the encoding, delimiter and header row in Parse settings.
- Comma, semicolon and tab delimiters; UTF-8, UTF-16 and GB18030. If the encoding cannot be detected, choose it yourself with a preview.
- Every field is text: leading zeros, long numbers, dates and spaces are kept exactly.
-
Double-click a cell to edit in place: Enter confirms, Shift+Enter adds a
line break, Esc cancels. Insert or delete rows and columns, rename headers, paste a block.
- Drag or Shift to extend a selection, Ctrl to add cells. Copies are tab-separated and paste straight into Excel.
- Find, filter by column, and replace in the selection or the whole table with a preview.
- The Source tab edits the CSV text; Apply source updates the table.
Saving rewrites only the edited records; other records, the encoding and line endings stay as they were. Deleting a column also deletes its filtered-out data, and the confirmation says so.
SQLite editor
Open a .sqlite, .sqlite3, .db or .db3 database, choose a table or view on the left, and page through 100 records at a time with multi-condition filters and column sorting.
- Double-click a field and choose the type to write: text, integer, real, NULL or BLOB (hex). Integers are exact 64-bit values, never rounded.
- Add records (with defaults and automatic keys) and delete several rows. The database's own constraints, foreign keys and triggers apply, and a failed action is rolled back completely.
- Import CSV: import CSV / TSV files into a new table or append to an existing table with encoding/delimiter detection, conservative type inference and single-step undo.
- The Structure tab lists tables, views, indexes and triggers alongside their SQL definitions, and lets you create, modify or drop tables and indexes with a live SQL preview.
- The SQL tab runs all statements (Ctrl+Enter), the statement at the cursor (Shift+Enter) or the selection; read-only queries leave no undo history, while write batches run in one transaction as a single undo step (up to 1,000 result rows displayed).
Read-only cases and limits
- Views, virtual tables, system tables, generated columns, and tables whose rows cannot be identified uniquely are read-only in the data grid.
- Databases in WAL mode allow read-only queries only: close the database in its own application (checkpoint) first before modifying.
- Databases that already have foreign key errors are read-only in the data grid, but can be repaired from the SQL tab (no new foreign key errors may be introduced).
Saving writes the whole database file. Encrypted databases are not supported.
Excel editor
Open an .xlsx workbook, switch sheets, page through rows, go to an address and filter. Hidden rows and columns stay hidden unless you show them.
- Double-click a cell to write text, a number, a boolean, a date, a formula or an error value. Text such as
001 keeps its leading zeros.
- Pasting tab-separated text asks first and always writes text.
- The Source tab edits the current sheet's XML; only values and formulas of existing cells may change.
Saving changes only the edited sheet; styles, charts and other sheets are kept. The browser does not
calculate formulas: edited formulas are marked “needs recalculation”, so open the saved file in Excel to
recalculate.
Limits
- Legacy
.xls files can be viewed and copied but not saved; save them as .xlsx in Excel first.
- Protected sheets and workbooks with macros or signatures are read-only; only the top-left cell of a merged range can change; shared and array formula ranges are read-only.
- Inserting or deleting whole rows or columns, formatting and renaming sheets are not supported.
- Workbooks up to 30 MB (100 MB uncompressed); cell text up to 32,767 characters. Encrypted workbooks are not supported.
Local helper (right-click to open)
The XJY Editor helper is a small Windows program. After installing it, right-click a file in File Explorer and choose 用 XJY Editor 打开 to open it in your browser; Save then writes straight back to the file.
- Supports
.xml, .json, .yaml, .csv, .tsv, .sqlite, .sqlite3, .db, .db3, .xlsx and .xls, each in its own editor.
- On Windows 11 the entry may be under Show more options. It appears for a single file only, not for several files or folders.
- Double-click
XJYEditorHelper.exe to install; no administrator rights are needed and default file associations do not change. Double-click the installed helper again, or use Windows Settings → Apps, to uninstall.
- The helper works only on 127.0.0.1 and can reach only the file you chose; file contents never go through the website. Files up to 128 MiB.
- The helper exits ten minutes after the page stops using it. Reloading the page does not relink the file; open it again from the menu.
Writing back CSV, SQLite and Excel files needs helper 0.3.0 or later; older helpers download on save instead.
Keyboard shortcuts
| Keys | Action | Where |
| Ctrl+S | Save | All editors |
| Ctrl+Z | Undo (use the toolbar button in the SQLite editor) | XJY Editor, CSV, Excel |
| Ctrl+Shift+Z | Redo | XJY Editor, CSV, Excel |
| Ctrl+Y | Redo | CSV, Excel |
| Ctrl+K | Search nodes | XJY Editor |
| Alt+← / → | Back / forward | XJY Editor |
| Alt+↑ | Go to parent | XJY Editor |
| Esc | Close search results; cancel a cell edit | All editors |
| Enter / Shift+Enter | Confirm a cell / line break in a cell | Tables |
| Ctrl+D | Select the next occurrence (multiple cursors) | Source editing |
| Shift+right-click | Show the browser's own menu | Tables |
Privacy and data
- Reading, editing, converting and saving all happen in your browser. The web server only delivers the pages and never receives file contents.
- Local drafts and interface preferences are kept in browser storage, readable only by this browser on this computer.
- Open FindChanged and Send to FindChanged hand the chosen content to the FindChanged page in your browser (https://findchanged.com by default). Only the selected nodes or document are sent, and the original file is not changed.
- The local helper works only on your computer and does not send files to the website.
Limits
- XML DTDs are not supported; Schema validation covers a subset of declarations.
- YAML anchors, aliases and custom tags are protected, and some actions (compare, convert) are unavailable for them.
- Writing back to the original file needs a browser with file system access, such as Edge or Chrome; other browsers download on save.
- The CSV, SQLite and Excel editors are currently available in Chinese only.
Frequently asked questions
Why does Save download a file?
This browser or address cannot write back to the original file: plain HTTP, the offline version, a
browser other than Edge or Chrome, or a sample. Use the HTTPS address, or open the file with the
local helper.
Saving says permission was denied
The browser asks for permission the first time you save; choose Allow. If you declined before, open the file again with Open file to be asked again.
Text looks garbled after opening
A file without a byte order mark that is not UTF-8 needs the right encoding in the Choose the file encoding window, for example GB18030 for Chinese text. Check the preview before opening.
It says the file was changed by another program
The file on disk changed after you opened it. Overwrite replaces the disk version with your content; Cancel leaves the disk file alone so you can export your content and compare first.
Is my work kept when I reload?
You are warned before leaving a page with unsaved changes. Save local draft keeps a recovery copy, but it does not replace saving the file.