Univer MCP
AI-powered spreadsheet automation through Model Context Protocol (MCP) server for Univer
What is Univer MCP?
Univer MCP is a Model Context Protocol (MCP) server that allows AI assistants like Claude, Cursor, and VS Code to ai-powered spreadsheet automation through model context protocol (mcp) server for univer
AI-powered spreadsheet automation through Model Context Protocol (MCP) server for Univer
This server falls under the Business Applications category on MCPgee, the world's largest MCP server directory with 33,000+ servers.
Features
- AI-powered spreadsheet automation through Model Context Prot
Use Cases
Maintainer
Works with
Installation
Manual Installation
npx univerConfiguration
Configuration Details
claude_desktop_config.json
Performance
Response Metrics
Resource Usage
How to Set Up and Use Univer MCP
The Univer MCP Server enables AI-powered spreadsheet automation by connecting MCP-compatible AI assistants to the Univer cloud spreadsheet platform via a hosted HTTP MCP endpoint. It exposes tools for creating, editing, and manipulating spreadsheets including formula support, conditional formatting, data validation, and chart creation, allowing users to describe spreadsheet operations in natural language and have AI execute them. Developers and data workers use it to automate repetitive spreadsheet tasks, build data pipelines, or populate reports without writing formulas or macros manually.
Prerequisites
- A Univer account at console.univer.ai with an API key generated
- A running Univer spreadsheet instance (launched via the Univer Playground or Start-kit)
- A multimodal AI model configured in your MCP client (required since tools return images for visual feedback)
- An MCP-compatible client such as Claude Desktop, Cursor, or Gemini CLI
Create a Univer account and obtain an API key
Sign up at console.univer.ai, then navigate to the API Keys section to generate a new API key. This key authenticates the MCP server connection.
Launch a Univer spreadsheet instance
Before connecting the MCP server, you need an active Univer spreadsheet open. Launch one from the Univer Playground at univer.ai or set up a local instance using the Univer Start-kit.
Configure your MCP client
Add the Univer MCP server to your client configuration. The server is hosted at https://mcp.univer.ai/mcp/ and accessed via HTTP transport with your API key as a Bearer token.
{
"mcpServers": {
"univer": {
"url": "https://mcp.univer.ai/mcp/?univer_session_id=default",
"type": "http",
"headers": {
"Authorization": "Bearer YOUR_UNIVER_API_KEY"
}
}
}
}Add via Claude Code CLI (alternative)
If you use Claude Code CLI, you can add the server with a single command.
claude mcp add --transport http univer-mcp https://mcp.univer.ai/mcp/ -H 'Authorization: Bearer YOUR_UNIVER_API_KEY'Verify the connection with a test prompt
Ask the AI to create a simple spreadsheet or insert data into a cell. The tool will return an image preview showing the current spreadsheet state to confirm everything is working.
Univer MCP Examples
Client configuration
Claude Desktop configuration for the Univer MCP server using HTTP transport and Bearer token authentication.
{
"mcpServers": {
"univer": {
"url": "https://mcp.univer.ai/mcp/?univer_session_id=default",
"type": "http",
"headers": {
"Authorization": "Bearer your_univer_api_key_here"
}
}
}
}Prompts to try
Example natural language prompts for spreadsheet automation with Univer MCP.
- "Create a monthly budget spreadsheet with categories for rent, food, utilities, and entertainment"
- "Insert a SUM formula in cell B10 that totals the values in B2 through B9"
- "Apply conditional formatting to highlight all cells in column C that are greater than 1000 in red"
- "Add a data validation rule to column A that only accepts dates in 2025"
- "Create a pivot table summarizing sales by region from the data in sheet 1"Troubleshooting Univer MCP
Connection fails or returns 401 Unauthorized
Verify your Univer API key is correct and has not expired. Regenerate it at console.univer.ai/apikeys and update the Authorization header in your configuration.
Tools return images but the AI cannot process them
The Univer MCP server returns visual feedback as images. Ensure your MCP client is configured with a multimodal model capable of processing images (e.g., Claude 3.5 Sonnet or higher). Text-only models will not be able to interpret the tool responses.
Spreadsheet operations fail with 'no active session' errors
You must have an active Univer spreadsheet instance open before sending commands. Launch a spreadsheet in the Univer Playground or via your Start-kit, then retry. The univer_session_id query parameter in the URL must match your open session.
Frequently Asked Questions about Univer MCP
What is Univer MCP?
Univer MCP is a Model Context Protocol (MCP) server that ai-powered spreadsheet automation through model context protocol (mcp) server for univer It connects AI assistants to external tools and data sources through a standardized interface.
How do I install Univer MCP?
Follow the installation instructions on the Univer MCP GitHub repository. Clone the repo, install dependencies, and add the server config to your AI client.
Which AI clients work with Univer MCP?
Univer MCP works with all major MCP-compatible AI clients including Claude Desktop, Claude Code, Cursor, VS Code (GitHub Copilot), Windsurf, and Cline.
Is Univer MCP free to use?
Yes, Univer MCP is open source and available under the MIT license. You can use it freely in both personal and commercial projects.
Univer MCP Alternatives — Similar Business Applications Servers
Looking for alternatives to Univer MCP? Here are other popular business applications servers you can use with Claude, Cursor, and VS Code.
n8n
★ 189.1kA comprehensive MCP server that provides full control over n8n automation workflows through natural language. It offers 43 tools for managing workflows, executions, credentials, and data tables, with safety features like write-mode protection and dou
LobeHub
★ 77.5k🤯 LobeHub is your Chief Agent Operator, organizing your agents into 7×24 operations by hiring, scheduling, and reporting on your entire AI team.
Jeecgboot
★ 46.4kAI 低代码平台，「低代码 + 零代码」双模式驱动：低代码一键生成前后端代码，零代码 5 分钟搭建系统，AI Skills 一句话画流程、设计表单、生成整套系统。内置 AI聊天、知识库、流程编排、MCP插件等，兼容主流大模型。引领「AI 生成 → 在线配置 → 代码生成 → 手工合并->AI修改」开发模式，消除 Java 项目 80% 的重复工作，提效而不失灵活。
CowAgent
★ 44.7kCowAgent (chatgpt-on-wechat) 是基于大模型的超级AI助理，能主动思考和任务规划、访问操作系统和外部资源、创造和执行Skills、通过长期记忆和知识库不断成长，比OpenClaw更轻量和便捷。同时支持微信、飞书、钉钉、企微、QQ、公众号、网页等接入，可选择DeepSeek/OpenAI/Claude/Gemini/ MiniMax/Qwen/GLM/LinkAI，能处理文本、语音、图片和文件，可快速搭建个人AI助理和企业数字员工。
Minds Platform
★ 39.2kPlatform dedicated to building an open foundation for applied Artificial Intelligence, designed for people seeking production-ready AI systems they can truly control, extend and deploy anywhere.
Astrbot
★ 32.8kAI Agent Assistant & development framework that integrates lots of IM platforms, LLMs, plugins and AI feature, and can be your openclaw alternative. ✨
Browse More Business Applications MCP Servers
Explore all business applications servers available in the MCPgee directory. Each server includes setup guides for Claude, Cursor, and VS Code.
Set Up Univer MCP in Your Editor
Choose your AI client for step-by-step setup instructions.
Quick Config Preview
Add this to your claude_desktop_config.json or .cursor/mcp.json
Ready to use Univer MCP?
Browse our complete directory of 33,000+ MCP servers, read setup guides for your editor, and start building with the Model Context Protocol.