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
This is a first-class FlyMyAI MCP. Agents discover it automatically via tool search and call the actions below on demand - you never wire it up by hand. See the Composio catalog for how discovery works.
Connect
Excel connects with a single OAuth click - there is no token to paste. The first time an agent uses an Excel action, FlyMyAI asks you to authorize your Excel account. Approve it once and the connection is reused for every later run.
- Provider: Excel
Actions
Every action this integration exposes. Agents pick the right one from the task; you do not call them by name.
| Action | What it does | Required inputs |
|---|---|---|
EXCEL_ADD_CHART | Add a chart to a worksheet using microsoft graph api. | item_id, worksheet, type, sourcedata, seriesby |
EXCEL_ADD_SHAREPOINT_WORKSHEET | Add a new worksheet to a sharepoint excel workbook using microsoft graph sites api. | site_id, item_id, name |
EXCEL_ADD_TABLE | Create a table in a workbook using microsoft graph api. | item_id, table_id, name, hasHeaders, showTotals, style |
EXCEL_ADD_TABLE_COLUMN | Add a column to a table using microsoft graph api. | item_id, table_id, values, index |
EXCEL_ADD_TABLE_ROW | Add a row to a table using microsoft graph api. | item_id, table_id, values |
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. | item_id, recipients, roles |
EXCEL_ADD_WORKSHEET | Add a new worksheet to an excel workbook using microsoft graph api. | item_id, name |
EXCEL_APPLY_TABLE_FILTER | Apply a filter to a table column using microsoft graph api. | item_id, worksheet, table_id, column_id, criteria |
EXCEL_APPLY_TABLE_SORT | Apply a sort to a table using microsoft graph api. | item_id, worksheet, table_id, fields |
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. | item_id, worksheet_id, address |
EXCEL_CLEAR_TABLE_FILTER | Clear a filter from a table column using microsoft graph api. | item_id, worksheet, table_id, column_id |
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. | item_id, session_id |
EXCEL_CONVERT_TABLE_TO_RANGE | Convert a table to a range using microsoft graph api. | item_id, table_id |
EXCEL_CREATE_WORKBOOK | Tool to create a new workbook file at a specified drive path. use when uploading a new .xlsx file to onedrive. | path, content |
EXCEL_DELETE_TABLE_COLUMN | Delete a column from a table using microsoft graph api. | item_id, table_id, column_id |
EXCEL_DELETE_TABLE_ROW | Delete a row from a table using microsoft graph api. | item_id, table_id, row_index |
EXCEL_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." | item_id, worksheet |
EXCEL_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. | item_id, worksheet, chart_name, axis_type |
EXCEL_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. | item_id, worksheet_id, chart_id |
EXCEL_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. | item_id, worksheet_id, chart_name |
EXCEL_GET_RANGE | Get a range from a worksheet using microsoft graph api. | item_id, worksheet_id, address |
EXCEL_GET_SESSION | Create a session for an excel workbook using microsoft graph api. | item_id |
EXCEL_GET_SHAREPOINT_RANGE | Get a range from a worksheet in sharepoint using microsoft graph sites api. | site_id, item_id, worksheet_id, address |
EXCEL_GET_SHAREPOINT_WORKSHEET | Get a worksheet by name or id from a sharepoint excel workbook using microsoft graph sites api. | site_id, item_id, worksheet |
EXCEL_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. | item_id, table_id, column_id |
EXCEL_GET_WORKBOOK | Tool to retrieve the properties and relationships of a workbook. use when you need to inspect comments, names, tables, or worksheets. | drive_id, item_id |
EXCEL_GET_WORKSHEET | Get a worksheet by name or id from an excel workbook using microsoft graph api. | item_id, worksheet |
EXCEL_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. | item_id, worksheet_id, address, shift |
EXCEL_LIST_CHARTS | List charts in a worksheet using microsoft graph api. | item_id, worksheet |
EXCEL_LIST_CHART_SERIES | Tool to list all data series in a chart. use when you need to enumerate chart series for further analysis. | item_id, worksheet, chart_name |
EXCEL_LIST_COMMENTS | Tool to list comments in an excel workbook. use when you need to retrieve all workbook comments via microsoft graph api. | item_id |
EXCEL_LIST_FILES | List files and folders in a drive root or specified path. | - |
EXCEL_LIST_NAMED_ITEMS | List named items in a workbook using microsoft graph api. | item_id |
EXCEL_LIST_SHAREPOINT_TABLES | List tables in a sharepoint worksheet using microsoft graph sites api. | site_id, item_id, worksheet |
EXCEL_LIST_SHAREPOINT_WORKSHEETS | List worksheets in an excel workbook stored in sharepoint using microsoft graph sites api. | site_id, item_id |
EXCEL_LIST_TABLES | List tables in a worksheet using microsoft graph api. | item_id, worksheet |
EXCEL_LIST_TABLE_COLUMNS | List columns in a table using microsoft graph api. | item_id, table_id |
EXCEL_LIST_TABLE_ROWS | List rows in a table using microsoft graph api. | item_id, table_id |
EXCEL_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' and item id '0123456789… | drive_id, item_id |
EXCEL_LIST_WORKSHEETS | List worksheets in an excel workbook using microsoft graph api. | item_id |
EXCEL_MERGE_CELLS | Merge cells in a worksheet range using microsoft graph api. | item_id, worksheet, range |
EXCEL_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." | item_id, worksheet |
EXCEL_SORT_RANGE | Sort a range in a worksheet using microsoft graph api. | item_id, worksheet, range_type, fields |
EXCEL_UPDATE_CHART | Update a chart in a worksheet using microsoft graph api. | item_id, worksheet, chart_id |
EXCEL_UPDATE_CHART_LEGEND | Tool to update formatting or position of a chart legend. use when adjusting legend settings after confirming chart and worksheet exist. | item_id, worksheet, chart_id |
EXCEL_UPDATE_RANGE | Update a range in a worksheet using microsoft graph api. | item_id, worksheet_id, address, values |
EXCEL_UPDATE_SHAREPOINT_RANGE | Update a range in a sharepoint worksheet using microsoft graph sites api. | site_id, item_id, worksheet_id, address, values |
EXCEL_UPDATE_TABLE | Update a table in a workbook using microsoft graph api. | item_id, table_id |
EXCEL_UPDATE_WORKSHEET | Update worksheet properties (name, position) in an excel workbook using microsoft graph api. | item_id, worksheet |
Links
We love our partners - FlyMy.AI builds with the best. Thanks, Excel!