Microsoft OAuth sign-in
Authorize access with a Microsoft sign-in. Polytomic supplies the app registration, so there is no client ID or secret to create yourself.
Microsoft SharePoint Excel
Polytomic connects Microsoft SharePoint Excel to your data warehouse, databases, and SaaS tools for spreadsheet ETL and reverse ETL. Sync data between Excel workbooks in SharePoint and your data warehouse, without writing code.
Two-way Excel sync
Move data out of Excel workbooks in SharePoint, or write data back into a workbook, from the same connection.
No manual file handling
Replace downloading and re-uploading Excel files with a standing connection between SharePoint and the rest of your stack.
Example workflows
Bring Excel trackers in SharePoint into your data warehouse
What you can sync
Move data between Excel workbooks in SharePoint and your data warehouse, databases, and SaaS tools, in both directions.
From Microsoft SharePoint Excel
Excel workbook data in SharePoint
Worksheets and tables in a connected workbook
To Microsoft SharePoint Excel
Excel workbook data in SharePoint
Worksheets and tables in a connected workbook
How it works
Connect with a Microsoft sign-in and Polytomic can move data between Excel workbooks in SharePoint and the rest of your stack. The connection is registered as both a source and a destination, so the same authorization covers reading Excel data out and writing data back in.
Authorization uses Microsoft's standard OAuth flow, scoped to the sites and files your account can access. Polytomic supplies the app registration and refreshes access automatically, so there is no client ID, secret, or manual token to maintain.
- Connect using a Microsoft OAuth sign-in, not a manual credential
- Polytomic supplies the app registration you authorize on connect
- Registered as both a source and a destination in Polytomic
- Access follows the SharePoint sites and files you approve
- Refresh tokens keep the connection authorized without manual renewal
- Connection health is checked against your Microsoft account directly
How to set up
Microsoft SharePoint Excel connects using Microsoft's OAuth sign-in flow. Authorize access with a Microsoft account that can reach the SharePoint site or Excel file you plan to use, and Polytomic saves the connection for later syncs.
How to get connected
- 1In Polytomic, go to Connections, click Add connection, and select Microsoft SharePoint Excel
- 2Click Connect to Microsoft SharePoint Excel and complete the Microsoft OAuth flow
- 3Review the connection name and click Save
Frequently asked questions
Why teams choose Polytomic
No engineering required
Set up and manage syncs without writing code.
Flexible data modeling
Use SQL to define exactly what data gets synced.
Handles scale automatically
Supports large datasets with incremental syncs and bulk APIs.
Start syncing your data with Microsoft SharePoint Excel in minutes
No credit card required. Free trial available.