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

In practice

What your team can do with Excel in Claude and ChatGPT

Finance

The right sheet, not the whole file

The budget workbook has twelve sheets. Ask about the Forecast sheet, or one range of it, and get the rows behind the answer, ready to compare with plan before the monthly review.
Operations

A new row in one sentence

Say what happened, a delivery, a site visit, hours on a project, and the AI adds a row to the right table once you have confirmed it. Nothing above it is touched.
Sales

Answers from the order table

Which customers ordered less this quarter than last, and which orders are still open? Read straight from the table instead of building a pivot by hand.
Management

The workbook you cannot find

Somebody made a headcount plan in the spring. Search by a word in the name or the content, and get the file, who made it and when it last changed.
Examples

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?”

The connector

What the Excel MCP connector does today

  • Readsexcel_search_workbooks

    Finds 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.

  • Readsexcel_list_worksheets

    Lists a workbook’s worksheets in their order, and whether each one is visible or hidden.

  • Readsexcel_read_range

    Reads 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.

  • Readsexcel_list_tables

    Lists the named tables in a workbook, or on one of its worksheets, so the right one can be read.

  • Readsexcel_read_table

    Reads a table’s column names and its rows as values, a batch of rows at a time, and continues further down when you ask.

  • Writesexcel_add_table_rows

    Adds 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.

Security

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.
Setup

Set up the Excel connector in three steps

01
An admin switches on Excel in Deployed OS and chooses which groups get it.
02
The admin decides what the AI may do there: what it may read, what it may write, and which actions ask the person first.
03
Each person connects their own Microsoft work account. From then on they just ask, in Claude, ChatGPT or Copilot.
Questions

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.

More connectorsAll connectors
Let’s talk

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.