Live Odoo data in Excel Online
Stop exporting CSVs. Push live Odoo data straight into your Excel Online workbooks, on demand or on a schedule, through the official Microsoft Graph API. Free, with source code.
Your dataSynced live from Odoo · sample data
Odoo data, in the tool your team already uses
Eliminate manual exports
Stop the tedious cycle of downloading CSVs and uploading them to Excel.
Live data for analysis
Use Excel 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.
What it solves
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.
Three steps to connect
Set it up once inside Odoo, then sync on demand or on a schedule.
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.
Need help choosing, or a custom setup? Talk to us or book a call.
Free download with full source code. See the rest of the catalogue.
Excel Online Connector questions
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.