Connect Excel to OpenClaw on Operator.io
Microsoft Excel is a robust spreadsheet application for organizing, analyzing, and visualizing data. It's the go-to tool for calculations, reporting, and flexible data management.
Automate Excel with AI
Hand Excel to an OpenClaw agent running on Operator. You write what you want in a chat and it turns that into real Excel actions like add chart, add sharepoint worksheet, add table, without you opening the app.
Your agent reaches Excel directly or through connectors like Composio MCP and Pipedream MCP, which handle the sign in and token refresh for you, so there is nothing to wire up and no API keys to paste.
What your agent can do with Excel
Your agent can call any of these Excel actions by name as part of a larger task. Ask for the outcome you want and it picks the right ones.
Add Chart
Add a chart to a worksheet using Microsoft Graph API.
Add SharePoint Worksheet
Add a new worksheet to a SharePoint Excel workbook using Microsoft Graph Sites API.
Add Table
Create a new table in a worksheet using the Microsoft Graph API.
Add Table Column
Add a column to a table using Microsoft Graph API.
Add Table Row
Add a row to a table using Microsoft Graph API.
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.
Add Worksheet
Add a new worksheet to an Excel workbook using Microsoft Graph API.
Apply Table Filter
Apply a filter to a table column using Microsoft Graph API.
Apply Table Sort
Apply a sort to a table using Microsoft Graph API.
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.
Clear Table Filter
Clear a filter from a table column using Microsoft Graph API.
Close Excel Session
Tool to close an existing Excel workbook session. Use when you need to explicitly end a persistent session to release workbook locks. Note: The Microsoft Graph closeSession API is idempotent - it returns 204 for both active and already-c...
Convert Table To Range
Convert a table to a range using Microsoft Graph API.
Create Workbook
Tool to create a new Excel workbook file at a specified drive path. Generates a new .xlsx file with specified worksheets and data, then uploads it to OneDrive.
Delete Table Column
Delete a column from a table using Microsoft Graph API.
Delete Table Row
Delete a row from a table using Microsoft Graph API.
Delete Worksheet
Tool to delete a worksheet from the workbook. Use when cleaning up unused or temporary sheets after verifying no dependencies exist. Example: "Delete 'Sheet2' after review."
Export Workbook to PDF
Tool to export an Excel workbook to PDF via Microsoft Graph's format conversion. Use when you need a PDF version of an Excel file for sending, storing, or attaching.
Get Chart Axis
Tool to retrieve a specific axis from a chart. Use when you need properties like min, max, interval, and formatting of the chart axis.
Get Chart Data Labels
Tool to retrieve the data labels object of a chart. Use when you need to inspect label settings like position, separator, and visibility flags after creating or updating a chart.
Get Chart Legend
Tool to retrieve the legend object of a chart. Use after creating or updating a chart when you need to inspect legend visibility and formatting.
Get Range
Get a range from a worksheet using Microsoft Graph API.
Create Excel Session
Create a session for an Excel workbook using Microsoft Graph API.
Get SharePoint Range
Get a range from a worksheet in SharePoint using Microsoft Graph Sites API.
Get SharePoint Worksheet
Get a worksheet by name or ID from a SharePoint Excel workbook using Microsoft Graph Sites API.
Get table column
Tool to retrieve a specific column from a workbook table. Use when you need to fetch column properties and data by its ID or name.
Get workbook
Tool to retrieve the properties and relationships of a workbook. Use when you need to inspect comments, names, tables, or worksheets.
Get Worksheet
Get a worksheet by name or ID from an Excel workbook using Microsoft Graph API.
Get Worksheet Used Range
Tool to retrieve a worksheet's used range (active data region) without specifying a fixed range address. Use when you need to read all data from a sheet but don't know the exact range. The valuesOnly option helps filter out formatting-on...
Insert Range
Tool to insert a new cell range into a worksheet, shifting existing cells down or right. Use when you need to create space for new content without overwriting.
List Charts
List charts in a worksheet using Microsoft Graph API.
List Chart Series
Tool to list all data series in a chart. Use when you need to enumerate chart series for further analysis.
List Comments
Tool to list comments in an Excel workbook. Use when you need to retrieve all workbook comments via Microsoft Graph API.
List Drive Item Children
Tool to list immediate children (files/folders) of a folder DriveItem using driveId and itemId. Returns an array of child DriveItems with stable identifiers and pagination support.
List Drive Files
List files and folders in a drive root or specified path.
List Named Items
List named items in a workbook using Microsoft Graph API.
List SharePoint Tables
List tables in a SharePoint worksheet using Microsoft Graph Sites API.
List SharePoint Worksheets
List worksheets in an Excel workbook stored in SharePoint using Microsoft Graph Sites API.
List Table Columns
List columns in a table using Microsoft Graph API.
List Table Rows
List rows in a table using Microsoft Graph API.
List Tables
List tables in a worksheet using Microsoft Graph API. This action retrieves information about all tables present in a specified worksheet of an Excel file. It requires the file ID and worksheet name or ID, and can optionally use a sessio...
List Workbook Permissions
Tool to list permissions set on the workbook file. Use when you need to see which users or links have access to a specific Excel file by supplying its drive and item IDs. Example: "List permissions for workbook with drive_id 'b!abc123' a...
List Worksheets
List worksheets in an Excel workbook using Microsoft Graph API.
Merge Cells
Merge cells in a worksheet range using Microsoft Graph API.
Protect Worksheet
Tool to protect a worksheet using optional protection options. Use when you need to prevent editing certain parts of a sheet before sharing. Example: "Protect 'Sheet1' to lock formatting and sorting."
Search Drive Files
Tool to search OneDrive drive items by query to discover Excel workbook IDs. Use when you need to find Excel files by name before performing workbook operations.
Sort Range
Sort a range in a worksheet using Microsoft Graph API.
Update Chart
Update a chart in a worksheet using Microsoft Graph API.
Plus 6 more Excel actions your agent can call.
How to connect Excel
You authorize Excel once from your dashboard. Operator holds the connection and refreshes the access tokens on its own, so your agent keeps working with Excel without you signing in again. The same setup unlocks every other app your agent can reach, so you only do it once.
When you are ready, the get started guide walks through standing up your OpenClaw agent.
Common questions about Excel
- How do I connect Excel to Operator?
- You authorize Excel once from your Operator dashboard. Operator holds the connection and refreshes the access token for you, so your agent keeps working with Excel without you signing in again.
- Can my agent pull and update data in Excel?
- Yes. It can read records, write new ones, and answer questions about what is stored. Point it at Excel and ask for a figure or a list, or have it keep a table in step with another app you have connected, all in plain language.
- Do I need to write code or manage Excel API keys?
- No code and no API keys. You authorize Excel through a normal sign in and Operator handles the connection, so there is nothing to wire up or host.
- Can my agent use Excel together with my other apps?
- Yes. The same agent reaches every app you connect, so it can move between Excel and tools like Gigasheet, Nasa, Api ninjas in one job, reading from one and acting in another without you wiring anything between them.
More apps to automate
Apps your agent runs alongside Excel, or browse all integrations.
Put your agent on Excel
Sign in, connect Excel, and hand your agent the work. Your first week is free.
Try for free