Excel MCP integration
Reads ranges and tables, appends rows, updates cells, sorts and filters data, and exports a workbook to PDF.
54actions available
Three actions you can hand over today
Every action runs live through MCP. Nothing to build, nothing to maintain.
Get sharepoint range
Ayro reads a range of cells from a SharePoint Excel workbook to answer a data question. Whoever asked gets the numbers straight from the spreadsheet instead of waiting for someone to open the file.
Update sharepoint range
Ayro writes new values into a range in a SharePoint Excel workbook on request. A spreadsheet update that used to mean opening Excel now happens in seconds.
Export workbook to PDF
Ayro converts a SharePoint Excel workbook into a PDF file ready to share. Whoever needs a clean, uneditable copy of the data gets one without opening Excel.
How businesses use Excel + Lyro
Each card is one request a support team gets, and the Excel actions Lyro runs to close it.
Answer a question from the live spreadsheet
Ayro opens the workbook, reads the range or table rows behind the number someone asked about, and reports the current value rather than a figure copied into a document last week.
Get RangeList Table RowsGet Worksheet Used RangeLog a new record without opening the file
When a conversation produces data worth keeping, Ayro appends it as a table row, writes the supporting cells, and starts a new worksheet when the sheet in use is the wrong home for it.
Add Table RowUpdate RangeAdd WorksheetReshape a table into the view someone asked for
Ayro sorts a table by the column that matters, filters it down to the rows in question, and clears the filter afterwards, so the answer is a real slice of the data rather than a description of it.
Apply Table SortApply Table FilterClear Table FilterTurn a workbook into something shareable
Ayro adds the chart that makes the trend readable, exports the workbook to PDF, and grants access to the person who needs it, so a report leaves the spreadsheet in a form others can open.
Add ChartExport Workbook To PdfAdd Workbook Permission
How it works
Get started in 3 steps
Connect once, then just ask. There is no workflow builder to learn and nothing to maintain — Lyro reads the Excel actions it has and picks the ones a request needs.
Connect Excel
Authorize the Excel account your team already uses — one consent screen, no API keys, no mapping tables. Lyro can only do what you granted that account, and you can disconnect it at any time.
Tell your agent what you need
Describe the job the way you would hand it to a teammate. Lyro maps it to the Excel actions that close it and chains as many as the request needs.
Watch it work
The agent runs the actions inside the conversation the customer is already in, so nobody copies data between tabs and your team can take over at any point.
Get started free
Excel · Lyro
What can you do in Excel without me setting anything up?
These, right away:
- Read a range
- Write a range
- Add a row
Great, let's start with the first one.
FAQ
Everything else about Excel
Setup, permissions, and the limits of what Lyro can do inside Excel.
Yes, because the toolkit exposes Excel's session model directly. Create Excel Session opens a workbook session that a run of reads and writes shares, and Close Excel Session ends it, so a sequence like sort, update, and read back operates on one consistent view of the file rather than reopening it each call.
Every action available in Excel
All 54 actions your agent can call on Excel, straight from the live MCP connection.
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
Grant access to a workbook via invite.
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
Clear values, formats, or contents in a specified worksheet range.
Clear table filter
Clear a filter from a table column using Microsoft Graph API.
Close excel session
Close an existing Excel workbook session.
Convert table to range
Convert a table to a range using Microsoft Graph API.
Create workbook
Create a new Excel workbook file at a specified drive path.
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
Delete a worksheet from the workbook.
Export workbook to PDF
Export an Excel workbook to PDF via Microsoft Graph's format conversion.
Get chart axis
Retrieve a specific axis from a chart.
Get chart data labels
Retrieve the data labels object of a chart.
Get chart legend
Retrieve the legend object of a chart.
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
Retrieve a specific column from a workbook table.
Get workbook
Retrieve the properties and relationships of a workbook.
Get worksheet
Get a worksheet by name or ID from an Excel workbook using Microsoft Graph API.
Get worksheet used range
Retrieve a worksheet's used range (active data region) without specifying a fixed range address.
Insert range
Insert a new cell range into a worksheet, shifting existing cells down or right.
The tools Excel sits next to
Same connection, same setup. Pick the next one your team already uses.
Google Sheets
Looks up rows, appends and upserts records, aggregates columns, applies filters and validation, and builds charts.
Boloforms
Reads the workspace document list with each document's signing type, status, and timestamps, so signature chasing is answered on the spot.
DocRaptor
Generates PDF and Excel files from HTML, follows async jobs through to download, and pages through the document creation history.
Esignatures.io
Sends a contract from the right template, reports how far each signer has got, and corrects or withdraws a request that went out wrong.
Kraken.io
Compresses, resizes, or converts an image from a public URL, preserves EXIF metadata on request, and reports remaining quota.
Pdfless
Lists the templates a workspace holds with the IDs a render needs, and confirms the workspace behind the API key is active.
Ready to connect Excel?
Authorize the account and your agent has all 54 actions from the first conversation.