Excel Online Connector for Odoo
Stop exporting. Start syncing. Push live Odoo data directly into your Excel Online workbooks, on demand or on a schedule.
Automate your reporting
Configure a secure, direct link between Odoo and Microsoft Excel Online, then push data on demand or on a schedule.
- Eliminate manual exports: Stop the tedious cycle of downloading CSVs and uploading them to Excel.
- Live data for analysis: Use Excel's PivotTables, charts, and formulas on up-to-date Odoo data.
- Empower your team: Give non-Odoo users the data they need in a familiar tool.
- Simple and secure: Uses the official Microsoft Graph API for a direct, secure connection.
Powerful analysis, with familiar tools
Go beyond standard Odoo reports. Use the full power of Excel Online (PivotTables, charts, formulas, conditional formatting) on live business data without leaving your browser. Build a PivotTable from live inventory data to spot trends.
Keep your team in sync, without leaving Odoo
Update shared Excel workbooks with the latest data straight from Odoo. Sales, finance, and operations collaborate on a single, always-current source of truth. From an invoice list, click sync to refresh the company's financial dashboard.
Solve key reporting challenges
Built to remove the most common frustrations with Odoo reporting and data handling.
Eliminate manual data entry
Automate the flow of information from Odoo to your spreadsheets and save hours of work.
Ensure data consistency
Work from a single source of truth. Your Excel sheets always reflect the latest Odoo data.
Build custom dashboards
Create and maintain complex Excel dashboards fed by real-time Odoo data.
Secure and direct: how it works
The connector uses the official Microsoft Graph API. Configuration happens entirely inside your Odoo settings.
Microsoft authentication
Connect with your M365 Tenant ID, Client ID, and Client Secret from your Microsoft Entra app registration.
Targeted workbook
Point at the exact file with the Workbook File ID and the User UPN that has access to it.
Integrated configuration
Manage every setting from a single clean screen inside Odoo. Set it up once and sync.
Important points to note
- Microsoft Entra app registration: create an app registration in your Microsoft Entra ID (Azure) portal to get your Tenant ID, Client ID, and Client Secret.
- Data privacy and security: data is transmitted directly from your Odoo server to the Microsoft Graph API. It is never stored on a third-party server; the connection is exclusively between your Odoo instance and your Microsoft tenant.
- Correct configuration is key: set API permissions correctly in Azure and enter your IDs, UPN, and Secret accurately in Odoo for a successful connection.
Full step-by-step setup is in our setup & installation guide.
Get the Excel connector
Free, email-gated download. We'll also confirm your Odoo version so setup goes smoothly.
Need help choosing, or a custom setup? Talk to us or book a call.
Excel Online Connector: FAQ
What do I need to use this module?+
An Odoo instance, a Microsoft 365 account with Excel Online, and the ability to create an App Registration in Microsoft Entra ID (Azure).
Can it sync data from custom Odoo modules?+
Yes. You can map and sync data from any standard or custom model in your Odoo database.
Does the sync overwrite my Excel sheet?+
Yes. The connector performs a full sync that replaces the data in the target sheet so it matches the source Odoo data. Use a dedicated sheet for synced data.
What if the connection fails?+
The usual causes are incorrect IDs (Tenant, Client, Workbook), an invalid Client Secret, or insufficient API permissions on your app registration. Check those first, then review the Odoo server logs for the specific Microsoft error.