Microsoft Excel Automation Setup with Claude
Let's set up and test the Excel MCP server.
- Copy this command and run it in Claude:
Add excel mcp server credentials to the Claude config file:
uvx excel-mcp-server stdio
To verify, use the shortcut Command + ,
or Ctrl + ,
, or open Settings → Developer tab → Edit config, and check the file in a text editor. You should see the Excel MCP block added.
- Fully exit Claude (Mac:
Cmd + Q
, Windows:Alt + F4
); - Restart Claude;
Test the Excel MCP Server
Disable Desktop Commander MCP so that Claude uses Excel MCP specifically. The file with dataset will be attached because without Desktop Commander, Claude can't access local files.
- Open a new Claude chat and send this prompt:
Create a new excel workbook on my desktop. Build a pivot table
that groups the data by the product column and summarize the total
quantity and the total revenue for each product. Use the attached file.
Use only python libraries for analysis.
- Attach the CSV file;
- Run the prompt.
If Claude doesn't create the Excel file on the Desktop, clarify with:
Run the script, but don't create excel since I want to test new excel mcp
- When Claude asked for using Excel MCP AI agent, click Allow always or Allow once;
- If the file was not created in the previously requested folder, just clarify with the next prompt, for example:
Move the file onto Desktop
- Check the new file and practice prompting to enhance it.
Merci pour vos commentaires !
Demandez à l'IA
Demandez à l'IA
Posez n'importe quelle question ou essayez l'une des questions suggérées pour commencer notre discussion
What are the steps to set up the Excel MCP server?
How do I test if the Excel MCP server is running correctly?
Can you explain what the Excel MCP server does?
Awesome!
Completion rate improved to 8.33
Microsoft Excel Automation Setup with Claude
Glissez pour afficher le menu
Let's set up and test the Excel MCP server.
- Copy this command and run it in Claude:
Add excel mcp server credentials to the Claude config file:
uvx excel-mcp-server stdio
To verify, use the shortcut Command + ,
or Ctrl + ,
, or open Settings → Developer tab → Edit config, and check the file in a text editor. You should see the Excel MCP block added.
- Fully exit Claude (Mac:
Cmd + Q
, Windows:Alt + F4
); - Restart Claude;
Test the Excel MCP Server
Disable Desktop Commander MCP so that Claude uses Excel MCP specifically. The file with dataset will be attached because without Desktop Commander, Claude can't access local files.
- Open a new Claude chat and send this prompt:
Create a new excel workbook on my desktop. Build a pivot table
that groups the data by the product column and summarize the total
quantity and the total revenue for each product. Use the attached file.
Use only python libraries for analysis.
- Attach the CSV file;
- Run the prompt.
If Claude doesn't create the Excel file on the Desktop, clarify with:
Run the script, but don't create excel since I want to test new excel mcp
- When Claude asked for using Excel MCP AI agent, click Allow always or Allow once;
- If the file was not created in the previously requested folder, just clarify with the next prompt, for example:
Move the file onto Desktop
- Check the new file and practice prompting to enhance it.
Merci pour vos commentaires !