# How to connect Microsoft Excel to Hermes Agent (no API keys) > Connect Microsoft Excel to Hermes with ClawLink in one click — 54 tools your AI agent can call from chat via hosted OAuth. No API keys, no manual setup. Web version: https://claw-link.dev/hermes/microsoft-excel Most guides for giving Hermes Agent Microsoft Excel access start with registering your own OAuth app or pasting API keys into env files, then leave the token refresh and tool wiring to you. ClawLink gives Hermes a more practical Microsoft Excel setup: pair once in the browser and your always-on Hermes agent can act on Microsoft Excel for you, reading and doing real work on your behalf with no auth, token refresh, or tool wiring to build yourself. **Start here — paste this into Hermes to set up ClawLink:** > Set up ClawLink for Hermes and tell me when it's ready. > 1. Install the plugin: `hermes plugins install ClawLink-HQ/hermes-plugin --enable` > 2. Start pairing with `hermes clawlink begin`. It prints an approval link, so show me the link and stop, don't wait. > 3. I'll approve it in my browser, then reply "approved". > 4. When I say approved, finish setup: `hermes clawlink finish` > 5. Then run `hermes clawlink test` and tell me whether ClawLink is ready. ## Setup It takes three steps to connect Hermes to Microsoft Excel. 1. **Install ClawLink** — add the plugin to Hermes Agent once. 2. **Connect Microsoft Excel** — one-click OAuth in the ClawLink dashboard. 3. **Use it from chat** — ask Hermes Agent in plain English. **Alternative for any agent (no plugin needed):** if the Hermes Agent plugin route isn't available or doesn't work, any AI agent with shell access can use the ClawLink CLI instead: ```bash npx -y @useclawlink/cli login # sign in via browser — no API key to paste npx -y @useclawlink/cli connect microsoft-excel # connect Microsoft Excel (browser OAuth) npx -y @useclawlink/cli actions microsoft-excel # list available actions npx -y @useclawlink/cli run microsoft-excel --input '' # execute (add --confirm for writes) ``` ### Install by command The prompt above walks Hermes through this. By hand, it is four commands and a browser approval: ```bash hermes plugins install ClawLink-HQ/hermes-plugin --enable hermes clawlink begin # prints an approval link — open it and approve hermes clawlink finish # after approving in the browser hermes clawlink test ``` Then connect Microsoft Excel in the [ClawLink dashboard](https://claw-link.dev/dashboard) — a one-click OAuth approval, no API keys. Verify the connection by asking Hermes: > Use Microsoft Excel to excel add chart and walk me through the result in plain English. ### Using a different agent? The Hermes plugin is one client of ClawLink's MCP server. Claude Code, Cursor, Codex, or any agent that can run a shell command pairs with the same ClawLink account through the CLI: ```bash npx -y @useclawlink/cli login ``` `login` opens the same browser approval and stores a credential locally. Once Microsoft Excel is connected in the dashboard, that agent calls the same 54 Microsoft Excel tools over MCP. Full setup for MCP clients and shell agents: [connect apps to any AI agent](https://claw-link.dev/learn/connect-apps-to-any-ai-agent). ## Microsoft Excel MCP for Hermes Looking for a Microsoft Excel MCP server for Hermes Agent? ClawLink connects Microsoft Excel to Hermes Agent and exposes 54 Microsoft Excel tools your agent can call over [MCP](https://claw-link.dev/learn/what-is-an-mcp-server), with [hosted auth](https://claw-link.dev/learn/oauth-for-ai-agents) and nothing to run or maintain yourself. Using OpenClaw instead? The [OpenClaw Microsoft Excel integration](https://claw-link.dev/openclaw/microsoft-excel) works the same way. ## What the Hermes Agent Microsoft Excel integration can do 54 Microsoft Excel tools are ready for Hermes Agent once the account is connected. The 30 below are the ones people reach for most; your agent can call all 54. ### 30 of 54 Microsoft Excel tools for Hermes | Tool | What it does | |---|---| | **Excel add chart** `excel_add_chart` | Add a chart to a worksheet using Microsoft Graph API. | | **Excel add sharepoint worksheet** `excel_add_sharepoint_worksheet` | Add a new worksheet to a SharePoint Excel workbook using Microsoft Graph Sites API. | | **Excel add table** `excel_add_table` | Create a new table in a worksheet using the Microsoft Graph API. | | **Excel add table column** `excel_add_table_column` | Add a column to a table using Microsoft Graph API. | | **Excel add table row** `excel_add_table_row` | Add a row to a table using Microsoft Graph API. | | **Excel add workbook permission** `excel_add_workbook_permission` | Tool to grant access to a workbook via invite. Use when you need to share a specific workbook file with designated recipients and roles. | | **Excel add worksheet** `excel_add_worksheet` | Add a new worksheet to an Excel workbook using Microsoft Graph API. | | **Excel apply table filter** `excel_apply_table_filter` | Apply a filter to a table column using Microsoft Graph API. | | **Excel apply table sort** `excel_apply_table_sort` | Apply a sort to a table using Microsoft Graph API. | | **Excel clear range** `excel_clear_range` | Tool to clear values, formats, or contents in a specified worksheet range. Use when you need to reset cells before adding new data. | | **Excel clear table filter** `excel_clear_table_filter` | Clear a filter from a table column using Microsoft Graph API. | | **Excel close session** `excel_close_session` | Tool to close an existing Excel workbook session. Use when you need to explicitly end a persistent session to release workbook locks. | | **Excel get chart axis** `excel_get_chart_axis` | Retrieve a specific axis from a chart | | **Excel get chart data labels** `excel_get_chart_data_labels` | Retrieve the data labels object of a chart | | **Excel get chart legend** `excel_get_chart_legend` | Retrieve the legend object of a chart | | **Excel get range** `excel_get_range` | Get a range from a worksheet using Microsoft Graph API | | **Excel get sharepoint range** `excel_get_sharepoint_range` | Get a range from a worksheet in SharePoint using Microsoft Graph Sites API | | **Excel get sharepoint worksheet** `excel_get_sharepoint_worksheet` | Get a worksheet by name or ID from a SharePoint Excel workbook using Microsoft Graph Sites API | | **Excel get table column** `excel_get_table_column` | Retrieve a specific column from a workbook table | | **Excel get workbook** `excel_get_workbook` | Retrieve the properties and relationships of a workbook | | **Excel get worksheet** `excel_get_worksheet` | Get a worksheet by name or ID from an Excel workbook using Microsoft Graph API | | **Excel get worksheet used range** `excel_get_worksheet_used_range` | Retrieve a worksheet's used range (active data region) without specifying a fixed range address | | **Excel list chart series** `excel_list_chart_series` | List all data series in a chart | | **Excel list charts** `excel_list_charts` | List charts in a worksheet using Microsoft Graph API | | **Excel list comments** `excel_list_comments` | List comments in an Excel workbook | | **Excel list drive item children** `excel_list_drive_item_children` | List immediate children (files/folders) of a folder DriveItem using driveId and itemId | | **Excel list files** `excel_list_files` | List files and folders in a drive root or specified path | | **Excel list named items** `excel_list_named_items` | List named items in a workbook using Microsoft Graph API | | **Excel list sharepoint tables** `excel_list_sharepoint_tables` | List tables in a SharePoint worksheet using Microsoft Graph Sites API | | **Excel list sharepoint worksheets** `excel_list_sharepoint_worksheets` | List worksheets in an Excel workbook stored in SharePoint using Microsoft Graph Sites API | ## Example prompts **Excel Add Chart** > Use Microsoft Excel to excel add chart and walk me through the result in plain English. **Excel Add Sharepoint Worksheet** > Use Microsoft Excel to excel add sharepoint worksheet and walk me through the result in plain English. **Excel Add Table** > Use Microsoft Excel to excel add table and walk me through the result in plain English. **Excel Add Table Column** > Use Microsoft Excel to excel add table column and walk me through the result in plain English. ## ClawLink vs. building it yourself The alternative to ClawLink is usually manual OAuth app setup plus your own token handling, permission troubleshooting, and tool plumbing for Hermes Agent. That is fine if you want to build and maintain the integration yourself. Most teams just want Microsoft Excel working from chat. | | Manual | ClawLink | |---|---|---| | **Connection flow** | Register a Microsoft Excel app, configure redirect URLs, manage consent details, and reconnect users when auth settings drift. | Users connect Microsoft Excel through the hosted browser flow and ClawLink keeps the token lifecycle out of your app code. | | **Ongoing maintenance** | You own refresh logic, permission debugging, environment config, and every provider-specific edge case for Microsoft Excel. | ClawLink handles the repetitive integration plumbing so your team can focus on the workflow instead of the infrastructure. | | **Agent usability** | You still need to expose the right Microsoft Excel actions to the runtime in a format your agent can reliably use. | 54 tools for Microsoft Excel are already exposed through ClawLink, so the agent can read and act from chat immediately. | ## ClawLink vs. Composio Composio also exposes Microsoft Excel to AI agents. It is developer infrastructure: Python and TypeScript SDKs, an MCP server, and a catalog past 1,000 apps, aimed at teams shipping agent products. ClawLink is built for Hermes Agent users instead. You install the plugin once, connect Microsoft Excel in the browser, and the 54 tools above work from chat. There is no SDK, no config file, and no API key handling. Choosing between them? Read the full [Composio alternatives](https://claw-link.dev/hub/composio-alternatives) comparison. ### Hermes paired but still can't use Microsoft Excel Pairing is a two-step handshake: run `hermes clawlink begin`, approve the link in your browser, then run `hermes clawlink finish`. If you ran finish before approving, or the approval link expired, run `hermes clawlink begin` again to get a fresh link. Confirm the plugin was installed with `--enable`, then verify with `hermes clawlink test`. ### Connection succeeds but no tools appear Reconnect Microsoft Excel from the dashboard, then start a fresh chat if the runtime still has the old tool catalog loaded. ### "Tool schema not loaded yet" error when calling Microsoft Excel tools Microsoft Excel tool schemas load on demand the first time a tool runs and are cached after that, so this error usually clears on its own: wait a few seconds and retry the same request. If every Microsoft Excel call keeps failing with it in a fresh chat, reconnect from the dashboard, and contact support if it still persists — that pattern points to a configuration problem on our side, not something you can fix by reconnecting again. ### Microsoft Excel returns 403 or "permission denied" on one action while others work Two usual causes. The connected account may not have access to the specific workspace, inbox, store, or project in the request — check that first. If access looks right, the agent may have sent a placeholder value (like "YOUR_ID" or an example id from documentation) instead of a real one: ask it to run a list or search tool first, then retry the action with a real id from those results. Most failures at this stage are one of these two, not ClawLink bugs. ### OAuth finished in the browser but the account is still missing Try reconnecting Microsoft Excel and complete the consent flow in the same browser session. Partial OAuth approvals or switching accounts mid-flow can leave the connection incomplete. ### Is there a Hermes Agent Microsoft Excel integration? Yes. ClawLink is the fastest way to connect Hermes to Microsoft Excel: link your Microsoft Excel account once in the browser and Hermes Agent can call the Microsoft Excel API through 54 ready-made tools — no custom code or token handling. ### How do I connect Microsoft Excel to Hermes with ClawLink? Install the plugin with `hermes plugins install ClawLink-HQ/hermes-plugin --enable`, then pair once: run `hermes clawlink begin`, approve the link in your browser, and run `hermes clawlink finish`. Connect Microsoft Excel in the dashboard and Hermes can use it from the next message — no config files or API keys to manage. ### How long does it take to connect Microsoft Excel to Hermes Agent? About two minutes. Sign in, click Connect next to Microsoft Excel in the dashboard, authenticate, and Hermes Agent can use it from the next chat message. ### Why use ClawLink instead of wiring Microsoft Excel up myself? The alternative to ClawLink is usually manual OAuth app setup plus your own token handling, permission troubleshooting, and tool plumbing for Hermes Agent. That is fine if you want to build and maintain the integration yourself. Most teams just want Microsoft Excel working from chat. ### Hermes paired but still can't use Microsoft Excel Pairing is a two-step handshake: run `hermes clawlink begin`, approve the link in your browser, then run `hermes clawlink finish`. If you ran finish before approving, or the approval link expired, run `hermes clawlink begin` again to get a fresh link. Confirm the plugin was installed with `--enable`, then verify with `hermes clawlink test`. ## Related - [Connect Dynamics 365](https://claw-link.dev/hermes/dynamics-365) — Manage CRM and ERP data in Dynamics 365 - [Microsoft Teams](https://claw-link.dev/hermes/microsoft-teams) — Chat, meetings, and team collaboration - [Hermes SharePoint integration](https://claw-link.dev/hermes/sharepoint) — Browse sites, lists, and files in SharePoint