Who univer is for#
SaaS Developers Embedding Spreadsheet Editing
Embed a full-featured spreadsheet editor, including formulas, sorting, filtering, and conditional formatting, into a product page without building the editor from scratch or paying per-seat commercial fees. The Preset Mode setup gets a working sheet rendered in a few lines of TypeScript.
Skip if:
If you only need to display static tabular data without editing, a table component is far simpler and lighter. Univer's value is interactive editing and formula computation, not display only.
AI and Automation Engineers
The headless Node.js mode and Facade API let agents inspect, modify, and verify spreadsheet or document content without rendering a UI. The SDK's isomorphic design means the same API surface used in the browser is available server-side, so document processing scripts match what end-users see.
Skip if:
If your AI workflow only needs to parse XLSX files without editing them or computing formulas, a lightweight file parser may be simpler to operate and maintain than a full office SDK.
Teams Replacing SpreadJS or Handsontable
Univer covers the spreadsheet and data-grid use cases that SpreadJS and Handsontable address, under an Apache-2.0 license with no per-developer pricing. The Facade API and plugin architecture provide a path for replacing the spreadsheet component in an existing product with a self-hostable open-source SDK.
Skip if:
If your current SpreadJS or Handsontable integration is tightly coupled to their specific API surface, a full migration will require rewriting the integration layer. Evaluate against the Univer Facade API before committing.
BI and Data Tool Builders
The Canvas2D rendering engine handles large datasets at interactive speeds: 50-60 FPS scroll over 6 million cells and near-instant load for 1 million cells, per the project's published benchmarks. Data validation, conditional formatting, and extensible UI plugins cover the analytical features most BI products need in the open-source tier.
Skip if:
Pivot tables and charts require Univer Pro. If these features are central to your product, budget for the commercial tier or verify that the open-source equivalents meet your needs before building on the free tier.
The problem it solves#
Building a SaaS product or internal tool that needs spreadsheet or document editing means choosing between writing a complex editor from scratch or paying for a commercial JavaScript library. Proprietary libraries like SpreadJS and Handsontable charge per-developer licensing fees, restrict what you can do with the output, and bind you to a vendor's roadmap and support timeline.
The challenge deepens when you need more than basic display: collaborative editing, formula computation over large datasets, server-side document processing for AI workflows, and format interoperability (XLSX, DOCX, PDF) each require significant custom engineering on top of a basic grid library. Teams building AI-heavy products face a further pain: most commercial office components have no programmatic API that an LLM agent can use to read, write, and verify document content.
How it solves it#
Canvas2D Rendering for Large Workbooks
Renders all document types through a shared Canvas2D engine, delivering 50-60 FPS scroll on workbooks with up to 6 million cells. This makes it viable for financial modeling tools, BI dashboards, and data-dense product surfaces that would stall a DOM-based grid.
Composable Plugin Architecture
Every capability ships as a plugin you include selectively. Preset Mode bundles the most common plugins for fast setup; Plugin Mode gives full control over package composition, lazy loading, and bundle size. Over 100 official plugins cover sheets, docs, slides, collaboration, and more.
500+ Built-in Formula Functions
The formula engine ships with over 500 Excel-compatible functions, custom function support, array formulas, and named ranges. The engine runs identically in the browser and in Node.js, so formula results are consistent across client rendering and server-side processing pipelines.
Headless Node.js Mode
Run the SDK in Node.js without a browser or UI layer by excluding UI plugins and focusing on data and computation. This enables server-side document processing, automated report generation, and AI workflows where an agent reads or writes workbook content without rendering it.
Facade API for AI Agent Integration
A unified API surface covers workbooks, worksheets, ranges, documents, formulas, commands, and events across both browser and Node.js environments. The Facade API is the documented integration point for LLMs and agents that need to read, write, and verify document content programmatically.
Six Document Types in One SDK
Covers spreadsheets, rich text documents, presentation slides, Bases (table-driven data apps), Boards (infinite canvas), and PDFs under one runtime and one architecture. Spreadsheets are the most production-ready surface today; Docs and Slides continue to evolve in the same SDK.
Strengths and trade-offs#
Strengths
- Apache-2.0 with No Per-Seat LicensingThe open-source core is Apache-2.0, allowing commercial embedding, modification, and distribution. Unlike SpreadJS and Handsontable, both of which use proprietary commercial licenses with per-developer pricing, Univer's open-source tier has no per-seat cost and no vendor-gated feature access.
- Isomorphic Browser and Node.js RuntimeThe same codebase runs interactive editing in browsers and headless document processing in Node.js. AI pipelines, automated report generation, and server-side formula computation all use the same SDK you ship to end-users, keeping the document model consistent across environments.
- Framework-Agnostic IntegrationOfficial integration packages exist for React, Vue, Angular, Next.js, Astro, Web Components, and plain JavaScript. A product team can adopt Univer without restructuring their existing frontend or being forced into a specific framework.
- Extensible at Every LayerThe plugin architecture exposes custom commands, services, UI components, and Facade APIs as documented extension points. Teams that need custom behavior are not blocked by a vendor's configuration surface: they write a plugin.
Trade-offs
- -Pro Required for Key Production FeaturesReal-time collaboration, XLSX import/export, printing, charts, pivot tables, and edit history are in Univer Pro, a separately licensed commercial product. Teams evaluating Univer for production use should review the open-source vs Pro capability matrix in the README before committing, since core workflows like spreadsheet import/export sit behind the commercial tier.
- -Complex Initial Setup in Plugin ModePlugin Mode requires registering multiple packages, locale merges, Facade API registrations, and CSS imports manually. A basic spreadsheet setup involves over a dozen package registrations. Preset Mode simplifies this but covers only Sheets, Docs, and selected Node profiles.
- -Spreadsheets More Mature Than Other Document TypesSpreadsheets are the most production-ready surface in the open-source tier. Documents and Slides share the same architecture but continue to evolve. Teams building primarily around Bases or Boards should treat those as earlier-stage surfaces.
univer vs alternatives#
Univer vs SpreadJS
SpreadJS is a commercial JavaScript spreadsheet component for enterprise applications, licensed per developer. Univer is an Apache-2.0 alternative in the same integration pattern: both are SDKs you embed into your own product rather than hosted apps.
| Feature | Univer | SpreadJS |
|---|---|---|
| License | Apache-2.0 | Proprietary (per-developer) |
| Document types | Sheets, Docs, Slides, Bases, Boards, PDFs | Spreadsheets |
| Formula engine | 500+ functions (open source) | Excel-compatible (proprietary) |
Univer is the better choice when you need an Apache-2.0 license for free commercial embedding, a broader document surface beyond spreadsheets, or a headless Node.js path for AI and automation. SpreadJS suits teams that need a mature enterprise support contract and a reliable Excel compatibility track record with a single vendor.
Univer vs Handsontable
Handsontable is a JavaScript data grid for editable tables. Its base tier is for non-commercial use only; a commercial license is required for production. Univer's Apache-2.0 core has no such restriction.
| Feature | Univer | Handsontable |
|---|---|---|
| License | Apache-2.0 | Non-commercial free / commercial paid |
| Document types | Sheets, Docs, Slides, Bases, Boards | Data grid only |
| Node.js headless | Yes | No native support |
Univer covers a broader scope: multiple document types, formula-heavy computation, and server-side document processing. Handsontable is worth choosing when your product needs a focused, well-documented editable data grid and does not require multiple document types or server-side processing.
Quick start#
Install using Preset Mode via npm, pnpm, or yarn.
```bash
npm install @univerjs/presets @univerjs/preset-sheets-core
```What it's built on#
- Languages
- TypeScript
- Frameworks
- ReactVue
FAQ#
Is Univer free to use commercially?
Yes. The open-source core is Apache-2.0 licensed, which permits commercial use, modification, and distribution with no per-seat fees. Some advanced features (real-time collaboration, XLSX import/export, charts, and pivot tables) require Univer Pro, a separately licensed commercial product. Check the capability matrix in the GitHub README to see which features are in each tier.
Does Univer require a backend server?
No backend is required for the client-side Web SDK, which runs entirely in the browser. The Server SDK is optional and adds features like real-time collaboration, file conversion, and edit history; you deploy it in your own infrastructure if you need those capabilities.
How does Univer compare to Handsontable and SpreadJS?
Univer offers a wider document surface (spreadsheets, docs, slides, boards, and bases), ships under Apache-2.0 with no per-developer licensing fees, and includes a headless Node.js mode and Facade API for programmatic access. Handsontable and SpreadJS are mature commercial products with detailed documentation; they may be the better choice when you need their specific API patterns or enterprise support contracts.
Can Univer run in Node.js for server-side document processing?
Yes. The headless mode excludes UI plugins and focuses on data and computation. The Facade API is available in Node.js, making it suitable for formula evaluation, document generation, and AI agent workflows that process office documents server-side. Node.js 18.17.0 or later is required.
What frontend frameworks does Univer support?
Univer has official integration packages for React (18 and 19, with limited support for 16.9+ and 17), Vue, Angular, Next.js, Astro, Web Components, and plain JavaScript. Browser targets include Chrome 88+, Firefox 90+, and Safari 14.1+.
Similar open-source tools#
DeskcommCRM
AI agents for WhatsApp sales, fully audited, no per-user pricing
JellyBoxPlayer
Native Jellyfin and Emby music player for every platform
stremio-web
Open source web UI for media streaming, powered by community addons.
FckSignups
Open-source tools that work instantly, no signup required
OpenCompany
Self-hosted AI agent canvas for every business function
God's Eye View
Real-time global intelligence on a 3D globe