Category · Data Sources
Microsoft Excel
OneDrive and SharePoint workbooks, live
Connect Excel workbooks hosted on OneDrive or SharePoint. We read the data through the Microsoft Graph API so updates show up in your dashboard within minutes.
What it does
- Read any worksheet from a OneDrive or SharePoint file
- Handle named ranges and Excel tables
- Refresh every 10 minutes
- Support Microsoft 365 SSO
How data flows
Read-only from your tenant. Datareaches never modifies the workbook.
How to set it up
Step 1
Open dashboard settings → Integrations.
Step 2
Authorise with your Microsoft 365 account.
Step 3
Browse to the workbook on OneDrive or SharePoint.
Step 4
Select the worksheet or named table.
Step 5
Confirm field mapping and save.
Example dashboards
- Finance reporting pack tied to an Excel model
- Operations rota for shift planning
- Quarterly forecast tracker with budget vs actual
Add this to your dashboard
We'll wire this integration into your custom dashboard during the 7-day build.