Excel MCP: connect Excel to Claude and ChatGPT
Ask Claude or ChatGPT which cost lines in the 2027 budget are over plan, what the order table says about late deliveries, or to add this week’s hours to the project time log. The AI finds the workbook in OneDrive or SharePoint, reads the exact sheet, range or table, and gives you the link.
With Deployed OS everyone connects their own Microsoft work account. The AI reads the workbooks that person can already open. With Edit access it adds rows at the end of a table, after they confirm the rows. No existing cell is ever changed.
5 read actions · 1 write action · Works in Claude, ChatGPT and Copilot
What your team can do with Excel in Claude and ChatGPT
The right sheet, not the whole file
A new row in one sentence
Answers from the order table
The workbook you cannot find
Ask it like this
“Find the 2027 budget workbook and tell me which sheets it has.”
“Read Forecast!A1:H60 in the sales forecast and tell me which regions are below target.”
“Which tables are in the order book, and how many columns does the Orders table have?”
“In the Orders table, which orders for Brightwell Logistics are still open?”
“Add a row to the time log table: 3 October, Harlow Construction, workshop prep, 2.5 hours.”
“In the stock list, which items have fewer than 20 left?”
What the Excel MCP connector does today
- Reads
excel_search_workbooksFinds the Excel workbooks (.xlsx) you can open in OneDrive and SharePoint, by words in the name or content. Returns name, last change, who made it and link for each.
- Reads
excel_list_worksheetsLists a workbook’s worksheets in their order, and whether each one is visible or hidden.
- Reads
excel_read_rangeReads the cells of one worksheet, as values and as the text Excel shows: a range such as A1:D50, or the used part of the sheet when no range is given.
- Reads
excel_list_tablesLists the named tables in a workbook, or on one of its worksheets, so the right one can be read.
- Reads
excel_read_tableReads a table’s column names and its rows as values, a batch of rows at a time, and continues further down when you ask.
- Writes
excel_add_table_rowsAdds rows at the end of a table in a workbook you may edit, once you have confirmed the rows. Values are stored as text and numbers, never as formulas, nothing is overwritten and nobody is notified.
Need it to do more? We extend connectors for the companies that use them.
Who sees what
- Reads, plus new table rows
- The connector finds workbooks by name or content, lists their sheets and tables and reads cells, ranges and tables. With Edit it can add rows at the end of a table. It cannot change or delete existing cells, sheets or files, and it never writes formulas.
- Each person’s own rights
- Everyone connects their own Microsoft work account, so the AI reads what that person can open and adds rows only where they may edit. The salary workbook shared with HR stays with HR.
- Writing only with Edit access
- Admins choose which groups get Excel, and only groups with Edit access can add rows. Each write is done as the person asking, after they confirm the rows, and nobody is notified.
- Every call logged
- Who read which range, who added which rows, when. Deployed OS shows reads and writes per connector and per person, the log can be exported, and access is revoked centrally the day someone leaves.
Set up the Excel connector in three steps
Excel MCP: common questions
Your admin sets up Excel in Deployed OS once. You add your company’s Deployed OS connection in Claude, connect your own Microsoft work account and start asking. The same connection works in ChatGPT and Copilot.
No. With Edit access it can add rows at the end of a table, when you ask and confirm the rows. It never changes or deletes existing cells, sheets or files, and values are stored as text and numbers, so a cell starting with = stays text rather than becoming a formula. If you want it to do more, for example update a cell, we can extend it for you.
The SharePoint and OneDrive connector finds files of every kind and reads a workbook as plain text, read-only. The Excel connector lists the sheets and tables, reads the exact range or table you ask for, and with Edit access adds rows to a table. You can turn on both.
Only the ones they can already open in OneDrive and SharePoint. The AI uses each person’s own Microsoft work account, so your sharing settings apply as they are.
Deployed is an EU company and fully GDPR compliant, and you choose where your data is stored, down to the city. On-premises is possible too. Workbooks are fetched from Microsoft 365 when someone asks for them.
It depends on the size of your team. Get in touch and we will walk you through it.
See it on your own tools.
Tell us which systems your company runs on. We’ll show you what your team can ask, and what IT gets to control.