;}%20.st6{fill:url(%23SVGID_00000021089067129159788970000008246765442136188072_);}%20.st7{fill:url(%23SVGID_00000117639240116366130650000015074833605515028638_);}%20.st8{opacity:0.4;fill:url(%23SVGID_00000101781798616409025840000016567063639337360777_);}%20.st9{opacity:0.4;fill:url(%23SVGID_00000052086836598721292040000002033117744178971046_);}%20.st10{opacity:0.4;fill:url(%23SVGID_00000159460939004760751800000002448009281983951536_);}%20.st11{opacity:0.4;fill:url(%23SVGID_00000013177830667419993080000017721442101626521532_);}%20.st12{opacity:0.4;fill:url(%23SVGID_00000152235521444854938490000006526001119318383285_);}%20.st13{opacity:0.4;fill:url(%23SVGID_00000119823135212293698520000012774889010992664993_);}%20%3c/style%3e%3cg%3e%3cpolygon%20class='st2'%20points='134.78,14.22%20114.31,48.21%20101.33,69.75%20158.22,69.75%20177.97,36.95%20191.67,14.22%20'/%3e%3cpolygon%20class='st3'%20points='227.55,69.75%20186.61,69.75%20101.33,69.75%20129.78,119.02%20158.16,119.02%20228.61,119.02%20256,119.02%20'/%3e%3cpolygon%20class='st3'%20points='136.93,132.47%20116.46,167.93%2073.82,241.78%20130.71,241.78%20144.9,217.2%20180.13,156.18%20193.82,132.46%20'/%3e%3cpolygon%20class='st3'%20points='121.7,131.95%20101.23,96.49%2058.59,22.63%2030.15,71.91%2044.34,96.49%2079.57,157.5%2093.26,181.22%20'/%3e%3cpolygon%20class='st2'%20points='64.81,131.95%2025.15,131.21%200,130.74%2028.44,180.01%2066.73,180.72%2093.26,181.21%20'/%3e%3cpolygon%20class='st2'%20points='165.38,181.74%20184.58,216.46%20196.75,238.47%20225.19,189.2%20206.66,155.69%20193.83,132.46%20'/%3e%3c/g%3e%3c/svg%3e)
Windmill HubRead and write worksheets, ranges and tables of Excel workbooks stored in OneDrive or SharePoint from any Windmill script, flow or app.
Set up in 2 steps
Connect from the Resources page
Open Resources, click Add a resource/API and pick ms_excel from the OAuth APIs list. Click Connect and sign in with your Microsoft account, then name the resource and save it.
Run your first script
Fork the get range or add row script below, pick a workbook and a worksheet from the dropdowns, and run it. A workbook can also be given as a path such as /Reports/budget.xlsx.
Scripts
Building blocks, if none of the projects above fit. Fork one, run it, or call it as a step inside your own flow.
New Row Added
Update Table Row
Update Range
List Worksheets
List Tables
Get Table Rows
Get Table
Get Range
Find Row
Create xlsx from JSON
Add Worksheet
Add Table Rows
Add Row
Trigger flows from Microsoft Excel
Microsoft Excel is not only a destination. These inbound paths are supported today.
New row added (scheduled poll)
In a flow, add a trigger, choose Scheduled Poll, pick the New Row Added script and an interval. Each run emits the rows added at the bottom of the worksheet since the previous one. It polls because Microsoft Graph only notifies that a file changed, not which cells.
Resource type
The shape of the credential every script on this page expects.
ms_excel
View raw schema →| Field | Type | Required | What it is |
|---|---|---|---|
| token | string | Yes | Microsoft Graph access token. Filled in and refreshed by Windmill when you connect with OAuth. |
Questions
What can Windmill do with my workbooks?
By default: read and edit the Excel workbooks in the OneDrive of the account you sign in with (Files.ReadWrite, plus User.Read and offline_access). A workbook in a SharePoint library or in someone else's drive, passed with drive_id, needs Files.ReadWrite.All: tick it when connecting.
Which files are supported?
Excel workbooks in the .xlsx format stored in OneDrive or SharePoint. Older .xls files and .csv files are not. Microsoft documents the workbook API for work or school accounts; personal accounts are best-effort.
Worksheet rows or table rows?
Add Row and Find Row work on any worksheet by looking at its used cells. If the data is formatted as an Excel table (Insert, Table), the table scripts are more robust: they address rows by index and keep the table's formatting and formulas.
How do I create a workbook?
Microsoft Graph cannot create an empty workbook. Build one with the Create xlsx from JSON script, which needs no Microsoft connection and writes the file to workspace object storage, then upload it with the OneDrive or SharePoint integration and write to it.
There is no Connect button on my instance
Self-hosted instances need an admin to register an app in Microsoft Entra ID once, then add Microsoft Excel under Instance settings, OAuth, with its client id, secret and tenant. Use common as the tenant for a multi-tenant app or personal accounts, or your tenant id for a single-tenant app. The app's redirect URI is <your instance>/oauth/callback/ms_excel. The same Entra app can serve the Outlook, OneDrive, SharePoint and Excel connections.