SUPPORT APPS
Skip to Content

Excel Odoo Connector

by

$ 23.67

16.0 0
Live Preview
Required Apps • Discuss (mail)
Technical Name wk_excel_connector
License OPL-1
Also available in version 17.0 16.0
You bought this module and need support ? Click here!
Technical Name wk_excel_connector
License OPL-1
Also available in version v 17.0 v 16.0

Introduction

The WK Excel Connector enables robust, seamless export of Odoo data directly into MS Excel or LibreOffice Calc without requiring API setup. Using customizable export templates and tokenized URLs, this module ensures real-time access to data from any Odoo module. With synchronizable exports via ODC files or direct URL, it offers flexible, secure, and efficient data handling for reporting and analysis.

Key Features

  • Export data from any Odoo module to Excel or LibreOffice Calc using template-based configuration

  • Create export templates with model selection, custom fields, filters (domain), company, language, and assigned responsible user

  • Generate secure tokenized URLs and ODC files to link dynamic spreadsheets without APIs

  • Manage access history: track IPs, usage frequency, last accessed timestamps, and flush history as needed

  • Refresh access tokens to immediately invalidate existing connections and secure export access 

Benefits

  • Simplifies data export and analysis by integrating Odoo with familiar spreadsheet tools effortlessly

  • Eliminates need for complex API integrations or manual export/import workflows

  • Enhances security with tokenized access and history control

  • Enables real-time data synchronization between Odoo and spreadsheets

  • Saves time by automating template-based and filterable exports directly into Excel or Calc

Compatibility & Technical Details

The technical name of this module is wk_excel_connector, licensed under a proprietary license. It supports exporting data from any Odoo module. Installation involves placing the module in the Add-Ons directory, enabling developer mode, updating the apps list, and installing via the backend. After installation, you configure export templates—selecting model, fields, filters, language, company, and responsible user—to generate secure URLs or ODC files. These can be used in Excel or LibreOffice Calc for dynamic data retrieval and real-time syncing.

Odoo Excel Connector

Effortlessly Sync Odoo with Excel & LibreOffice!.

Excel Odoo Connector links your Odoo ERP with Excel and LibreOffice Calc, making it easy to sync and manage data. It offers secure templates, real-time updates, and flexible filtering for exporting and organizing data smoothly.

Information

user-guide
User Guide
https://webkul.com/blog/user-manual-of-odoo-excel-connector/

Sync Odoo Data Effortlessly

Excel Odoo Connector links Odoo with Excel or LibreOffice Calc, allowing automatic data syncing. By generating a URL or ODC file users can ensure smooth data exports for sales reports, customer info, or accounting data. The ODC files can only be used to connect Excel not LibreOffice calc. The connector simplifies data management by allowing users to create excel templates for quick and easy exports without doing it manually.

Secure Data Transfer & Management

Security is an important feature of Excel Odoo Connector. It generates access tokens to safeguard exported data and keeps track of access history to monitor connected IPs. If any unauthorized access is found, refreshing the token will disconnect all current sheets, ensuring only authorized users can access the data. This helps keep your Odoo data safe at all times.

Customizable Templates for Dynamic Exports

With Excel Odoo Connector, users can create multiple excel templates based on their specific needs. You can filter the data to export only what is necessary and schedule regular exports to keep your Excel sheets updated. This flexible setup allows users to easily manage data from different Odoo modules and sources.

Highlighted-features

Below is the detailed list of features for Excel Odoo connector

It connects Odoo with Excel

It keeps access secure with tokens

Lets you filter the data to be exported

View Tracks the ip addresses of the user

It allows you to create custom excel templates

Generate ODC files to connect with Excel

  • Screenshots
  • Detailed Features

Configuring export form in Odoo.

screenshot

Adding filters for data export.

screenshot

Managing State and Downloading ODC files.

screenshot
screenshot

Listing of templates.

screenshot

Exported data in Libre Office.

screenshot
screenshot
screenshot

Checking access history and delete all the access history.

screenshot
screenshot

Detailed Features List

Below is the list of features of Odoo Excel Connector.

Customizable excel templates

  • Create templates for specific Odoo modules like sales, accounting, and customer data.
  • Set rules for the data you want to export, giving you full control over what is exported.
  • Excel Odoo Connector lets you quickly switch templates between active and inactive states.

Data Filtering and Export Flexibility

  • Add filters to narrow down the data you want to export, making it easier to manage.
  • Pick which fields to include in your export, so your report only shows what’s important.
  • Use special rules to customize the data you export, getting exactly what you need from Odoo.

Secure Token-Based Access

  • Creates a unique access token for every export to keep the connection safe.
  • You can refresh the token anytime to block old connections and stop unauthorized access.
  • It tracks all connections and shows IP logs in the access history tab.

Seamless Data Connection with Excel and LibreOffice

  • Download an ODC file to connect Excel directly with your Odoo for real-time data updates.
  • Create a URL to sync Odoo data automatically with Excel and LibreOffice Calc.
  • Easily export and sync Odoo data across both platforms for simple reporting and data management.

Our Other Apps

Make your eCommerce Experience more better with our other Apps.


Support

Get Immediate support for any of your query

You will get 90 days free support for any doubt, queries, and bug fixing (excluding data recovery) or any type of issue related to this module.

mail

WRITE TO US AT

[email protected]

For any help and doubt or issue regarding the module, Drop a mail to our technical team.

Write To US
support-icon

RAISE A TICKET AT

https://webkul.uvdesk.com/en/customer/create-ticket/

For support or to request customization, Create A Support Ticket by copying the link and opening it in a new tab 

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.