Join us at GITEX 2025! Discover our solutions at Hall 4, Booth H-30 Schedule a Meeting Today.
Automate Marketing Initiatives with Salesforce Marketing Cloud Learn More
Join us at GITEX 2024! Discover our solutions at Hall 4, Booth H-30 Book your live demo today.
Odoo Connector App

Odoo Excel Connector — Live Data Sync Between Odoo and Your Desktop Spreadsheet

Connect Odoo directly to Microsoft Excel and LibreOffice Calc for real-time data synchronization. Generate token-secured ODC files and sync URLs, apply advanced filters, and refresh live Odoo data in your spreadsheet — without manual exports or third-party middleware.

Compatible with Odoo 16, 17, 18 & 19
Works with Excel & LibreOffice Calc
Trusted by 500+ Businesses Across 12+ Countries
Community & Enterprise Supported
No Custom Development Required
$29.87
V19, 18, 17, 16
Odoo Excel Connector Interface

What is Odoo Excel Connector?

Odoo Excel Connector is a bridge module that establishes a live data connection between your Odoo instance and desktop spreadsheet applications — Microsoft Excel and LibreOffice Calc. Instead of exporting CSV files, downloading them, and manually importing into spreadsheets on a recurring basis, this module creates persistent sync links that your spreadsheet refreshes on demand or on a schedule. The connector works through ODC (Office Data Connection) files and shareable web URLs, both secured by unique access tokens.

Excel & LibreOffice
Token-Secured
Pre-built Templates
Live Refresh
No Middleware

How Odoo Excel Connector Eliminates the Manual Export Cycle

Problem
Zehntech Solution
Teams export CSVs from Odoo repeatedly throughout the day
Persistent sync URLs and ODC files let users refresh live data directly in Excel or LibreOffice
Exported data is immediately stale — reflecting only the moment it was downloaded
Real-time connection pulls current Odoo data each time the spreadsheet refreshes
No security controls on exported files once they leave Odoo
Token-based authentication ensures only authorized users can access data through sync links
Every user configures their own export fields and filters from scratch each time
Reusable pre-configured templates standardize exports across the entire team
Standard Odoo export has no filtering beyond the current list view
Advanced domain rules, custom field selection, and sort ordering applied at the template level
No visibility into who is pulling data or when
Full audit trail logs every template creation, modification, and access event
Only users with Odoo access can retrieve the data they need for analysis
Shareable ODC files and URLs allow spreadsheet access without requiring Odoo logins
Admin teams cannot control who creates or modifies export configurations
Role-based access restricts template management to managers while users consume data

Connect Once. Refresh Forever. Control Everything.

1

Direct Excel & LibreOffice Integration

Establish a live data connection between Odoo and your desktop spreadsheet through ODC files or sync URLs. Excel and LibreOffice Calc both natively consume these connections — no plugins or middleware required.

Why it matters: your team works in the tools they already know while accessing real-time Odoo data.

2

Pre-Configured Export Templates

Choose from ready-made templates covering Sales, Accounting, and CRM modules, or build custom templates for any Odoo model. Templates define field selection, filter criteria, and data sorting.

Why it matters: standardized templates ensure consistent data output and save hours of repetitive setup.

3

Advanced Domain-Based Filtering

Apply precise domain rules to control exactly which records appear in each export. Combine multiple filter conditions, select specific fields, and define sort order at the template level.

Why it matters: your spreadsheet receives only the records that matter — no post-download filtering.

4

Token-Based Security

Every export session is protected by a unique access token generated per template. Tokens authenticate each data request, ensuring only authorized connections can retrieve Odoo data.

Why it matters: token-secured connections maintain data governance even after the link leaves your Odoo instance.

5

Role-Based Access Control

Manager-level restrictions control who can create, modify, or delete export templates. Standard users consume data through approved templates without the ability to alter configurations.

Why it matters: IT and management maintain control over what data is exposed externally.

6

Complete Audit Trail

Every template creation, modification, and deletion is logged with timestamps and user identifiers. The audit history provides full traceability for compliance and security reviews.

Why it matters: when regulatory audits require proof of who accessed what data — the history is captured.

7

Multiple Export Formats

Deliver data through web URLs for browser-based access, ODC files for direct spreadsheet integration, or CSV for maximum compatibility with any tool.

Why it matters: different teams have different requirements — all are served from one template.

8

Manual & Scheduled Synchronization

Refresh data manually with a single click when you need current numbers, or configure scheduled synchronization that pulls fresh data at defined intervals.

Why it matters: teams needing real-time data can refresh on demand while recurring workflows run automatically.

9

Shareable Sync URLs

Generate web-accessible URLs that authorized users can paste into any spreadsheet application or browser. URLs are portable, easy to distribute, and work across devices.

Why it matters: remote teams or external consultants can access approved data without needing Odoo accounts.

10

No Third-Party Dependencies

The connector operates natively between Odoo and standard spreadsheet applications. No external APIs, cloud services, or middleware platforms are required.

Why it matters: you avoid ongoing subscription costs and reduce failure points in your data pipeline.

Who Gets The Most Out Of This Module

Role
Primary Use Case
Key Outcome
Finance Controller
Connect Excel workbooks to Odoo accounting data for real-time revenue and expense tracking
Financial analysis spreadsheets always reflect current numbers — no daily CSV re-exports
Sales Manager
Provide the sales team with live pipeline and order data refreshable in their existing Excel dashboards
Pipeline reviews use live data instead of yesterday's export — decisions based on current reality
Operations Director
Feed warehouse and procurement data into operational planning spreadsheets via scheduled sync
Planning models update automatically, removing manual data gathering from the morning routine
External Auditor
Access token-secured financial data through shareable URLs without requiring an Odoo login
Audit data access is controlled, logged, and does not require provisioning Odoo user accounts
Business Analyst
Pull CRM, sales, and inventory data into LibreOffice for cross-module analysis with pivot tables
Complex multi-model analysis happens in the spreadsheet tool of choice with always-fresh data
IT Administrator
Configure approved export templates and control data access through role-based permissions
Data governance is maintained while business teams get self-service access to approved datasets
Procurement Manager
Sync purchase order and vendor data to Excel for spend analysis and supplier comparisons
Procurement analytics run on current data without depending on IT for recurring data extracts

Versions & Documentation

Select your Odoo version to access the interactive user guide.

Documentation coming soon for Odoo 17.
Documentation coming soon for Odoo 18.
Documentation coming soon for Odoo 19.

Native Odoo Export vs Zehntech Odoo Excel Connector

Capability
Zehntech Excel Connector
Native Odoo
Live data connection to Excel and LibreOffice
✔ Available
Not available
ODC file generation for direct spreadsheet integration
✔ Available
Not available
Shareable sync URLs for remote data access
✔ Available
Not available
Token-based authentication per export session
✔ Available
Not available
Pre-configured reusable export templates
✔ Available
Not available
Advanced domain-based record filtering
✔ Available
Basic only
Custom field selection and sort ordering
✔ Available
Limited
Role-based access for template management
✔ Available
Not available
Full audit trail of template changes and access
✔ Available
Not available
Scheduled automatic data synchronization
✔ Available
Not available
Multiple output formats (URL, ODC, CSV)
✔ Available
CSV only
Works without third-party middleware
✔ Available
N/A
Refresh data without re-running export process
✔ Available
Not available

Get Connected In Minutes

No development environment. No middleware setup. No third-party accounts required.

01

Purchase & Install

Purchase Odoo Excel Connector from the Odoo App Store. Install from the Apps menu — dependencies are resolved automatically. No server restart required.

02

Create an Export Template

Open the Excel Connector menu. Select your target Odoo module, choose the fields to include, define domain-based filters, and set the sort order.

03

Generate Sync Credentials

The module generates a unique access token and creates your choice of output: a sync URL, downloadable ODC file, or CSV endpoint.

04

Connect Your Spreadsheet

Open the ODC file in Excel or LibreOffice Calc. Refresh data manually or configure scheduled sync intervals for automatic updates.

Technical Details & Compatibility

Requirement
Odoo Versions
Editions
Hosting
Dependencies
Third-Party Dependencies
Spreadsheet Compatibility
Custom Dev Required
Install Time
Server Restart
Data Migration
Module Conflicts
License
Last Tested
Lines of Code
Support
Details
16.0 · 17.0 · 18.0 · 19.0
Community · Enterprise · Odoo.sh
Odoo Online · On-Premise · Odoo.sh
Contacts · Discuss · Invoicing
None
Microsoft Excel · LibreOffice Calc
No
Under 5 minutes
Not required
Not required
None known
OPL-1
Odoo 19.0 — May 2026
688
Odoo Excel Connector FAQ

Frequently Asked Questions

The module generates ODC (Office Data Connection) files or shareable sync URLs that establish a live link between your spreadsheet and Odoo. When you open the ODC file in Excel or LibreOffice, it automatically connects to your Odoo instance and pulls the configured data. Each refresh pulls current Odoo data — no repeated CSV downloads or manual import steps.
Yes. Every export template generates a unique access token that authenticates each data request. Only connections presenting a valid token can retrieve data through the sync URL or ODC file. Role-based access restricts template creation and modification to manager-level users. A complete audit trail logs all configuration changes for compliance and security review.
Yes. The connector supports both Microsoft Excel and LibreOffice Calc as client applications. ODC files, sync URLs, and CSV exports are all compatible with both platforms. No additional plugins or extensions are required in either spreadsheet application. The same template serves users on either platform without separate configuration.
Odoo Excel Connector supports versions 16.0, 17.0, 18.0, and 19.0. All hosting types are compatible: Odoo Online, Odoo.sh, and On-Premise deployments. Both Community and Enterprise editions are fully supported across all versions. No additional server-side software or third-party services are required.
Yes. Each template provides advanced domain-based filtering to define which records are included. You select specific fields from the target model, controlling exactly which columns appear in the spreadsheet. Sort ordering is configurable at the template level, determining how data is arranged in the output. These settings persist across every refresh, ensuring consistent results without reconfiguration.

Ready to Eliminate the Manual Export Cycle?

One-Time Purchase. No Subscription. No Recurring Fees.

Your team already works in Excel and LibreOffice — Odoo Excel Connector brings live Odoo data directly into those tools without middleware, manual exports, or developer involvement. Configure once, refresh forever, and maintain full security and audit control over every data connection.

Includes lifetime updates and 90 days of dedicated technical support.

Odoo Excel Connector


          You have successfully subscribed to the newsletter

          There was an error while trying to send your request. Please try again.

          Zehntech will use the information you provide on this form to be in touch with you and to provide updates and marketing.