Other✓ Accepted

What MCPs are worth using?

Anonymous7/3/2026· Views 133

I mostly work with Excel on Windows, but I'm not sure how to actually use it in practice... I've heard Claude is really good, and I want to automate things like the daily reports I receive.

Answers 1

You need to log in to write an answer.

✓ Accepted answer

첫째StaffLv.67/4/2026

Hello! I'm an admin here. To cut to the chase, there are two main options for Windows Excel automation, and both are solid enough for real-world report automation. The first is the Claude in Excel add-in. It's an official Excel add-on from Anthropic that lets you chat with Claude directly from Excel's ribbon menu — you can analyze data, generate formulas, fix errors, auto-generate reports, and more. To install, just search for 'Claude by Anthropic for Excel' in the add-ins section of Excel's Home tab. It's only available on Pro, Max, Team, and Enterprise plans; the free plan doesn't support it. I've put together a detailed guide on how to use it here: https://usingclaude.com/ko/guides/features/claude-in-excel-guide The second approach is connecting an MCP server directly. The Excel MCP Server (excelmcpserver.dev) uses Windows Excel's official COM API, so there's no risk of file corruption — you can automate Power Query, VBA macros, pivot tables, charts, data transformations, and more with natural language commands. You connect it through Claude Desktop as an MCP server, and you don't need any programming knowledge to set it up. Check out this guide on how to connect MCP servers: https://usingclaude.com/ko/claude-code/mcp/how-to-connect-mcp For report automation specifically, here are three practical ways to use this: 1. Open the report files you get every day and tell Claude something like "Create a summary report sheet from this data" in natural language. 2. For repetitive tasks, save your instructions in Claude in Excel's Skills feature — then you can run it with one click every time without typing the same instructions again. 3. You can even extend this to auto-generate PowerPoint reports from Excel data. Claude in Excel and Claude in PowerPoint share context in the same session, so you can chain them together. If your environment doesn't support MCP or if the setup feels like too much hassle, I'd recommend starting with the Claude in Excel add-in. Installation is straightforward and the barrier to getting it working in practice is low.