简体中文 Open the editor

Edit XML, JSON and YAML — and CSV, SQLite and Excel files — in your browser

Browse and change structured documents with a tree and a table, and make a repeated change across a whole column at once. Files are processed only in your browser and never uploaded; saving keeps the file's encoding, byte order mark and line endings.

Open the XML / JSON / YAML editor CSV editor SQLite editor Excel editor

Free, no sign-up. Edge or Chrome recommended; in other browsers, Save downloads the file. The CSV, SQLite and Excel editors are in Chinese for now.

Four editors

XML · JSON · YAML

Structured documents

Tree on the left, smart table in the middle, node properties on the right; the source and the tree follow each other. Search, condition queries, Schema checks, templates and checkpoints.

Open →
CSV · TSV

CSV editor

Every field is text, so leading zeros, long numbers and dates stay exactly as they are. Edit in place, filter, find and replace; unchanged records are written back byte for byte.

Open →
.sqlite · .db

SQLite editor

Browse and filter tables, and write text, integers, reals, NULL or BLOBs with an explicit type. Constraints, foreign keys and triggers apply, and a failed action is rolled back completely.

Open →
.xlsx

Excel editor

Only the cells you edit change; styles, charts and other sheets are kept. Legacy .xls files can be viewed and copied.

Open →

Why XJY Editor

Your files stay on your computer

Reading, editing, converting and saving all happen in the browser. The website only serves the pages and never sees your file names or contents.

Saving leaves alone what you didn't touch

GBK, UTF-16, files with a byte order mark, CRLF line endings — all are written back as they were opened. In Edge and Chrome, Save writes straight back to the file.

Batch edits as easy as one cell

Make a similar change in three cells of a column, and assisted editing previews the same change for the rest. Confirm once, undo once.

Compare with FindChanged

Tick two nodes and send them to FindChanged; click a difference to return to the node.

More

  • Convert and export: XML, JSON and YAML into each other; CSV, Excel and SQLite tables into CSV, TSV or XLSX, with a preview of what changes.
  • Windows right-click menu: with the XJY Editor helper, right-click a file in File Explorer to open it, and Save writes straight back.
  • Offline: download a single HTML file and double-click it on a computer without internet: XML / JSON / YAML, CSV, SQLite, Excel, help.
  • English and Chinese: the XML / JSON / YAML editor and the help are available in both.

Read the full help →