Your AI team, working in Excel

Microsoft Excel is a powerful spreadsheet application for data analysis, calculations, and visualization, enabling users to organize and process data with formulas, charts, and pivot tables

Start your company

What your team can do in Excel

125 tools to work with, connected with your account.

Add Chart

Add a chart to a worksheet using Microsoft Graph API.

Add Named Item

Add a workbook- or worksheet-scoped named item using an invariant reference or a local formula.

Add SharePoint Worksheet

Add a new worksheet to an Excel workbook in a SharePoint site's default drive using Microsoft Graph.

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.

Autofit Range

Autofit columns or rows intersecting a workbook range.

Calculate Excel Workbook

Calculate Excel Workbook

Calculate Workbook FunctionReads only

Run one allowlisted Microsoft Graph v1.0 workbook function.

Clear All Table Filters

Clear All Table Filters

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.

Clear Table Sort

Clear Table Sort

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-closed sessions. This action validates the session first and returns an error for invalid or already-closed sessions to provide clearer user feedback. The validation uses refreshSession which is the only API endpoint that can detect closed sessions.

Convert Table To Range

Convert a table to a range using Microsoft Graph API.

Copy Drive Item

Create a non-destructive asynchronous copy of a file or folder. Metadata and permissions are not copied; the new item inherits destination-folder permissions. Version history is copied only when explicitly requested.

Create Comment

Create a plain-text Excel cell comment through Microsoft Graph beta. This beta operation requires a delegated work or school account. Microsoft does not support beta APIs for production applications.

Create Excel Session

Create a session for an Excel workbook using Microsoft Graph API.

Create Folder

Create a folder under a parent Microsoft Graph drive item.

Create Upload Session

Create a resumable upload session at a drive-root path.

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.

Create Workbook Sharing Link

Create or retrieve an application-owned sharing link for a workbook.

Delete Drive Item

Move a OneDrive or SharePoint drive item to the recycle bin by item ID.

Delete Named Item

Permanently delete a workbook-scoped named item; this cannot be undone.

Delete Range

Delete worksheet cells and shift the remaining cells up or left.

Delete Table

Permanently delete an Excel table by its ID or name.

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

Download WorkbookReads only

Download an Excel workbook in its original file format.

Export Workbook to PDF

Export an Excel workbook to PDF using Microsoft Graph format conversion, returning a download URL. Optionally save the converted PDF to a path in the selected drive.

Get chartReads only

Get chart

Get Chart AxisReads only

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 componentReads only

Retrieve one Excel chart component: chart title, axis title, supported gridlines, axis font, or supported line format.

Get Chart Data LabelsReads only

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 imageReads only

Render an Excel chart as a base64-encoded image.

Get Chart LegendReads only

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 chart pointReads only

Get chart point

Get chart seriesReads only

Get chart series

Get CommentReads only

Retrieve one workbook comment by its exact ID.

Get Comment ReplyReads only

Retrieve one reply to a workbook comment by its exact ID.

Get Derived RangeReads only

Return a range derived from another range by navigation or geometry.

Get Drive ItemReads only

Retrieve OneDrive or SharePoint drive item metadata by exact ID or path.

Get Excel ApplicationReads only

Get Excel Application

Get Excel Operation StatusReads only

Get the status of an asynchronous Excel workbook operation by its operation ID.

Get Named ItemReads only

Retrieve a workbook-scoped named item by exact name.

Get Named Item RangeReads only

Retrieve the Excel range of a range-valued workbook-scoped named item.

Get Pivot TableReads only

Get Pivot Table

Get Projected Worksheet SubresourceReads only

Read selected properties from a worksheet range, its used range, or worksheet protection.

Get RangeReads only

Get a range from a worksheet using Microsoft Graph API.

Get Range FormatReads only

Read one formatting component from a workbook range.

Get SharePoint RangeReads only

Get a range from a worksheet in SharePoint using Microsoft Graph Sites API.

Get SharePoint WorksheetReads only

Get a worksheet by name or ID from an Excel workbook in a SharePoint site's default drive using Microsoft Graph.

Get TableReads only

Retrieve one workbook- or worksheet-addressed table by ID or exact name.

Get table columnReads only

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 Table Column CellReads only

Read one cell by row within a selected table column's data body.

Get Table Column RangeReads only

Get Table Column Range

Get Table RangeReads only

Get Table Range

Get Table RowReads only

Get Table Row

Get Table Row RangeReads only

Get Table Row Range

Get Table SortReads only

Get Table Sort

Get Visible RangeReads only

Read cells visible after worksheet filtering.

Get workbookReads only

Retrieve a workbook's relationships, including comments, named items, operations, tables, and worksheets, with optional relationship expansion.

Get WorksheetReads only

Get a worksheet by name or ID from an Excel workbook using Microsoft Graph API.

Get Worksheet ProtectionReads only

Get Worksheet Protection

Get Worksheet Row RangeReads only

Read a zero-based worksheet row across the column bounds of the worksheet's values-only used range.

Get Worksheet Used RangeReads only

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-only cells.

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 chart pointsReads only

List chart points

List Chart SeriesReads only

List a page of data series names in a chart, with a next-page link when more results are available.

List ChartsReads only

List charts in a worksheet using Microsoft Graph API.

List Comment RepliesReads only

List replies to one workbook comment.

List CommentsReads only

List a page of comments in an Excel workbook using Microsoft Graph. Returns a next-page link when one is provided.

List Drive FilesReads only

List files and folders in a drive root or specified path.

List Drive Item ChildrenReads only

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 Item VersionsReads only

List retained versions of a OneDrive or SharePoint workbook file.

List Named ItemsReads only

List named items in a workbook using Microsoft Graph. If no session is supplied, the tool creates a nonpersistent workbook session before listing.

List Pivot TablesReads only

List Pivot Tables

List SharePoint TablesReads only

List tables in a worksheet of an Excel workbook stored in a SharePoint site's default drive using Microsoft Graph.

List SharePoint WorksheetsReads only

List worksheets in an Excel workbook stored in SharePoint using Microsoft Graph Sites API.

List Site ListsReads only

List SharePoint lists in a known Microsoft Graph site. Use site search first when the site ID is unknown. The action exposes projection and page controls but does not automatically follow the returned next link.

List Table ColumnsReads only

List columns in a table using Microsoft Graph API.

List Table RowsReads only

List rows in a table using Microsoft Graph API.

List TablesReads only

List tables in a specified Excel worksheet using Microsoft Graph API. Returns one page of table information and a continuation link when provided; an optional workbook session can be used.

List Workbook PermissionsReads only

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' and item_id '0123456789abcdef'."

List Workbook TablesReads only

List tables across a workbook without requiring a worksheet identifier.

List WorksheetsReads only

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

Reapply All Table Filters

Reapply All Table Filters

Reapply Table Sort

Reapply Table Sort

Refresh Excel Session

Refresh Excel Session

Refresh Pivot Tables

Refresh Pivot Tables

Resolve Shared WorkbookReads only

Resolve a Microsoft Graph share token, shareId, or raw sharing URL to DriveItem metadata.

Revoke Workbook Permission

Remove a non-inherited sharing permission from a workbook.

Run Graph Mutation Batch

Create, update, or delete drive or workbook resources in up to 20 requests; inspect every subresponse status because individual mutations can fail.

Run Graph Read BatchReads only

Read drive or workbook data in up to 20 GET requests; inspect every subresponse status because individual requests can fail.

Search Drive FilesReads only

Search OneDrive drive items by query and return files, optionally filtered by extension, to discover Excel workbook IDs. Extension filtering is applied to each returned page.

Search Microsoft 365 ContentReads only

Search OneDrive and SharePoint content using Microsoft Search.

Search SitesReads only

Search SharePoint sites by free-text query for workbook discovery.

Set chart data

Replace an Excel chart's source range and optionally choose whether rows or columns define its series.

Set chart position

Set chart position

Sort Range

Sort a range in a worksheet using Microsoft Graph API.

Unmerge Range

Split a merged worksheet range back into separate cells.

Unprotect Worksheet

Remove protection from a worksheet so it can be edited again.

Update Chart

Update a chart in a worksheet using Microsoft Graph API.

Update chart component

Update one Excel chart component: an axis, data labels, chart title, axis title, supported gridlines, axis font, fill, or supported line format.

Update Chart Legend

Update a chart legend's visibility, position, or overlay setting.

Update chart series

Rename one Excel chart series by ID or zero-based collection position.

Update Drive Item

Rename, move within the same drive, or update client timestamps for a DriveItem by stable ID.

Update Named Item

Update a workbook named item's visibility or comment.

Update Range

Update cell values in a specified worksheet range using Microsoft Graph API.

Update Range Format

Update exactly one formatting component on a workbook range.

Update SharePoint Range

Update values in a worksheet range in an Excel workbook stored in a SharePoint site's default drive using Microsoft Graph.

Update Table

Update an Excel workbook table's name, header visibility, totals visibility, or style using Microsoft Graph.

Update Table Column

Update the name or values of an Excel table column.

Update Table Column Range

Update raw values in a table column's data-body cells by zero-based index.

Update Table Row

Update Table Row

Update Worksheet

Update worksheet properties (name, position) in an Excel workbook using Microsoft Graph API.

Upload Workbook from URL

Tool to upload an external Excel file from a URL into OneDrive/SharePoint. Downloads the file server-side and uploads it to the specified drive location, returning the driveItem metadata for subsequent Excel operations.

Who Am IReads only

Return the identity (email, name) of the connected Excel (Microsoft) account.

More in Spreadsheets

See them all β†’

Your company, run by an AI team

Start your company

BRAINER

Continue to B.R.A.I.N.E.R.

Continue with Google or your email.

or