← all repositories
beiwocaishijia/gezhi-sheets

A spreadsheet that asks the AI, not the other way around

Gezhi Sheets is a local-first Windows workbench where you select cells, describe the job in plain Chinese, and confirm the AI's edits before anything touches your data.

★544 stars JavaScript Data Tooling
gezhi-sheets
Too new to rank. Velocity needs a few days of history.
not enough history yet
star history

What it does

Gezhi Sheets (格知 AI) is a self-hosted spreadsheet workbench built in vanilla JavaScript and Node.js. You select a range, type what you want in natural language — “extract a category and one-line summary from these customer comments” — and the AI proposes new columns or edits. Nothing is written until you review a preview showing original values, suggested values, and target cells, and every applied change can be undone in one step.

The interesting bit

The design philosophy is “AI proposes, the program disposes”: statistics run through a restricted query plan executed by code (filter, group, count, sum, average, sort), not by the model free-styling SQL-ish answers. Formulas are generated and trial-computed row by row, and stale previews are blocked if the underlying data changed. It’s a sensible trust boundary for LLM-assisted editing.

Key highlights

  • Six task types: batch column filling, text-to-table, data cleanup, table Q&A, formula assistance, and table operations (sort, highlight)
  • Works with five Chinese model providers — GLM, Kimi, Doubao, DeepSeek, Qwen — each with its own key and model config, no cross-vendor auto-switching
  • API keys encrypted locally via Windows DPAPI; workbooks stay on your machine, and only the selected range is sent to the provider you chose
  • Solid file hygiene: debounced autosave, atomic replacement, last-good backup, Excel/CSV import with type checking (10 MB cap)
  • 144 passing tests across component, backend/adapter, and browser flows

Caveats

  • Windows-only, needs Node.js 22.13+; no accounts or collaboration in this first version
  • Sheet limits: 1,000 rows × 100 columns, 20 sheets per workbook; formula support is a whitelist of basics (SUM, IF, ROUND, etc.) — no macros or charts preserved on import
  • The five provider adapters passed protocol-mock tests, but real-account connections still need your own keys to verify; the README is upfront that demos use fixture responses

Verdict

Worth a look if you process messy Chinese-language business data (customer feedback, order notes, meeting minutes) and want AI help without surrendering your file to a cloud office suite. Skip it if you need cross-platform support, collaboration, or heavy Excel formula fidelity.

Frequently asked

What is beiwocaishijia/gezhi-sheets?
Gezhi Sheets is a local-first Windows workbench where you select cells, describe the job in plain Chinese, and confirm the AI's edits before anything touches your data.
Is gezhi-sheets open source?
Yes — beiwocaishijia/gezhi-sheets is open source, released under the MIT license.
What language is gezhi-sheets written in?
beiwocaishijia/gezhi-sheets is primarily written in JavaScript.
How popular is gezhi-sheets?
beiwocaishijia/gezhi-sheets has 544 stars on GitHub.
Where can I find gezhi-sheets?
beiwocaishijia/gezhi-sheets is on GitHub at https://github.com/beiwocaishijia/gezhi-sheets.

heatdrop uses Google Analytics to see which pages get read — nothing else. Your call. How we handle data.