$ 99.31
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
Discuss (mail)
|
| Lines of code | 979 |
| Technical Name |
eb_odoo_microsoft_excel_integration |
| License | OPL-1 |
| Website | https://www.echobitzit.com |
| Versions | 17.0 18.0 19.0 |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
Discuss (mail)
|
| Lines of code | 979 |
| Technical Name |
eb_odoo_microsoft_excel_integration |
| License | OPL-1 |
| Website | https://www.echobitzit.com |
| Versions | 17.0 18.0 19.0 |
Advance Odoo Excel
Connector
Odoo Excel Connector turns saved Odoo views into secure, reusable live data feeds for Microsoft Excel, LibreOffice Calc, Power BI, and spreadsheet-style reporting workflows. Build export templates with selected fields, domain filters, record limits, and token-based links, then share one-click ODC files, direct CSV / TSV / JSON endpoints, and copyable live URLs without forcing users through repeated manual export work.
Why Teams Choose Odoo Excel Connector
How Odoo Excel Connector Creates Business Value
Connect Odoo Data to Real Spreadsheet Work
Create a saved export template, download the ODC for Excel, or share the direct live URL. This module is designed for business reporting, refreshable workbooks, and low-friction data access from Odoo without rebuilding the same export every time.
What is Odoo Excel Connector?
Odoo Excel Connector is a native Odoo 19 module that lets you publish controlled, spreadsheet-friendly exports directly from Odoo. A user can build a template for any installed model, choose the fields to expose, apply a domain filter, set a record limit, and then generate a secure live endpoint for Excel or other reporting tools.
It also acts as the operational layer for export governance inside Odoo. Templates have owners, tokens, activity history, preview counts, direct download actions, access statistics, access logs, and maintenance tools so teams can keep reporting flexible without losing control of who is exposing what.
KeyFeatures
Everything needed to turn Odoo records into refreshable spreadsheet outputs
Generate a one-click ODC file from a saved template so Excel users can open a connection, load live Odoo data through Power Query, and refresh later without rebuilding the integration. This is the headline workflow for teams that live in Excel but need reliable Odoo-backed reporting.
Every template can publish a direct live endpoint for CSV, TSV, or JSON, making the same Odoo definition reusable across desktop spreadsheets, BI tools, and lightweight data-consumption flows.
Limit output to exactly the records you want by saving Odoo domains directly on the template.
Choose the exact columns exposed to downstream files and tools instead of sending every field from the Odoo model.
Regenerate the access token anytime to immediately invalidate old spreadsheet or BI connections.
How It Works
From Odoo installation to live Excel-ready reporting in four simple steps
Install the connector in Odoo and open the Excel Connector menu or launch the wizard from a model action menu.
Choose the model, fields, filter domain, record limit, format, and any tags needed for that reporting workflow.
Download the ODC for Excel, copy the live URL, or test the feed in a browser before handing it to business users.
Monitor access, rotate tokens when needed, clear logs, and keep workbook-based reporting aligned with Odoo permissions.
Feature Deep Dive
Explore the Excel Connector in the exact areas teams use most
Configuration and Template Setup
These screenshots show how users launch the connector, configure the export template, review the generated template page, and manage the connector settings inside Odoo.
From the contact form, open the Action menu and click Export to Excel / ODC. This makes the connector easy to start directly from the record users are already working on.
The wizard lets the user choose the model, export type, template name, record limit, and the fields to export. It also gives quick actions to download the ODC file, download CSV, or generate the live URL.
After saving, the template page shows the Odoo model, exported fields, filter domain, record limit, access token, live URL, owner, access count, and shortcut buttons for all supported download options.
In the configuration screen, administrators can define the public base URL, default record limit, enable access logging, and clean old logs to keep template usage controlled and maintainable.
Microsoft Excel Data Fetch Using ODC File
This is the quickest Excel workflow. The connector generates an ODC file, Excel opens it as a Microsoft Office Data Connection, and users can enable the connection to load live Odoo data.
Microsoft Excel Workbooks
The main business story of this module is Excel. Download the ODC, open it in Excel, load the data into a workbook, then let users refresh the sheet later without creating a new export each time.
LibreOffice and Lightweight Spreadsheet Flows
When an ODC file is not the right fit, the live URL can still be consumed as CSV or TSV for alternate spreadsheet tools and external link workflows.
Power BI and Data Modeling
JSON output gives teams a cleaner option for Power BI-style ingestion where a structured feed is preferable to flat-file exports. That makes the same template useful for both operational workbooks and downstream analytics models.
Typical Use Cases
The template page includes a dedicated Download ODC (.odc) button so users can generate the Microsoft Excel connection file directly from Odoo.
After download, Windows shows the saved file with the Microsoft Office Data Connection type, confirming that the connector generated the correct Excel-ready file format.
Excel displays a security notice before opening external data connections. Click Enable to allow the workbook to fetch data from the Odoo connector.
Once enabled, Excel loads the exported Odoo columns and records into the sheet, giving users a refreshable workbook connected to the template they created in Odoo.
To see the live connection in action, simply add a new contact or update an existing record in Odoo that matches the template's criteria.
In Excel, open the Data ribbon and click Refresh All. Excel immediately requests the latest data from the live Odoo connector URL.
After refreshing, the newly added Odoo record is immediately visible in your Excel table, ensuring business users always work with the most up-to-date information.
LibreOffice Calc Data Fetch
This flow uses the generated CSV data URL inside LibreOffice Calc so users can link external data and refresh spreadsheet content directly from Odoo.
The saved template page provides a ready-to-use Data URL and a Download CSV action, which is the starting point for LibreOffice Calc integration.
In LibreOffice Calc, go to Sheet and choose Link to External Data so the spreadsheet can pull the exported data from the connector URL.
Paste the copied URL into the URL of External Data Source field. LibreOffice will then inspect the endpoint and look for available tables or ranges.
If your team prefers a file-based import, the downloaded CSV can also be opened from the file picker. This gives LibreOffice users both live-link and downloaded-file options.
Once LibreOffice reads the endpoint, the connector exposes the available table range. Select the CSV entry so Calc knows which returned dataset should be inserted.
After confirming the import, LibreOffice inserts the connector data into the worksheet with the exported columns and records ready for reporting or further analysis.
Microsoft Excel Data Fetch Using Data From Web URL
Users can also fetch the connector output through Excel's built-in From Web option by pasting the generated data URL instead of using the ODC file.
In the Data ribbon, select From Web. This starts a direct web-based import using the connector URL generated from Odoo.
Paste the live Odoo data URL into the From Web dialog and confirm it. Excel will connect to the endpoint and prepare the response for preview.
Excel displays the connector response in the preview window, where users can quickly inspect the rows and then click Load to insert the data into the workbook.
After loading, Excel creates the query connection and fills the worksheet with the Odoo data, while the Queries panel keeps the imported source visible for refreshes later.
Google Sheets Data Fetch
Google Sheets users can pull the connector data with an IMPORTDATA formula and then allow external access to populate the spreadsheet with Odoo records.
Paste the generated connector URL inside an =IMPORTDATA(...) formula. Google Sheets detects that the sheet is trying to fetch data from an external source and prompts for permission.
After approving access, Google Sheets fetches the exported columns and rows from Odoo and places them directly into the sheet for live spreadsheet reporting.
Saved Template Design
Every template stores the target model, exported fields, filter domain, record limit, format, owner, tags, token, preview count, access counters, and history. That makes the template record itself the central place for designing and governing a live reporting feed.
One-Click ODC Download
For Microsoft Excel users, the connector generates a downloadable ODC file designed for Power Query-style consumption. Business users do not need to handcraft queries or keep rebuilding connection steps every time a workbook changes hands.
Template Organization
Tags, ownership, active state, and list-view statistics make it easier for teams to keep dozens of exports organized without turning the connector into a folder of anonymous files.
Template Highlights
CSV, TSV, and JSON Endpoints
The public route serves template data through tokenized endpoints and serializes common Odoo field types into spreadsheet-friendly values. It supports CSV for Excel and Calc, TSV when tab-delimited output is preferred, and JSON for BI or custom consumption.
Owner-Aware Data Access
Records are fetched using the template owner context, so the export respects the Odoo access model that belongs to the owner who created or manages that template.
Browser Testing and Local Demos
Templates include a direct URL action for quick testing, and the controller behavior is tuned so local tunnel workflows are easier to validate during demos and pre-production setup.
Feed Benefits
Token Governance
Each template has its own access token, so sharing stays specific to the export you intended. If a workbook should stop refreshing, the token can be regenerated and the old link becomes invalid immediately.
Access Logging
When logging is enabled, the connector stores the access time, IP address, user agent, and record count for each feed request. This gives admins and template owners practical visibility into how a live link is being used.
Controlled Retention
Old logs can be cleared manually or through the scheduled cleanup job, which helps keep operational history useful without letting maintenance become another manual task.
Governance Summary
Version 19.0.1.0.0
The current release focuses on making Odoo data easier to reuse in spreadsheet and BI workflows without changing the normal user experience inside Odoo. Templates, direct downloads, live feed URLs, and admin settings all work together as one connector flow.
What This Release Delivers
This version includes saved export templates, dynamic action-menu binding for installed models, ODC generation for Excel, CSV / TSV / JSON feed support, token-based access, access logging, scheduled cleanup, and configuration options for default limits and logging.
Production Readiness Improvements
The latest build also keeps the addon lightweight by avoiding unnecessary optional dependencies, improves controller safety, centralizes log cleanup behavior, and gives admins better control over access history and token lifecycle.
Release Snapshot
Built for Daily Spreadsheet Work,
Not Just a Demo Export
Use it for controlled Excel refreshes, recurring CSV feeds, and BI-friendly JSON endpoints. If you are testing on a local machine, configure a stable public base URL first so generated links and ODC files 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.
Sync contacts, segments, and campaigns between Mailchimp and Odoo for better marketing automation.
Connect Odoo datasets to Power BI for advanced business intelligence and interactive dashboards.
Automated shipping, labeling, and real-time tracking between FedEx and Odoo.
Bidirectional sync of products, orders, customers, inventory, and payments.
Ready to make Odoo reporting easier for your team?
Install Odoo Excel Connector and start building reusable spreadsheet-ready templates with controlled live access.
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