Odoo app guide · Platform & Productivity
Odoo Spreadsheet: what it does, and what’s new in 20
Odoo Spreadsheet is a spreadsheet engine inside the database: cells can hold live pivots of any Odoo data, so the monthly report rebuilds itself instead of being exported and reassembled.
It has quietly become Odoo's BI layer — dashboards, budget sheets and KPI packs that stay current without copy-paste — and it gains features every release.
30 documented changes in Odoo 20Verified against the release notes · 2026-09
The mechanics that matter in Odoo Spreadsheet
- Insert any list or pivot view as a live, refreshable data source
- Formulas over Odoo data (ODOO.* functions) mixed with regular spreadsheet math
- Dashboards assembled from sheets, shared by user group
- Templates for budgets, forecasts and consolidations that refill each period
What changed in Odoo 20 Spreadsheet
New feature 21Enhancement 7Performance 1Security 1
- Bubble chartsNew feature
- Calculated columnsNew feature
- Calendar chartsNew feature
- Cell value orientationNew feature
- ChartsEnhancement
- Column statisticsNew feature
- Conditional formatting by dateEnhancement
- Curly bracketsNew feature
- Custom formatNew feature
- Data cleanupNew feature
- Disable automatic recalculationNew feature
- Global filtersEnhancement
- List insertionNew feature
- Lock sheetsNew feature
- Mobile: pinch to zoomNew feature
- Multiple selection on figuresEnhancement
- Named rangeNew feature
- New functionsNew feature
- Pivot tablesNew feature
- Print settingsNew feature
- Property fields in inserted listsEnhancement
- Reduced JSON file sizePerformance
- Regex formulasNew feature
- Scientific notationNew feature
- Sheet background colorsNew feature
- Spill range operatorNew feature
- Template accessSecurity
- Top menu navigationEnhancement
- Top/bottom ranking conditional formattingEnhancement
- Zoom in/outNew feature
Each link opens the detailed entry — plain-words explanation, screenshots from a live Odoo 20 database, and the source-code check behind it.
Want Odoo Spreadsheet set up the way these mechanics deserve?
Senior consultants, fixed scopes, published pricing — and the team that documents these releases implements them.