$ 35.09
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Lines of code | 262 |
| Technical Name |
ewall_excel_connector |
| License | OPL-1 |
| Website | https://www.ewallsolutions.com |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Lines of code | 262 |
| Technical Name |
ewall_excel_connector |
| License | OPL-1 |
| Website | https://www.ewallsolutions.com |
Data Connection From Odoo to Excel
Data Connection From Odoo to Excel: Live Data Sharing with Custom Fields and Filters
Data Connection From Odoo to Excel
This Odoo extension simplifies external data access by allowing users to generate secure, token-based web URLs that export filtered data from any Odoo model as a live CSV feed. Whether you're working in LibreOffice Calc, this connector lets you pull real-time Odoo records directly into your spreadsheets-no need for manual exports. With a few clicks, users can choose the model, select fields, apply custom filters, and instantly create an external data link. The solution supports multiple models like Sales Orders, Contacts, Projects, and more, making it ideal for reporting, analysis, or collaborative planning. Designed for both technical teams and business users, this module ensures flexibility without compromising on security. Each link is unique, access-controlled via token, and suitable for dynamic, refreshable spreadsheet views of your Odoo data.
Purpose of the "Data Connection From Odoo to Excel" Module
- Generate Live Data Links for Any Model: Create secure, token-based URLs to access filtered model data directly as CSV-ideal for external tools like LibreOffice.
- Select Custom Fields & Apply Filters: Choose the exact fields to export and set conditions with Odoo's domain filter, ensuring the data you share is relevant and controlled.
- One-Click Integration Setup: Adds barcode flexibility without disrupting Odoo's core product or inventory logic, making it easy for teams to adopt.
- Enhance Reporting & Collaboration: Empower teams to work with real-time data outside Odoo for reporting, analysis, or syncing with third-party systems without compromising access control.
Create Odoo Excel Connector Template from Contact
From the Contact's Action menu, click "Create Odoo Excel Connector Template" to generate a web-connected data export.
Customize Fields, Filters, and Model
A popup wizard lets you configure the target model, select fields, and apply domain filters for dynamic CSV export.
Access External Data in LibreOffice
In LibreOffice, go to Sheet -> External Links to start connecting your spreadsheet to live data from Odoo.
Paste URL and Import Live Data
Paste the generated web URL, press Enter, and click OK to import data directly into your spreadsheet.
View Live Data with Auto-Refresh
Your spreadsheet now displays live Odoo data and can auto-refresh every few seconds for real-time updates.
Generate Odoo Excel Connector Template from Sale Orders
From the Sale Order view, use the "Create Odoo Excel Connector Template" button to export order data with custom fields.
Create Template for Invoices
In the Invoice module, generate a live Excel-compatible data connector using the same "Create Odoo Excel Connector Template" option
Export Project Data Instantly
In the Projects app, click "Create Odoo Excel Connector Template" to build a live data URL for project-specific records.
Manage Odoo Excel Connector Templates in Settings
Under Settings -> Users, easily review and manage all created Odoo Excel Connector Templates for seamless integration.
Apps May You Like
For Support Contact
support@ewallsolutions.com
Don't hesitate to reach out if you have any further questions or need assistance!
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