Excel MCP
Excel MCP: ask Claude or ChatGPT about your Excel files.
ExcelYour data
- MammothCleans and calculates
Your AI assistantClaude, ChatGPT, VS Code
Your two options
Two ways to connect Excel to your AI assistant
Mammoth answers questions about Excel and your other data. Other Excel MCP servers query Excel directly.
Mammoth
Ask about Excel and your other data. Mammoth calculates the answer, so the numbers are exact. Included on every plan.
“How much did each region sell this quarter?”
Other Excel MCP servers
Reads and edits workbook files directly. You install and run it on your own computer.
“Add a total row to the Sales sheet.”
Option 1 · Mammoth
What you can ask about your Excel files
Pick a question to see what your assistant gets back.
| Region | Sales ($) |
|---|---|
| North | 1,284,500 |
| South | 962,310 |
| East | 811,040 |
| West | 744,980 |
Shown on sample data. Your questions run on your own data.
More questions, by team
Pick your team, then copy a question into Claude or ChatGPT.
- TotalHow much did we spend in each category each month?
- CountHow many invoices did we raise each month this year?
- AverageWhat's the average expense per employee by department?
- TopWhich suppliers did we pay the most this quarter?
- TotalHow much did each rep sell last quarter?
- CountHow many deals closed in each region this month?
- AverageWhat's the average deal size by product?
- TopWhich customers bought the most this year?
- CountHow many units did each site produce last week?
- CountHow many orders did each store take each day?
- AverageWhat's the average stock level by warehouse?
- TopWhich products sold the most units this month?
Copy a question and paste it into your assistant once Mammoth is connected.
Ask about Excel and your other data together
Connect Excel and any of Mammoth’s 100+ other sources, like QuickBooks, Jira or Salesforce. Join them once in Mammoth, and your assistant can answer questions that cover all of them.
See all 100+ sourcesExample: Excel with QuickBooks
How does our actual spend in QuickBooks compare with the budget in our Excel file?
Your workbook holds the budget and QuickBooks holds the actual spend. Mammoth matches them on the category and month.
Option 1 · Mammoth
Set up Excel with Mammoth in three steps
- Step 1
Connect Excel to Mammoth
Upload your Excel files to Mammoth, or connect the folder they're in, like OneDrive or SharePoint. Then pick the sheets you want.
https://mcp.mammoth.io/mcpStep 2Add Mammoth to your assistant
Paste this address into Claude, ChatGPT or VS Code, then sign in with your Mammoth account.
- Step 3
Ask your question
Ask in Claude or ChatGPT, in plain words. Mammoth works out the numbers and your assistant replies with the answer.
What Mammoth reads from Excel
You upload Excel files to Mammoth, or connect the folder they're in, like OneDrive or SharePoint. Mammoth reads each sheet as a table, and you pick the sheets you want.
Step-by-step setup for each assistant is in our MCP docs.
Option 2 · Other servers
How other Excel MCP servers are set up
The Excel MCP servers people use are community projects. You install them on your own computer, and they read and edit workbook files there.
- Step 1
Pick a server
Choose a community Excel MCP server and install it with its command.
- Step 2
Point it at your files
Tell it which folder your workbooks are in.
- Step 3
Ask your assistant
It reads and edits the files on your computer.
Common questions about Excel MCP
What other Excel MCP servers are there?
Do I need Excel installed?
How does my assistant get to my Excel data?
Are the numbers right?
Which AI assistants work with it?
What does it cost?
Do I paste a password or API key into the chat?
Can my assistant change things by mistake?
Ask your AI assistant about your Excel files.
Start free, connect Excel, and add Mammoth to Claude or ChatGPT.
- ✓ 14-day Pro trial
- ✓ No credit card
- ✓ Viewers always free