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.

60 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_addChanges dataCreate a new add. API summary: Invoke action add.
create_add_drives_drive_items_drive_item_workbook_tables_workbooChanges dataCreate a new add. API summary: Invoke action add.
create_add_drives_drive_items_drive_item_workbook_worksheets_worChanges dataCreate a new add. API summary: Invoke action add.
create_deleteChanges dataCreate a new delete. API summary: Invoke action delete.
create_insertChanges dataCreate a new insert. API summary: Invoke action insert.
create_new_navigation_property_to_names_for_drivesChanges dataCreate a new product. Search products first to avoid duplicates. API summary: Create new navigation property to names for drives.
create_productChanges dataCreate a new product for a product. Required: body. Search products first to avoid duplicates. API summary: Create new navigation property to children for drives.
create_tableChanges dataTurn a range into a table with `address` (e.g. Sheet1!A1:D1) and `has_headers`.
create_table_2Changes dataCreate a new table. Search tables first to avoid duplicates. API summary: Create new navigation property to tables for drives.
create_table_clear_filterChanges dataCreate a new clear filter for a table. API summary: Invoke action clearFilters.
create_table_columnChanges dataCreate a new column for a table. Search columns first to avoid duplicates. API summary: Create new navigation property to columns for drives.
create_table_convert_to_rangeChanges dataCreate a new convert to range for a table. API summary: Invoke action convertToRange.
create_table_reapply_filterChanges dataCreate a new reapply filter for a table. API summary: Invoke action reapplyFilters.
create_table_rowChanges dataCreate a new row for a table. Search rows first to avoid duplicates. API summary: Create new navigation property to rows for drives.
create_workbook_sessionChanges dataCreate a new workbook. API summary: Invoke action createSession.
create_worksheetChanges dataCreate a new worksheet. Search worksheets first to avoid duplicates. API summary: Create new navigation property to worksheets for drives.
create_worksheet_tableChanges dataCreate a new table for a worksheet. Search tables first to avoid duplicates. API summary: Create new navigation property to tables for drives.
delete_productDeletesPermanently delete a product by workbook named item id. Destructive action; may require approval. API summary: Delete navigation property names for drives.
delete_tableDeletesPermanently delete a table by workbook table id. Destructive action; may require approval. API summary: Delete navigation property tables for drives.
delete_table_columnDeletesPermanently delete a column by workbook table column id. Destructive action; may require approval. API summary: Delete navigation property columns for drives.
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_names_from_drivesSearch products by search, filter, count, orderby, select or expand. Use this to find existing products before creating a new product. Results are paginated. API summary: Get names from drives.
get_product_drives_items_workbook_get_namesGet one product by workbook named item id. API summary: Get names from drives.
get_rangeRead a range such as A1:D20 on a worksheet by `address`, with values, formulas, text and number formats.
get_tableGet one table by workbook table id. API summary: Get tables from drives.
get_table_columnGet one column for a table by workbook table column id. API summary: Get columns from drives.
get_table_headersRead the header row of a table by `workbook_table_id`, to see the column names.
get_table_rowGet one row for a table by workbook table row id. API summary: Get rows from drives.
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.
get_worksheetGet one worksheet by workbook worksheet id. API summary: Get worksheets from drives.
list_folder_itemsList the files and folders inside a folder by `drive_item_id`.
list_item_at_indicesList item at indices. API summary: Invoke function itemAt.
list_product_workbooksList workbooks for a product. Optional filters: select or expand. API summary: Get workbook from drives.
list_table_columnsList the columns of a table by `workbook_table_id`, with names and values.
list_table_data_body_rangesList data body ranges for a table. API summary: Invoke function dataBodyRange.
list_table_rangesList ranges for a table. API summary: Invoke function range.
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_worksheet_cell_row_columnsList cell row columns for a worksheet. API summary: Invoke function cell.
list_worksheet_used_range_values_onliesList used range values onlies for a worksheet. API summary: Invoke function usedRange.
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.
search_worksheet_tablesSearch tables for a worksheet by search, filter, count, orderby, select or expand. Use this to find existing tables before creating a new table. Results are paginated. API summary: Get tables from drives.
sort_tableChanges dataSort a table by one or more columns with `fields`, e.g. [{"key":0,"ascending":false}].
submit_workbook_sessionVisible to othersClose a workbook (drive item id). Has effects visible outside this system. API summary: Invoke action closeSession.
submit_workbook_session_refreshVisible to othersRefresh a workbook (drive item id). Has effects visible outside this system. API summary: Invoke action refreshSession.
update_productChanges dataUpdate an existing product identified by drive item id. Only the fields you pass are changed. API summary: Update the navigation property items in drives.
update_tableChanges dataUpdate an existing table identified by workbook table id. Only the fields you pass are changed. API summary: Update the navigation property tables in drives.
update_table_columnChanges dataUpdate an existing column identified by workbook table column id. Only the fields you pass are changed. API summary: Update the navigation property columns in drives.
update_table_rowChanges dataReplace the values of one table row by `workbook_table_row_id` (its index) with a 2D `values` array.
update_the_navigation_property_names_in_drivesChanges dataUpdate an existing product identified by workbook named item id. Only the fields you pass are changed. API summary: Update the navigation property names in drives.
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 HeyMyApps 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://heymyapps.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 HeyMyApps 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 HeyMyApps Pro plan or above. HeyMyApps 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.