univer

Product Introduction

1. Definition: Univer is a high-performance, embeddable Office SDK (Software Development Kit) built on a microkernel and plugin architecture. It provides a unified runtime for creating and editing spreadsheets, documents, presentations, databases (Bases), visual boards, and PDFs within web and server applications.
2. Core Value Proposition: It exists to solve the problem of fragmented office tools by offering a single, composable framework that enables seamless collaboration between human users and AI agents. Its primary value is empowering developers to embed and customize full-featured office components directly into their products.

Main Features

1. Unified Multi-Format Engine: Univer provides a single runtime capable of handling six core document types: Sheets, Docs, Slides, Bases, Boards, and PDFs. How it works: A central core (@univerjs/core) manages document units, while specialized plugins (e.g., @univerjs/sheets, @univerjs/docs) provide format-specific logic, all rendered through a shared Canvas2D engine (@univerjs/engine-render) for consistent cross-platform performance.
2. Microkernel + Plugin Architecture: The system is designed for extreme modularity. The lightweight microkernel handles core lifecycle and dependency injection, while all functionalities—from UI components to formula engines—are implemented as plugins. This allows developers to use Preset Mode for quick integration or Plugin Mode for fine-grained, tree-shakeable control over bundle size.
3. Headless & Isomorphic SDK: Univer's Web SDK can run in Node.js environments without a browser. How it works: By excluding UI-rendering plugins (like @univerjs/sheets-ui) and only loading data/calculation plugins (like @univerjs/engine-formula), developers can perform server-side document processing, analysis, and automation using the same API as the frontend.
4. Facade API for AI & Automation: A dedicated Facade API layer provides a stable, high-level interface for programmatic control. This allows Large Language Models (LLMs) and automation agents to directly read, write, format, and analyze document content (e.g., populating a spreadsheet cell, extracting text from a doc) without interacting with the low-level DOM or internal state management.
5. Real-Time Collaboration Engine: Built-in Operational Transformation (OT) algorithms enable multiplayer editing with conflict resolution. This feature allows teams to synchronize changes across spreadsheets and documents in real time, maintaining data consistency and a shared editing history.

Problems Solved

1. Pain Point: The high cost and complexity of building or integrating multiple, disparate office editing suites (like separate spreadsheet, word processor, and presentation editors) into a single web application.
2. Target Audience: Product teams and developers at SaaS companies, fintech applications, project management platforms, low-code/no-code platforms, and any business requiring embedded document editing. Specific personas include Frontend Architects (React/Vue/Angular), Full-Stack Developers, and Product Managers building collaborative or data-intensive web apps.
3. Use Cases: Embedding an Excel-like spreadsheet with 500+ functions into a financial dashboard; adding a collaborative document editor to a project management tool; creating a presentation builder within a marketing automation platform; building a custom database view (Base) for internal business logic; enabling server-side generation and styling of PDF reports from template documents.

Unique Advantages

1. Differentiation: Unlike monolithic office suites or single-format libraries, Univer offers a truly unified, multi-format canvas with a consistent API. Compared to traditional iframe-based embeddings, it provides deep customization, native performance, and direct data integration without cross-origin limitations.
2. Key Innovation: Its composable plugin ecosystem combined with a headless, isomorphic core. This allows the same codebase to power both rich frontend interfaces and backend document services, bridging the gap between human-centric UI and agent-centric automation within a single, licensable framework.

Frequently Asked Questions (FAQ)

1. Is Univer Office SDK open source? Yes, Univer is an open-source project with its core and most plugins available on GitHub under the Apache 2.0 license, allowing for inspection, contribution, and self-hosting.
2. How does Univer handle large spreadsheets and ensure performance? Univer utilizes a virtualized Canvas2D rendering engine and optimized data structures to achieve high-performance scrolling (50-60 FPS) for datasets up to 6 million cells, with benchmarks showing rapid loading for 1 million cells.
3. Can I use Univer with React, Vue, or other frontend frameworks? Yes, Univer provides first-class integrations for React, Vue, Angular, Next.js, Astro, and Web Components, and can also be used with plain JavaScript, offering flexibility for various tech stacks.
4. What is the difference between Univer's Web SDK and Server SDK? The Web SDK is for embedding editors in browser applications, while the Server SDK is for composing backend services like real-time collaboration synchronization, file format conversion (e.g., .xlsx to Univer data), and managing collaboration extensions like edit history.
5. Does Univer support custom formulas and plugin development? Yes, developers can create custom calculation functions for its formula engine and build entirely new plugins to extend or modify the behavior of sheets, docs, and other components, leveraging the published APIs and lifecycle hooks.