| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
Discuss (mail)
|
| Lines of code | 1137 |
| Technical Name |
eb_excel_studio |
| License | OPL-1 |
| Website | https://www.echobitzit.com |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
Discuss (mail)
|
| Lines of code | 1137 |
| Technical Name |
eb_excel_studio |
| License | OPL-1 |
| Website | https://www.echobitzit.com |
Odoo Excel Studio
Excel Connector turns Odoo into a live Microsoft Excel data source with a self-hosted Office Add-in, secure per-user API keys, desktop Power Query support, searchable model and field browsing, one-click table import, controlled write-back from Excel to Odoo, a read-only SQL Query tool, and a clear Access Logs for production use.
Why Teams Choose Excel Connector
How Excel Connector Creates Business Value
id column, so edited rows can be pushed back through the Sync tab with type-aware coercion for integers, floats, booleans, and relational fields.Connect Odoo Data to the Workbook Your Team Already Uses
Excel Connector is designed for everyday Excel work, not just a one-time export. The same Odoo module can serve the interactive Office taskpane for model browsing and write-back, while also exposing Power Query routes for desktop refresh scenarios and larger reporting flows.
id column enforced, which keeps later sync operations predictable.What is Excel Connector?
Excel Connector is a native Odoo 19 module that lets users connect Microsoft Excel directly to live Odoo data. It provides the manifest and taskpane for an Office Add-in, secure API-key authentication, model and field discovery, preview-based imports, and controlled write-back from edited Excel rows back into Odoo.
It also covers the admin side of the integration. Users can rotate keys, download the manifest, open the add-in URL, use desktop Power Query discover and script endpoints, execute read-only SQL queries, and review access activity from My Connection, Manage Connections, Access Logs, and connector settings.
KeyFeatures
Everything needed to browse, import, refresh, and update Odoo data from Excel
Excel Connector serves the Office Add-in manifest XML and the full taskpane user interface directly from Odoo, so users can connect Excel without running a Node.js service, browser plugin, or separate middleware layer. It keeps deployment simpler while still giving Excel users an interactive panel for live Odoo data access.
Imported sheets include the record id column so the Sync tab can read edited Excel
rows and push them back to existing Odoo records. The connector handles batch updates, per-row
result messages, and type coercion for integers, floats, booleans, and relational IDs.
Search accessible Odoo models from Excel and work only with the objects the connected user is allowed to read.
Select the exact columns to preview and import while still seeing field labels, technical names, and data types.
Check the returned rows first, then create a clean named Excel Table with autofit and the id column pinned in place.
SELECT queries from Excel and import the result set into a fresh worksheet.
How It Works
From module install to a working Excel connection in four practical steps
Install Excel Connector in Odoo, then open Excel Connector and go to My Connection to prepare a user-specific key.
Download the manifest for the Office Add-in or copy the Power Query URLs and M script shown on the connection form.
Use Explorer to choose a model and fields, preview rows, and import a proper Excel Table, or load data through Power Query Desktop.
Push changes back to Odoo, run safe SQL reads, review Access Logs activity, rotate keys when needed, and clean old logs.
Feature Deep Dive
Explore Excel Connector in the exact areas Excel users and Odoo admins work in most
Module Configuration
This screenshot shows the Odoo configuration page used to control the base URL, request limit, access logging, and maintenance actions for the connector.
Configure the Odoo base URL shared with users, define the maximum records per request, enable access logging, and clean old logs from one admin screen.
Connection and URL Details
These screenshots show the My Connection page where users get their API key, manifest URL, taskpane URL, and Power Query links before moving into Excel.
This full My Connection screen shows the user API key, the connector owner details, the add-in and taskpane links, the step-by-step Excel connection guide, and the Power Query URLs.
This view highlights the Taskpane URL field that users copy or use to open the hosted Excel taskpane linked to their personal API key.
Add-in Setup in Excel
These screenshots walk through the sideload process in Excel, from locating the manifest file to opening the installed Odoo Excel Studio add-in and taskpane.
This screenshot focuses on the Add-in Manifest URL and the My Connection navigation so users can identify the exact manifest link needed for Excel sideloading.
This step shows the downloaded manifest file in the Windows Downloads folder before it is uploaded into Excel.
This screenshot shows the Excel Add-ins entry and the More Add-ins action used to start the add-in upload flow.
In the Office Add-ins dialog, the user opens Manage My Add-ins and selects Upload My Add-in to sideload the manifest.
This file picker step shows the downloaded manifest being selected before opening it inside the upload dialog.
After choosing the manifest file, the user confirms the Upload action to install the Odoo Excel Studio add-in into Excel.
Once installed, the Odoo Excel Studio action appears in Excel under the menu, confirming that the add-in is available to launch.
This screenshot shows the add-in taskpane already opened in Excel and connected, with the Explorer tab ready to browse available Odoo models.
Fetch Data from Odoo
These screenshots cover the Explorer workflow inside the taskpane, from choosing a model to previewing data and importing the result into Excel.
This Explorer screen shows the contact model selected, fields loaded, preview data displayed, and the import action ready inside the taskpane.
This step focuses on searching for the target object or model in Explorer and reloading the fields for the selected model.
After the request is prepared, the taskpane displays the returned rows in the Data Preview section so users can verify the dataset before import.
This screen shows the imported Odoo rows now inserted into an Excel table while the taskpane confirms how many records were loaded.
Push Changes Back to Odoo
These screenshots show the write-back workflow after data is already in Excel, including editing a row and validating the change on the Odoo side.
This screenshot shows an edited Excel table row with the Sync tab open and the Push Changes to Odoo action ready to send the updates.
This Odoo contact form is used to verify that the pushed change from Excel was successfully written back to the original record.
SQL Query Workflow
These screenshots show the read-only SQL flow inside Excel, from writing a query to executing it and importing the returned rows into a sheet.
This screenshot shows the SQL Query tab after running a query, with the returned rows already visible inside the taskpane.
This step shows the SQL editor inside the taskpane with a sample query prepared before execution.
After running the query, the taskpane shows the returned columns and rows so the user can confirm the result before importing it.
This final SQL step shows the SQL result inserted into its own Excel sheet while the taskpane confirms the import.
History and Access Logs
These screenshots show the in-Excel history trail and the Odoo-side access log used to audit connector activity.
The History tab in the taskpane shows the latest fetch, SQL, and sync actions performed during the Excel session.
This Odoo access log view tracks connector actions such as fetch data, get fields, list models, and SQL queries together with user, model, field count, and returned records.
Version 19.0.1.0.0
The current Excel Connector build focuses on a production-ready Excel workflow: self-hosted add-in delivery, live model browsing, controlled write-back, read-only SQL, desktop Power Query support, and stronger admin visibility from inside Odoo.
Recent Improvements
Recent releases fixed the taskpane push bug around table scope, added no-table fallback
support for older sheets, tightened Office JS sequencing, enforced the id
column during import, and improved cache-control so Excel is less likely to serve stale UI code.
Changelog Snapshot
Version 2.2 added cache headers, push fixes, selector fixes, and cleaner menu naming. Version 2.1 improved write-back handling, type coercion, Office JS loading order, and SQL and write endpoints. Version 1.0.0 introduced the original explorer, import flow, and audit log.
Release Snapshot
id column.SELECT queries only, so it is designed for read-only analysis rather than unrestricted database modification.
Built for Daily Spreadsheet Work,
Not Just a Demo Connection
Use it for interactive Excel imports, repeatable write-back workflows, desktop Power Query refreshes, and controlled read access to Odoo data. If you are testing on a local machine, configure a stable public base URL first so the manifest, taskpane, and Power Query routes all point to the correct Odoo address.
Talk to echoBitz About Your Excel Connector Setup
If you want help with deployment, spreadsheet workflow design, token governance, Odoo reporting structure, or connector customization, our team can support implementation and rollout.
Our Services
Odoo Integration
Connect Odoo with external systems, reporting tools, office workflows, and operational platforms more cleanly.
Odoo Implementation
Plan, configure, and deploy Odoo around reporting-ready business processes and practical day-to-day usage.
Customization
Extend views, reports, data structures, and connector behavior to match your exact operational needs.
Community Apps
Use robust apps and reusable components to expand Odoo faster without rebuilding every feature from zero.
Development Outsourcing
Bring in dedicated Odoo development capacity for connectors, reporting, automation, and long-term platform work.
Support & Maintenance
Keep your connector, reporting setup, and related Odoo workflows healthy with reliable support and updates.
Discover More Solutions by echoBitz IT
Explore our other Odoo integration apps
Sync contacts, deals, activities, and pipelines between Odoo and PipeDrive.
Bidirectional sync of leads, contacts, accounts, and activities with Zoho CRM.
Connect contacts, companies, deals, and marketing workflows between HubSpot and Odoo.
Sync Zendesk tickets, customers, and organizations with Odoo Helpdesk and contacts.
Connect calendar, contacts, tasks, and emails with Microsoft 365 services.
Bidirectional sync of products, orders, customers, inventory, and payments.
Ready to connect Excel directly with your Odoo data?
Install Excel Connector and start browsing live models, importing Excel-ready tables, pushing updates back to Odoo, and managing the whole connection lifecycle from inside your Odoo database.
Odoo Proprietary License v1.0 This software and associated files (the "Software") may only be used (executed, modified, executed after modifications) if you have purchased a valid license from the authors, typically via Odoo Apps, or if you have received a written agreement from the authors of the Software (see the COPYRIGHT file). You may develop Odoo modules that use the Software as a library (typically by depending on it, importing it and using its resources), but without copying any source code or material from the Software. You may distribute those modules under the license of your choice, provided that this license is compatible with the terms of the Odoo Proprietary License (For example: LGPL, MIT, or proprietary licenses similar to this one). It is forbidden to publish, distribute, sublicense, or sell copies of the Software or modified copies of the Software. The above copyright notice and this permission notice must be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
Please log in to comment on this module