I want to know if there's a way to replicate a spreadsheet from one Odoo to another one.
E.g: I create a sales spreadsheet using my data (with lists, pivot tables, charts and other visualizations) and want to export it or save it to use it with other database. For example, I have another Odoo and want to import this spreadsheet to replicate it.
Is this possible?
In Odoo V18 when in ?debug=1 mode, there is an option to export to JSON (file --> Download as JSON).
I have used this to migrate spreadsheets from test/dev to production
It's not possible.
Create an account today to enjoy exclusive features and engage with our awesome community!
Registracija| Related Posts | Replies | Rodiniai | Veikla | |
|---|---|---|---|---|
|
2
rugs. 25
|
3272 | ||
|
2
kov. 24
|
7073 | ||
|
|
1
kov. 24
|
4524 | ||
|
1
liep. 25
|
2300 | ||
|
0
saus. 25
|
2429 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
Yes, but with some limitations. Odoo’s spreadsheet (formerly Odoo Studio Spreadsheet / Pivot & Graph views) is not fully portable between databases by default. Here’s what you need to know:
1. Export/Import Limitations
You cannot directly export a spreadsheet view with all pivots, charts, and formulas and import it into another Odoo database like a file.
Standard CSV/XLSX exports only include raw data, not pivot structures, formulas, or visualizations.
2. Possible Workarounds
A. Duplicate the spreadsheet within the same database
Use “Save as Template” if available in Odoo 16+. This allows you to reuse the spreadsheet layout in the same DB.
B. Recreate in the new database using Studio
Export the raw data (CSV/XLSX).
Import into the new DB.
Recreate the spreadsheet layout, pivots, and charts using the spreadsheet app or Studio.
C. Technical approach (Advanced)
If you have developer access, you can export the spreadsheet definitions from the spreadsheet.sheet and related models via XML or a custom module.
This requires knowledge of Odoo module development, and formulas/visualizations may need adjustments.
✅ TL;DR:
Direct replication of spreadsheets between Odoo databases is not supported natively.
You can export/import raw data and rebuild the spreadsheet or use custom modules to transfer spreadsheet definitions.