Setup: Excel Online Connector
Setting up the Odoo Excel Online Connector requires several pieces of information from your Microsoft Azure and OneDrive environment. Below is a guide on how to locate each required value.
1. Tenant ID
Where to Find:
Log in to the Azure Portal.
Navigate to Azure Active Directory from the left sidebar.
Under Overview, you will see the Tenant ID (a GUID format, e.g., xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx).
2. Client ID (Application ID)
Where to Find:
In the Azure Portal, go to Azure Active Directory.
Select App registrations.
Click on the application you registered for Odoo integration.
Under the Overview section, you’ll find the Application (client) ID.
3. Client Secret
Where to Find:
In your application’s page in App registrations, click on Certificates & secrets.
Under Client secrets, click New client secret.
Add a description and select an expiry period, then click Add.
Copy the Value immediately after creation (you won’t be able to see it again). This is your Client Secret.
4. User UPN (User Principal Name)
Where to Find:
Go to the Microsoft 365 Admin Center or Azure Portal.
Navigate to Users > Active users.
Locate the user whose OneDrive will be used for Excel exports.
The User Principal Name is their login email address (e.g., user@yourcompany.com).
5. Drive ID
Where to Find:
The Drive ID is a unique identifier for the user’s OneDrive.
You can obtain it using the Microsoft Graph Explorer:
Make a GET request to: https://graph.microsoft.com/v1.0/users/{user-upn}/drive
The response will include "id": "drive-id-here".
Some connectors fetch this automatically after you enter the User UPN and credentials3.
6. Workbook File ID
Where to Find:
Open the target Excel file in OneDrive.
Check the URL in your browser. The File ID is usually the long string after id= or /file/ in the URL, for example:
- Copy
texthttps://onedrive.live.com/edit.aspx?cid=XXXXXXX&id=YYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYY
The value after id= is your Workbook File ID.
7. Access Token
Where to Find:
The access token is generated automatically by the connector using your Tenant ID, Client ID, Client Secret, and User UPN.
You do not need to manually obtain or enter this; the connector manages token generation and refresh12.
Quick Reference Table
CredentialWhere to Find / How to Obtain
Tenant ID
Azure Portal → Azure Active Directory → Overview
Client ID
Azure Portal → App registrations → Your App → Overview
Client Secret
Azure Portal → App registrations → Certificates & secrets
User UPN
Microsoft 365 Admin Center → Users → Active users
Drive ID
Microsoft Graph API: /users/{user-upn}/drive or auto-fetched
Workbook File ID
In OneDrive Excel file URL (id= parameter)
Access Token
Auto-generated by connector
Support & Resources
Your module provider’s support channels
Tip: If you are unsure about any of these steps, contact your Azure/Microsoft 365 administrator for assistance—they can help you retrieve or generate the necessary values.
Overview
Whether you’re a business analyst, finance manager, or IT administrator, this tool simplifies complex data workflows and brings the power of Odoo and Excel together—no manual downloads, no data silos. The Odoo Excel Online Connector empowers you to seamlessly integrate your Odoo ERP data with Microsoft Excel Online, enabling real-time reporting, advanced analytics, and streamlined collaboration. Built for security and efficiency, this connector leverages Azure Active Directory authentication and Microsoft Graph API to ensure safe, automated, and customizable data exports from Odoo to your Excel workbooks in OneDrive.
Setup: Niyu MCP Server for Odoo
Native MCP endpoint for Odoo with admin-controlled access, model permissions, CRUD operation presets, audit logs, and support for MCP clients such as ChatGPT, Claude, Cursor, Codex, VS Code, and other compatible tools. The module is designed for teams that want AI tools to work with real Odoo context without exporting CSV files, exposing database credentials, or giving uncontrolled access to every model.