;}%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 Microsoft Excel under Instance-configured OAuth APIs. 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 and pick a workbook and a worksheet from the dropdowns, or give the workbook 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.
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
A script fails on a missing permission
Each script's description names the permission it needs. The default covers workbooks in your own OneDrive; one in a SharePoint library or someone else's drive, passed with drive_id, needs Files.ReadWrite.All. Tick it when connecting, or reconnect an existing resource.
Which files are supported?
Excel workbooks in the .xlsx format stored in OneDrive or SharePoint, not .xls or .csv. 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's used cells. For data formatted as an Excel 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, upload it with the OneDrive or SharePoint integration, then write to it.
There is no Connect button on my instance
An instance admin registers an app in Microsoft Entra ID with the redirect URI <your instance>/oauth/callback/ms_excel, then adds Microsoft Excel under Instance settings → Auth/OAuth/SAML → OAuth with its client id, secret and tenant. The tenant is set once for the whole instance, and one Entra app can serve Outlook, OneDrive, SharePoint and Excel.