Product Features
- Easy Direct Connection between OdootoMicrosoft Excel
- Ease of Automated Data Export
- Execute custom SQL Query
- Token based secure connection
Easy Installation
Enter URL & Token provided after installing the connector
Import All Data from Odoo
View your Odoo data in Microsoft Excel
Secure Connection
Secure token based connection
SQL Query Execution
Custom SQL Query Execution
The Excel Connector for Odoo is a robust Microsoft add-in crafted to enable a smooth link between Odoo and Excel. It allows data retrieval in two distinct methods: table-wise and through SQL queries. This flexibility ensures that users can manage, manipulate, and report data effectively according to their specific requirements.
Screenshots
with
1. Create Odoo Connection
To connect, enter your Odoo Backend URL and Access Token into the taskpane interface.
1. Create Odoo Connection
To connect, enter your Odoo Backend URL and Access Token into the taskpane interface.
2. Fetch data by tables
Search & select odoo tables to fetch
2. Fetch data by tables
Search & select odoo tables to fetch
3. Run custom SQL query
Execute custom SQL query and add a new sheet
3. Run custom SQL query
Execute custom SQL query and add a new sheet
1. Create Odoo Connection
To connect, enter your Odoo Backend URL and Access Token into the taskpane interface.
2. Fetch data by tables
Search & select odoo tables to fetch
3. Run custom SQL query
Execute custom SQL query and add a new sheet
Custom Dashboards
Unlock the power of data with personalized dashboards. We create customized Power BI dashboards that cater to your specific business needs, helping you track performance, visualize key metrics, and make data-driven decisions with ease.
Tailored for Your Needs
- Interactive charts and graphs
- Real-time data updates
- Fully customizable to your KPIs
- Accessible on any device