Spreadsheet

• Get started
• Insert and link to Odoo data
• Work with data
  • Dynamic pivot tables
  • Functions
  • Global filters
• Present and visualize data
  • Charts

Odoo Spreadsheet allows you to organize, manipulate, analyze, and visualize data. It offers similar functionality to other spreadsheet solutions with the added benefit of integrating directly with your Odoo database.

With Odoo Spreadsheet, you can:

• create spreadsheets or upload files and open them as Odoo spreadsheets

• create and use templates

• use functions, including Odoo-specific functions

• insert and link to Odoo data

• create and use dynamic pivot tables

• filter data across multiple Odoo data sources using global filters

• visualize data using charts and formatting

• share files internally and externally

The Spreadsheet module is part of Odoo Documents.

小技巧

Within a spreadsheet, opening the command palette, using the keyboard shortcut Ctrl + K or Command + K, allows you to browse and execute spreadsheet commands via the keyboard, without having to navigate menus.

注解

Odoo spreadsheets serve as the foundation for the dashboards available in Odoo Dashboards. On a dashboard, charts and data tables are used to display dynamic Odoo data and provide an overview of key business metrics.

Standard, pre-configured dashboards can be customized by editing the dashboard’s underlying spreadsheet via Dashboards. Custom dashboards can also be created from scratch, starting from an Odoo spreadsheet; any subsequent modifications are performed via Dashboards.