Integration · Productivity

Connect Claude & ChatGPT to Microsoft Excel

Ask your AI to find a workbook in your OneDrive, read what is in it, or update it for you. It reads whole worksheets or specific ranges, lists tables and their rows, and writes values, formulas and number formats into cells. It can also add, update and delete table rows, create tables and worksheets, sort tables and recalculate the workbook.

Connect Microsoft Excel free

Free plan, no credit card. Takes about a minute.

Try asking

“Find the budget 2026 workbook and tell me the total in column F.”
The AI searches OneDrive for the file, reads the worksheet and adds up the column.
“Add a row to the Leads table: Nordic Foods, Anna Berg, 45000.”
It appends the row to the end of the table in the right column order.
“What are the column names in the Orders table?”
It reads the table's header row and lists the columns.

What your AI can do

Find workbooks

Search OneDrive by name or content, browse folders and get file details and IDs.

Read and write ranges

Read used ranges or specific addresses and write values, formulas and number formats.

Tables and sheets

List, add, update and delete table rows, create and sort tables, and add, rename or delete worksheets.

“Put this week's figures into Sheet1 A2 to C8.”
It writes the values into that range, replacing what was there.
“Sort the Projects table by deadline, newest first.”
It applies a sort on the deadline column of the table.
“Add a new sheet called Q4 summary.”
It adds a worksheet with that name to the workbook.

22 tools for Microsoft Excel

These tools are switched on when you connect. You can switch any of them off, or require your approval before it runs.

add_table_rowsChanges dataAppend one or more rows to a table with `values` as a 2D array, one inner array per row in column order. Optional `index` inserts at a position.
add_worksheetChanges dataAdd a new worksheet to a workbook with an optional `name`.
clear_rangeChanges dataClear a range by `address`: contents, formats or all. The cleared data cannot be restored through the API.
create_tableChanges dataTurn a range into a table with `address` (e.g. Sheet1!A1:D1) and `has_headers`.
delete_table_rowDeletesDelete a table row by `workbook_table_row_id` (its index); rows below move up.
delete_worksheetDeletesDelete a worksheet and all its data by `workbook_worksheet_id`. This cannot be undone through the API.
get_drive_rootGet the root folder of the user's OneDrive, including its ID for browsing folders.
get_fileGet a file's details by `drive_item_id`: name, size, web link and last modified time.
get_rangeRead a range such as A1:D20 on a worksheet by `address`, with values, formulas, text and number formats.
get_table_headersRead the header row of a table by `workbook_table_id`, to see the column names.
get_used_rangeGet all cells on a worksheet that are in use, by `workbook_worksheet_id`, with the address, values, formulas and text. A quick way to read a whole sheet.
list_folder_itemsList the files and folders inside a folder by `drive_item_id`.
list_table_columnsList the columns of a table by `workbook_table_id`, with names and values.
list_table_rowsList the rows of a table by `workbook_table_id`, each with its index and values.
list_tablesList the tables in a workbook by `drive_item_id`, with names, IDs and settings.
list_worksheetsList the worksheets in a workbook by `drive_item_id`, with their names, IDs and positions.
recalculate_workbookVisible to othersRecalculate all formulas in the workbook, with `calculation_type` Recalculate, Full or FullRebuild.
search_filesSearch the user's OneDrive for files by name or content with `q`, e.g. budget 2026. Returns each file's ID, which the other Excel tools need as drive_item_id.
sort_tableChanges dataSort a table by one or more columns with `fields`, e.g. [{"key":0,"ascending":false}].
update_table_rowChanges dataReplace the values of one table row by `workbook_table_row_id` (its index) with a 2D `values` array.
update_worksheetChanges dataRename, reorder or hide a worksheet by `workbook_worksheet_id` (name, position, visibility).
write_rangeVisible to othersWrite `values`, `formulas` or `number_format` into a range such as A2:C4 on a worksheet. Pass a 2D array matching the range size. Overwrites existing cell contents.

Set up in three steps

1
Pick the app
Create a free PipMCP account and choose Microsoft Excel from the app list.
2
Paste your key
Paste the Application (client) ID and client secret value from your own Microsoft Entra app registration, then sign in with Microsoft once. In the Microsoft Entra admin center open App registrations > New registration, choose the account types you need and add the Web redirect URI https://pipmcp.com/oauth/callback. Under Certificates & secrets create a new client secret and copy its Value. Under API permissions add the delegated Microsoft Graph permissions Files.ReadWrite.
3
Add the link to your AI
You get a personal MCP link. Add it to Claude, ChatGPT or Cursor:
1. Click your name, then Settings › Connectors › Add custom connector.
2. Paste your link as the Remote MCP server URL.
3. Switch it on from the + menu in a chat.

Questions

What can the AI do in Microsoft Excel?

It can search OneDrive, browse folders and get file details. In a workbook it can list, add, rename and delete worksheets, read the used range or any range, write values and formulas, clear ranges, list and create tables, read headers, columns and rows, add, update and delete rows, sort tables and recalculate the workbook.

Does the AI see my Microsoft Excel credentials?

No. Your client secret and the access from your Microsoft sign-in are encrypted at rest and never shown to the AI. After you save them, they are not shown again, not even to you. The AI only sees the results of the tools it calls.

Can I control what the AI is allowed to do?

Yes. You choose which tools are switched on, so you can start with reading only. Writing to a range overwrites cells, and deleting a worksheet or row removes its data, so those tools can require your approval before they run. Every tool call is logged.

Does it work with ChatGPT?

Yes. In ChatGPT go to Settings › Apps & Connectors › Advanced and turn on Developer mode, then add your PipMCP link. Developer mode needs a paid ChatGPT plan: Plus, Pro, Business or Enterprise. The same link also works in Claude (Settings › Connectors › Add custom connector), Cursor and other MCP clients.

What does it cost?

Microsoft Excel connects with OAuth, and OAuth connections need the PipMCP Pro plan or above. PipMCP also has a free plan with no credit card, but it does not include this connection. Paid plans bill per completed task. You also need your own Microsoft account with OneDrive.

Which workbooks can the AI open?

Excel workbooks (.xlsx) stored in your own OneDrive. Microsoft documents the workbook API for OneDrive for Business, SharePoint and group drives, so files in a personal OneDrive may not support every action. The AI finds a file by searching, then uses its ID for the other tools.