M
Microsoft Excel
by Microsoft
Read, write, and manage data in Microsoft Excel spreadsheets
Data & SpreadsheetsFree / PaidOAuth 2.0spreadsheetdatamicrosoftoffice365storage
How agents use Microsoft Excel
- ✓Agent reads a worksheet to retrieve a dataset or configuration table needed to start a workflow
- ✓Agent appends a new row to log each processed item, transaction, or workflow result
- ✓Agent updates a cell or row to reflect the current status of a task the agent has completed
- ✓Agent generates a formatted report by writing structured data to a named worksheet
- ✓Agent uses an Excel workbook as a shared output layer so team members can review agent results
Agent actions
Read RangeRead data from a range of cells
Inputs: worksheet, range
Returns: values, range, rowCount, columnCount
Write RangeWrite data to a range of cells
Inputs: worksheet, range, values
Returns: updatedCells, updatedRange
Append RowsAppend rows to the end of a worksheet
Inputs: worksheet, values
Returns: updatedRows, startRow
Create WorksheetCreate a new worksheet/tab in the workbook
Inputs: name
Returns: worksheetId, name
Clear RangeClear values from a range of cells
Inputs: worksheet, range
Returns: success
List WorksheetsGet list of all worksheets in the workbook
Returns: worksheets
Create TableCreate an Excel table from a range
Inputs: worksheet, range, name, hasHeaders
Returns: tableId, name
Add ChartCreate a chart from data range
Inputs: worksheet, type, sourceData, title
Returns: chartId
Update Cell FormatUpdate formatting for a range of cells
Inputs: worksheet, range, format
Returns: success
Example workflows
1
Data reporting
Automatically populate Excel reports with latest data
2
Sales tracking
Append new sales records to Excel workbook
About Microsoft Excel
- Vendor
- Microsoft
- Pricing Always review details with the vendor
- Free / Paid — Included with Microsoft 365 subscriptions
- Authentication
- OAuth 2.0
- Rate limit Always review details with the vendor
- 300 requests / minute
- Compatible nodes
- AgentResourceOutput
Build an AI workflow with Microsoft Excel
Use the Agentic Planner to design, visualize, and connect Microsoft Excel with your other tools.
Open Agentic Planner