Odoo Spreadsheet Dashboard: Live Metrics on Top of Business Data

Introduction

Odoo Spreadsheet Dashboard amplifies the rest of the suite: dashboards, documents, Studio, and IoT only create value when sales, stock, and finance data is already trustworthy.

Teams adopt Odoo for transactions first, then ask for better insight and tailored screens, which is where platform apps and careful customization enter.

Spreadsheet Dashboard helps leaders and power users shape how information is presented and accessed without breaking the core data model underneath.

COOs, product owners, and internal Odoo champions evaluating the next layer of maturity will see when to extend standard apps versus when to call for expert help.

Spreadsheet Dashboard is part of Odoo's modular ERP. Teams adopt it when they want clear responsibilities, repeatable workflows, and searchable history instead of isolated messages and offline spreadsheets. Odoo Spreadsheet Dashboard: Live Metrics on Top of Business Data states the storyline for.

This article is a ranked Top 10 from Level 1 (easy) to Level 10 (expert). Every level includes numbered steps: what you would actually click in Odoo Spreadsheet Dashboard.

Start where you are comfortable, not at level 10 because it sounds impressive.

Read the challenge section next, then open the level that matches your team today.

In this guide, you will see:

• What Odoo Spreadsheet Dashboard is responsible for in a typical company stack
• Where teams feel the most friction today (and why)
• Ten ranked use cases from beginner discipline to advanced strategy
• When automation or integrations justify bringing in an Odoo partner

The Challenge

Leadership opens a beautiful dashboard, then asks why the cash number does not match accounting. Someone built a view on incomplete data, and now every meeting starts with trust issues, not decisions.

Leaders want insight and tailored processes, but data and customization sprawl without governance. Dashboards and Studio changes only help when they sit on reliable transactional data.

Sound familiar? Teams usually hit these walls:

• KPIs that do not match operational reality
• Customization without sandbox discipline
• Integrations that break silently after upgrades

The good news: you do not need a big-bang project to fix everything. Pick one use case below, run it for 30 days in Odoo Spreadsheet Dashboard, and measure what changes.

Top 10 Spreadsheet Dashboard Use Cases

10 use cases for Odoo Spreadsheet Dashboard, ranked from Level 1 (easy, do it this afternoon) to Level 10 (expert). Each one answers: what would we build, and what are the clicks in Odoo?

Level 1 is the easy daily win. The last level is intentionally over the top so you see how far the same app can scale when architecture and data stay clean.

Pick your level, follow the numbered steps in a test database, then move up when the previous level feels boring.

1. Create your first Spreadsheet and save it in Documents Level 1 — Easy

Level 1 is the simplest possible Spreadsheet action: open a blank file, type a few numbers, write one formula, save it in a Documents workspace. No Odoo data yet, just the editor and one owner.

Here's how you'd do it in Odoo:

1. Go to Documents, Spreadsheets, New Spreadsheet, and rename the file Q1 Planning.
2. Type sales targets per month in cells B2 to B4 and a formula =SUM(B2:B4) in cell B5.
3. Apply bold and a euro number format on the total row using the toolbar.
4. Click File, Save, and pick the Documents workspace Finance as the storage location.
5. Click Share, add one colleague with Can View access, and copy the shareable link.

What you get: You have a real Odoo file owned by a workspace, not a personal Excel attachment lost in someone's inbox.

2. Insert a live pivot from a Sales report Level 2 — Easy

Level 2 introduces the core Spreadsheet feature: any list or pivot view in Odoo can be pushed live into a spreadsheet that auto-refreshes when the source data changes.

Here's how you'd do it in Odoo:

1. Go to Sales, Reporting, Sales Analysis, and switch to Pivot view.
2. Set Rows to Salesperson and Columns to Order Month for the current quarter.
3. Click the cloud icon Insert in Spreadsheet and choose New Spreadsheet named Sales by Rep Q1.
4. The pivot appears with one ODOO.PIVOT formula per cell, refreshable from Data, Refresh All.
5. Save and reopen the next day; figures reflect new orders without any export.

What you get: Live sales numbers in the spreadsheet without ever exporting a CSV again, and the same file feeds every chart you add next.

3. Add a chart on top of an inserted pivot Level 3 — Easy

Level 3 takes the live pivot from Level 2 and turns it into a chart so the team reads the trend without scrolling rows of numbers.

Here's how you'd do it in Odoo:

1. Open the Sales by Rep Q1 spreadsheet from Level 2.
2. Select the pivot range A1 to E10 and click Insert, Chart.
3. Pick Bar Chart, set Title to Revenue per Rep Q1, and stack series by month.
4. Drag the chart to a clean area, resize to half the screen, and lock the chart position.
5. Right-click the chart, Copy as Image, and paste it in a Discuss channel for the Monday standup.

What you get: The team reads one chart in two seconds instead of twenty rows, and the chart updates whenever the underlying Sales data changes.

4. Build custom KPIs with ODOO.PIVOT and ODOO.LIST formulas Level 4 — Medium

Level 4 introduces the formula layer. ODOO.PIVOT and ODOO.LIST pull any field from any model, so you build KPIs that do not exist as a click-through report.

Here's how you'd do it in Odoo:

1. On a new tab, type =ODOO.PIVOT(1, price_total, salesperson_id, Alice) to fetch one rep total.
2. Use the formula assistant panel to autocomplete model and field names from the current pivot.
3. Add =ODOO.LIST(1, 5, name, partner_id) to list the five biggest open quotations.
4. Combine formulas: =ODOO.PIVOT(...) / COUNTIF(...) to compute Average Deal Size per rep.
5. Add a Definitions tab documenting each formula so finance trusts the numbers.

What you get: Custom KPIs no built-in Odoo report covers, refreshed live with the rest of the database and reproducible across reps and periods.

5. Combine Sales, Inventory and Purchase pivots in one sheet Level 5 — Medium

Level 5 uses Spreadsheet's ability to mix pivots from different apps on one tab to compute real cross-functional KPIs.

Here's how you'd do it in Odoo:

1. Open Sales, Reporting, Sales Analysis (Pivot), Insert in Spreadsheet, file Margin View.
2. Open Inventory, Reporting, Stock Valuation, Insert in Spreadsheet, same file as a new tab.
3. Open Purchase, Reporting, Bills Analysis, Insert in Spreadsheet, same file again on a third tab.
4. On a Summary tab, subtract Purchase cost from Sales revenue per product family with ODOO.PIVOT formulas.
5. Color-code margins above 30 percent green and below 10 percent red with conditional formatting.

What you get: Gross margin per product family, sourced from three different Odoo apps, recomputed every morning with no manual reconciliation.

6. Publish the spreadsheet as a shared Dashboard Level 6 — Medium

Level 6 introduces the Dashboards menu. Any spreadsheet can be published as a dashboard, shown next to Sales or CRM dashboards, and restricted to a specific user group.

Here's how you'd do it in Odoo:

1. Open the Margin View spreadsheet, click File, Add to Dashboard.
2. Pick the Dashboard group Finance Leadership and the section Monthly Review.
3. Choose which tabs are visible to viewers: hide the raw data tabs, show only the Summary tab.
4. Set viewer access to read-only so users cannot edit formulas by accident.
5. Verify in Dashboards, Finance Leadership that the dashboard appears for the right users only.

What you get: One spreadsheet becomes a governed dashboard, ready for the monthly board pack without copy-paste between tools.

7. Add Global Filters that refresh every pivot at once Level 7 — Hard

Level 7 introduces Spreadsheet Global Filters. One date or team filter at the top of the file drives every pivot, every chart, every ODOO.* formula on every tab.

Here's how you'd do it in Odoo:

1. Open the dashboard, go to Data, Filters, New Filter.
2. Create a Date filter Period with options This Month, Last Month, Quarter to Date, Last Quarter.
3. Create a Relation filter Sales Team linked to crm.team with multi-select enabled.
4. Map each filter to the matching field on every inserted pivot: date_order, team_id.
5. Test by switching Period to Last Quarter and confirm every pivot and chart on every tab refreshes.

What you get: The reader changes one dropdown and the entire 5-tab dashboard refreshes, no formula edits and no second spreadsheet copy needed.

8. Schedule snapshots and keep a full audit trail Level 8 — Hard

Level 8 uses Spreadsheet version history and Documents retention rules for audit-friendly recurring reports.

Here's how you'd do it in Odoo:

1. Open File, Version History, Name Version Closing March to freeze the current state.
2. On the Documents workspace, set a Retention Rule of 24 months on the spreadsheet record.
3. Configure a Server Action under Settings, Technical, Automation Rules to refresh the file every Monday at 7 a.m.
4. Add a second Server Action that emails the dashboard PDF to a recipient list every Monday at 8 a.m.
5. Each quarter, open Version History, compare two snapshots side by side, and attach the diff to the audit folder.

What you get: The board pack is signed, dated, stored, and reproducible, and nobody has to ask which version was sent to which committee.

9. Build an executive cockpit with one-click drill-down Level 9 — Hard

Level 9 turns the spreadsheet into a live cockpit. Every KPI is clickable, opens the underlying record in Odoo, and the whole cockpit is embedded in a Knowledge article.

Here's how you'd do it in Odoo:

1. On each KPI cell, right-click, See Records to confirm the drill-down opens the right Odoo list view.
2. Add hyperlinks on KPI cards using =HYPERLINK(/odoo/sales, Open pipeline) for direct navigation.
3. Create a Knowledge article Exec Cockpit, click Insert, Spreadsheet View, and embed the dashboard inline.
4. Grant Read access to the Knowledge article to the Executive Committee group only.
5. Set the article as the default home page in Settings, Companies so leadership lands on it at login.

What you get: Leaders read live KPIs and drill into the source record without opening a second tab, and one home page replaces five scattered bookmarks.

Wiring drill-downs, Knowledge embeds and Odoo access groups together is exactly the kind of cross-app configuration Dasolo runs as a partner-led engagement.

10. Run a 13-week cockpit with Studio automations and AI commentary Level 10 — Expert

Level 10 is the full operating system: Spreadsheet fed by CRM, Sales, Purchase, Accounting and HR, refreshed by server actions, alerting humans on KPI breaks, with AI-generated commentary at the top of each tab.

Here's how you'd do it in Odoo:

1. Build a 13-week cash model with ODOO.PIVOT formulas pulling collections, disbursements and payroll per week.
2. Add three scenario tabs Best, Base, Worst driven by a single input range so finance toggles between them in one click.
3. Studio Automation: when week-13 cash drops under 60 days of payroll, create an Activity on the CFO record with the link.
4. Connect an external AI service via Custom HTTP Action that reads the dashboard JSON each Monday and posts a 5-line commentary in Discuss.
5. Embed the cockpit in a Knowledge CFO Home page, restrict access to the Board group, and rotate version names every quarter.
6. Add conditional formatting alerts: red highlight on any KPI off-target plus a Discuss ping to the KPI owner.
7. Quarterly, archive the snapshot in Documents, attach to board minutes, and reset baselines for the next period.

What you get: The CFO and the board read one live cockpit with AI commentary and automatic alerts, so the monthly close meeting becomes a decision meeting, not a data-gathering meeting.

Designing 13-week models, Studio automations, AI commentary loops, Knowledge embeds and alerting rules together is the architecture Dasolo designs as a partner-led engagement. Most teams need an outside team to assemble these pieces correctly the first time.

When Expert Help Makes Sense

If levels 1 to 6 fit your world, you can often succeed with standard Odoo Spreadsheet Dashboard, a patient internal owner, and a sandbox where people are allowed to break things safely.

From level 7 upward, the stakes rise: automated workflows that email the wrong customer, Studio fields that block upgrades, APIs that silently stop syncing stock at 2 a.m.

That is not a failure of your team. It is a signal that architecture, testing, and governance matter.

Bring in a partner when you need multi-app design, country-specific compliance, complex integrations, or a go-live date the board already put in the calendar.

Work With Dasolo

Dasolo helps companies implement Odoo the way they actually work: custom apps, clean integrations, and training people will remember after the consultants leave.

If your roadmap for Spreadsheet Dashboard includes the advanced use cases in this guide, we can map a phased plan: quick wins first, then automation and integrations with clear owners and test scripts.

You keep control of scope and budget. We bring the Odoo depth so your team does not learn expensive lessons in production.

Book a free consultation:

Schedule your demo