Univer

What is Univer about?

Univer provides an isomorphic full‑stack framework for building and editing spreadsheets, docs, and slides. It runs both in browsers and in Node.js, allowing seamless integration of spreadsheet functionality into any application and enabling AI‑native interaction through natural language.

How to use Univer?

1. Install the core package (and optional presets) via npm.
2. Import the Univer core or a preset facade in your code.
3. Initialize the engine with desired plugins (sheet, doc, slide, collaboration, etc.).
4. Embed the rendered canvas or use the provided React/Vue components.
5. For AI‑driven control, add the univer-mcp package and communicate with it using natural language prompts.

Key features of Univer

• Spreadsheet core: cells, rows, columns, formulas, pivot tables, charts, conditional formatting, data validation, filtering, sorting, comments, cross‑highlighting, Zen editor, import/export (XLSX), printing.
• Document core (rc): paragraphs, headings, lists, hyperlinks, floating images, headers/footers, comments, import/export (DOCX), printing.
• Slide core (future): slides, shapes, text, images.
• Isomorphic: same API works in browsers and Node.js.
• Embeddable: lightweight façade and presets for quick integration.
• Extensible plugin architecture for custom features.
• Theming & i18n with many built‑in locales.
• High‑performance rendering using canvas and Web‑Worker formula engine.
• Collaborative editing, version history, and real‑time syncing.

Use cases of Univer

• Building AI‑powered spreadsheet editors where users interact via natural language.
• Embedding spreadsheet or document editors inside SaaS platforms, dashboards, or internal tools.
• Creating data‑driven presentations that automatically update from sheet data.
• Developing real‑time collaborative office suites.
• Extending existing web applications with spreadsheet‑like data tables and calculations.

FAQ

Does Univer run on the server? Yes, it can be executed in Node.js for server‑side rendering or processing. What UI frameworks are supported? It provides vanilla JS APIs and wrappers for React, Vue, and other frameworks via community presets. How to add custom formulas? Register a formula plugin through the formula engine’s registerFunction API. Is there a free license? The core is open‑source under Apache‑2.0; some advanced features are available in a non‑OSS commercial edition. How to enable AI interaction? Install the univer-mcp package and send natural‑language prompts; the MCP server interprets them and calls Univer APIs accordingly.

An Isomorphic Full-Stack Framework for Creating and Editing Spreadsheets Across Web and Server. Extensible. High-performance. Embedded to your application.

English | 简体中文 | 日本語 | Español Official Site | Documentation | Online Playground | Blog

Use Univer Platform to drive Univer Spreadsheets with natural language and build AI-native spreadsheets.

https://github.com/user-attachments/assets/7429bd5f-d769-4057-9e67-353337531024

• 🌈 Highlights
• ✨ Features
  • 📊 Univer Sheet
  • 📝 Univer Doc
  • 📽️ Univer Slide
• 🌐 Internationalization
• 👾 Showcase
• 💬 Community
• 🤝 Contribution
• ❤️ Sponsor
• 📄 License

🌈 Highlights

• 📈 Univer is designed to support spreadsheets, documents and presentation.
• 🧙‍♀️ Univer is isomorphic. It can run both on browsers and Node.js (in the future, mobile devices as well), with the same API.
• ⚙️ Univer is easily embeddable, allowing seamless integration into your applications.
• 🎇 Univer is powerful, offering a wide range of features including formulas, conditional formatting, data validation, filtering, collaborative editing, printing, import & export and more features on the horizon.
• 🔌 Univer is highly extensible, thanks to its plug-in architecture that makes it a delight for developers to implement their unique requirements on the top of Univer.
• 💄 Univer is highly customizable, allowing you to personalize its appearance using themes. It also provides support for internationalization (i18n).
• 🥤 Univer is easy to work with. The Presets & Facade API make it easy to hands on.
• ⚡ Univer in performant.
  • ✏️ Univer boasts an efficient rendering engine based on canvas, capable of rendering various document types flawlessly. The rendering engines supports advanced typesetting features such as punctuation squeezing, text and image layout and scroll buffering.
  • 🧮 Univer incorporates a lightning-fast formula engine that can operate in Web Workers or even on the server side.
• 🌌 Univer is a highly integrated system. Documents, spreadsheets and slides can interoperate with each others and even rendered on the same canvas, allowing information and data flow within Univer.

✨ Features

Univer provides a wide range of features for spreadsheets, documents and presentations. Here are some of the key features:

📊 Univer Sheets

• Core Features: Univer supports core spreadsheet functionality, including cells, rows, columns, worksheets, and workbooks.
• Formulas: Extensive support for various formulas, including mathematical, statistical, logical, text, date and time, lookup and reference, engineering, financial, and information formulas.
• Permissions: Allows restricting access to specific elements.
• Number Formatting: Supports formatting numbers based on specific criteria.
• Hyperlinks: Enables linking to external websites, email addresses, and other locations within a spreadsheet.
• Floating Images: Allows inserting images into a spreadsheet and positioning them anywhere on the sheet.
• Find & Replace: Provides the ability to search for specific text within a spreadsheet and replace it with other text.
• Filtering: Allows filtering data based on specific criteria.
• Sorting: Allows sorting data based on specific criteria.
• Data Validation: Supports restricting the type of data that can be entered into a cell.
• Conditional Formatting: Supports applying formatting to cells based on specific criteria.
• Comments: Enables adding comments to cells to provide additional information.
• Cross-highlighting: Supports displaying cross-highlighting in spreadsheets to help users quickly locate selected cells.
• Zen Editor: Provides a distraction-free editing experience with a clean interface and minimal distractions.
• Pivot Tables¹: Supports pivot tables, allowing users to summarize and analyze data.
• Sparklines¹: Supports sparklines, which are small charts that fit within a cell to provide a visual representation of data.
• Printing¹: Allows printing a spreadsheet or exporting it to PDF.
• Import & Export¹: Support for importing and exporting data in XLSX.
• Charts¹: Supports various types of charts, including bar charts, line charts, pie charts, scatter plots, and more.
• Collaborative Editing¹: Supports multiple users editing a spreadsheet simultaneously. File history and recovering are also provided.
• Editing History¹: Allows users to view and restore previous versions of a spreadsheet.

📝 Univer Docs (rc)

• Core Features: Univer supports core document features, including paragraphs, headings, lists, superscript, subscript, and more.
• Lists: Supports ordered lists, unordered lists, and task lists.
• Hyperlinks: Supports inserting links to external websites, email addresses, and other locations within a document.
• Floating Images: Allows inserting images into a document and supporting text and image layout.
• Headers & Footers: Allows adding headers and footers to a document.
• Comments: Enables adding comments to a document to provide additional information.
• Printing¹: Allows printing a document or exporting it to PDF.
• Import & Export¹: Supports importing and exporting data in DOCX format.
• Collaborative Editing¹: Supports multiple users editing a document simultaneously.

📽️ Univer Slides (Under Development)

• Core Features: Univer will support core presentation features, including slides, shapes, text, images, and more.

🌐 Internationalization

Univer supports multiple languages, including:

• zh-CN
• zh-TW
• en-US
• ru-RU
• vi-VN
• fa-IR
• ja-JP
• ko-KR
• es-ES
• ca-ES

zh-CN and en-US are officially supported, while the others are contributed and maintained by the community.

You can add the language you want by Using Custom Locales. You can also help us add new language support by referring to the contribution guide.

👾 Showcase

Embed Univer in AI products as a data presentation tool.

You can find all the examples in the Univer Examples.

📊 Spreadsheets	📊 Multi-instance	📊 Uniscript
📊 Big data	📊 Collaboration	📊 Collaboration Playground
📊 Import & Export	📊 Printing	📝 Documents
📝 Multi-instance	📝 Uniscript	📝 Big data
📝 Collaboration	📝 Collaboration Playground	📽️ Presentations
📊 Zen Editor	Univer Workspace (SaaS version)

🔗 Links

• Latest Preview of the dev Branch
• Official Site
• Presets Repository

🔒 Security

Univer is committed to maintaining a secure codebase. We follow best practices for security and regularly update our dependencies. For more information, please refer to our Security Policy.

💬 Community

Univer is an inclusive and welcoming project. Please read our Code of Conduct before participating in the community.

Join the Univer community:

• Chat with us and other developers on Discord.
• Start a discussion on GitHub Discussions.
• Open a topic on Stack Overflow and tag it with univer.

You can also find Univer on:

Twitter | YouTube

🤝 Contribution

We appreciate any kinds of contributing. You can submit issues or feature requests to us. Please read our contributing guide first.

If you would like to contribute code to Univer, please refer to the contributing guide as well. It would guide you through the process of setting up the development environment and submitting a pull request.

❤️ Sponsors

The growth and development of the Univer project rely on the support of its backers and sponsors. If you are interested in supporting our project, we kindly invite you to consider becoming a sponsor. You can sponsor us through Open Collective.

Thanks to our sponsors, just part of them are listed here because of the space limit, ranking is no particular order:

📄 License

Copyright © 2021-2025 DreamNum Co,Ltd. All Rights Reserved.

Licensed under the Apache-2.0 license.

Footnotes

1. These features are provided by the non-OSS version of Univer, which is free for commercial use and also includes paid upgrade plans. ↩ ↩² ↩³ ↩⁴ ↩⁵ ↩⁶ ↩⁷ ↩⁸ ↩⁹ ↩¹⁰