Univer is a free, open-source Office SDK that lets you embed a real spreadsheet, document or slide editor inside your own product — instead of sending your users out to Excel or Google Sheets. Version 1.5.0 was released on November 14, 2026, and the next day it hit the top of GitHub Trending. We installed version 1.5.0 on our own Linux machine and ran real formula tests against it — in Node.js with no browser at all, and in the browser with a Vite app — to check whether the hype survives contact with a real test run.
Univer is an Office SDK from DreamNum (dream-num/univer on GitHub) for building Office applications inside your own product. It provides spreadsheet, document and presentation editing, formula calculation, and file processing — for people and for AI agents — using your data and your permissions. The product family covers Sheets, Docs, Slides, relational tables, canvases and PDFs. The core Web SDK is Apache-2.0, and the open-source part covers formulas, number formats, filtering, sorting, data validation, conditional formatting, comments, and the Sheets and Docs editors. Collaboration, file import/export, charts and pivot tables sit in the paid Pro / Server SDK layer — see section 4 for the exact boundary.
The numbers behind the surge: the GitHub repo showed 25,357 stars when we checked on November 15, 2026, it was #1 on GitHub Trending (daily) that day, and the npm package @univerjs/presets was downloaded 644,304 times in the previous 7 days (about 90,000–155,000 a day). The trigger was the v1.5.0 release on November 14, 2026, which reframes Univer as an "AI office": the same content runtime also runs headless in Node.js, so an agent or a script can create a workbook, calculate formulas and save a snapshot without opening a browser. That claim is exactly what we tested — on our own machine, with our own test data.
Requirements (from the official docs): Node.js 20.19 or 22.12 or newer for the Vite path; headless Univer itself only needs Node.js 18.17. Our test ran on Ubuntu 24.04 (x86_64) with Node v24.22.1 and npm 10.9.4, on November 15, 2026.
Path A — the spreadsheet in the browser (Preset Mode). This is the short path from the README, and the one most small businesses will use: a real spreadsheet editor embedded in a web page.
Step 1 — Scaffold a Vite project. We used the vanilla TypeScript template, which keeps the example free of any UI framework:
npm create vite@latest univer-browser -- --template vanilla-ts cd univer-browser npm install
Step 2 — Install the two Univer packages. Watch the names character by character: the scope is @univerjs, the packages are presets and preset-sheets-core:
npm install @univerjs/presets@1.5.0 @univerjs/preset-sheets-core@1.5.0
Step 3 — Give the container a height, then paste the README example. The README says to create the container as <div id="app" style="height: 100vh"></div> — that height is not optional. The Vite template ships <div id="app"></div> with no height, and with that the sheet canvas collapses to zero height and the grid area stays blank (we hit this ourselves — see section 3). Replace src/main.ts with the preset example, plus a few lines that write a small quotation into the sheet, including formulas:
import { UniverSheetsCorePreset } from '@univerjs/preset-sheets-core'
import UniverPresetSheetsCoreEnUS from '@univerjs/preset-sheets-core/locales/en-US'
import { createUniver, LocaleType, mergeLocales } from '@univerjs/presets'
import '@univerjs/preset-sheets-core/lib/index.css'
const { univerAPI } = createUniver({
locale: LocaleType.EN_US,
locales: {
[LocaleType.EN_US]: mergeLocales(UniverPresetSheetsCoreEnUS),
},
presets: [
UniverSheetsCorePreset({
container: 'app',
}),
],
})
const workbook = univerAPI.createWorkbook({})
const sheet = workbook.getActiveSheet()!
sheet.getRange('A1:D4').setValues([
['Item', 'Quantity', 'Unit price', 'Amount'],
['Seats', 2, 25, '=B2*C2'],
['Support', 1, 100, '=B3*C3'],
['Total', '', '', '=SUM(D2:D3)'],
])
Step 4 — Build it. Ours built in about 7 seconds, with only one harmless warning about a "use client" directive in a dependency:
npm run build # ✓ built in 6.87s
Path B — headless in Node.js (Plugin Mode). This is the path for scripts and agents: no browser, no UI, same formula engine. The official headless guide is at docs.univer.ai/guides/sheets/getting-started/node — note that the older address /guides/sheets/features/headless now returns a 404 page, so use the new one. The local setup from that guide registers the content-layer plugins explicitly (the browser presets register UI plugins and do not belong in a Node.js configuration):
npm install @univerjs/core @univerjs/docs @univerjs/engine-formula \ @univerjs/engine-render @univerjs/sheets @univerjs/sheets-formula \ @univerjs/sheets-numfmt
const { LocaleType, mergeLocales, Univer } = require('@univerjs/core')
const { FUniver } = require('@univerjs/core/facade')
const { UniverDocsPlugin } = require('@univerjs/docs')
const { UniverFormulaEnginePlugin } = require('@univerjs/engine-formula')
const { UniverRenderEnginePlugin } = require('@univerjs/engine-render')
const { UniverSheetsPlugin } = require('@univerjs/sheets')
const { UniverSheetsFormulaPlugin } = require('@univerjs/sheets-formula')
const { UniverSheetsNumfmtPlugin } = require('@univerjs/sheets-numfmt')
const SheetsEnUS = require('@univerjs/sheets/locale/en-US').default
require('@univerjs/engine-formula/facade')
require('@univerjs/sheets/facade')
require('@univerjs/sheets-formula/facade')
require('@univerjs/sheets-numfmt/facade')
const univer = new Univer({
locale: LocaleType.EN_US,
locales: { [LocaleType.EN_US]: mergeLocales(SheetsEnUS) },
})
univer.registerPlugin(UniverRenderEnginePlugin)
univer.registerPlugin(UniverFormulaEnginePlugin)
univer.registerPlugin(UniverDocsPlugin)
univer.registerPlugin(UniverSheetsPlugin)
univer.registerPlugin(UniverSheetsFormulaPlugin)
univer.registerPlugin(UniverSheetsNumfmtPlugin)
const univerAPI = FUniver.newAPI(univer)
Two things we learned while writing that code, so you don't have to: @univerjs/facade is still on an old 0.5.5 version line — don't install it; the Facade API lives at @univerjs/core/facade. And createUniverOnNode() in the guide is a helper the guide defines itself (it also wires in a Pro licence and collaboration plugins) — it is not exported by any npm package, so for a local, licence-free test use the plugin list above instead.
Target: the same small-business loop the README demonstrates — write a quotation into the sheet, let the formulas calculate, change a quantity and watch the total recalculate, then save the workbook and reload it. Every value below is what Univer itself reported back, not what we typed in and assumed. All test data is our own.
node test-headless.cjs # PASS T1 D2 =B2*C2 (2*25): actual=50 expected=50 # PASS T1 D3 =B3*C3 (1*100): actual=100 expected=100 # PASS T1 D4 =SUM(D2:D3): actual=150 expected=150 # PASS T1 A1 text round-trip: actual="Item" expected="Item" # PASS T2 D2 after B2=4 (4*25): actual=100 expected=100 # PASS T2 D4 after B2=4: actual=200 expected=200 # PASS T3 D5 =AVERAGE(D2:D3) (100,100): actual=100 expected=100 # PASS T3 D6 =IF(B2>3) -> big: actual="big" expected="big" # PASS T4 D7 =1/0 is an error value: actual=true expected=true # PASS T5 reloaded D4 still 200: actual=200 expected=200 # PASS T5 reloaded A2 still Seats: actual="Seats" expected="Seats" # TOTAL: 11/11 passed, 0 failed
The formula engine recalculates on edit (changing the quantity from 2 to 4 moved the total from 150 to 200), AVERAGE and IF behave as expected, and division by zero correctly returns a #DIV/0! error value instead of crashing or silently returning 0. Saving with workbook.save() produced a 1,662-byte JSON snapshot; loading that snapshot in a fresh instance restored the workbook with the total still at 200.
Two honest quirks from this run. First, the README's browser example waits for the lifecycle to reach Steady before editing — in headless Node the lifecycle stays at stage 1 and never reaches Steady, so that wait hangs forever; cell read/write and formula calculation still work immediately, so just proceed after creating the workbook. Second, you cannot create a second workbook with the same unit id inside one Univer instance (it throws "cannot create a unit with the same unit id") — reload a snapshot in a fresh instance, or dispose the first one.
We served the built app locally and opened it in a real Chromium. The toolbar (Start / Formulas / View, font and formatting controls), the formula bar showing A1 = Item, and the Sheet1 tab all rendered. Reading the computed total back from the live page returned 150 (2×25 + 1×100), with no console errors and no page errors. The screenshot showed the full grid: Item / Quantity / Unit price / Amount, Seats 2 / 25 / 50, Support 1 / 100 / 100, Total 150.
The one that caught us out: with the Vite template's default <div id="app"> (no height), the sheet canvas measured 1264×0 and the grid area was blank white — only the toolbar showed. Adding style="height: 100vh" to the container, exactly as the README says, fixed it on the next build. Lesson for your own project: if your Univer grid is blank but the toolbar renders, check the container height first.
| What we checked | Result |
|---|---|
| Install from npm, exact package names, v1.5.0 | Passed. Preset packages and all seven headless plugin packages installed cleanly. |
| Vite build of the browser preset | Passed. Built in ~7 seconds; one harmless "use client" warning. |
| Browser render + live formula result | Passed. Grid renders with the quotation; D4 reads back as 150; no console or page errors. |
| Headless formulas: multiply, SUM, AVERAGE, IF | Passed. All computed values matched hand-checked answers. |
| Recalculation on edit | Passed. Changing B2 from 2 to 4 moved D2 50 → 100 and the total 150 → 200. |
| Error values | Passed. =1/0 returns #DIV/0!, as a spreadsheet should. |
| Snapshot save and reload | Passed. 1,662-byte JSON snapshot reloads with values intact (total still 200). |
| README lifecycle wait in headless Node | Does not apply. Stage stays at 1, never reaches Steady; operations work anyway. |
Our verdict: the core loop is real — install two packages, paste the preset example, and you have a working spreadsheet editor with live formulas in your own page; and the same engine runs headless in Node.js for scripts and agents. For a free, open-source SDK, that is the part that matters most. The rough edges are honest ones — see the next section — not hidden ones.
save() returns a Univer JSON snapshot — it does not write a .xlsx file. Check the feature comparison on univer.ai before assuming a feature is included.createWorkbook() instead.height: 100vh) before debugging anything else./guides/sheets/features/headless) returns a 404 page as of November 15, 2026. The working address is /guides/sheets/getting-started/node.dream-num/univer, the npm scope @univerjs, and the docs at docs.univer.ai. Check every package name character by character before installing — similarly named packages on npm are the classic way to get a fake.@univerjs/facade package. It is still on version 0.5.5 and is not part of the 1.5.0 line; the Facade API lives at @univerjs/core/facade.Yes, for the open-source core: Apache-2.0, no account, no licence key, no payment. The paid parts are the Server SDK and Pro plugins (collaboration, file import/export, charts, pivot tables). Everything in this tutorial uses only the free core.
No. The preset and headless setups in this tutorial run entirely locally with no sign-up. You only need a licence and an account when you use the collaboration server or Pro features.
No — it is not a finished spreadsheet app, it is a kit for putting a spreadsheet inside your own app. If you just need a spreadsheet for yourself, use Excel or Google Sheets. If you need your customers to edit a quotation, a price list or an order sheet inside your own product without leaving it, Univer is built for that.
Almost certainly the container has no height. Give it one, for example <div id="app" style="height: 100vh"></div>, and rebuild. We hit exactly this in our own test: the canvas measured 1264×0 until we added the height.
Not in the open-source core. save() returns a Univer JSON snapshot. XLSX / DOCX / PDF import and export are part of the Server SDK, which is licensed separately.
Yes — that is the "AI office" idea behind v1.5.0. The headless runtime in Node.js lets a script or an agent create a workbook, set values, calculate formulas and save a snapshot, all without a browser. Our headless test ran 11 checks in about 4 seconds on a small Linux machine. The agent still needs your code to drive it; Univer provides the engine, not the agent.
Univer is the kind of free, open-source tool we use when we build websites for small businesses — practical, no subscription, and it does the job it promises. See our website service, or browse our free tools — invoice generator, price-list generator, food-cost calculator and more, all running locally in your browser.
We can put your design on T-shirts, hoodies, mugs, posters and more — printed to order in Quebec, no minimums, with a free preview before you pay.
Contact us for a free quote