Universal Excel Export - Any List to Formatted XLSX
by Jhon Jairo Rojas Ortiz https://www.linkedin.com/in/jjro$ 49.00
Universal Excel Export — Any List View to a Formatted XLSX
One click to export any Odoo list to a clean .xlsx — respecting your filters, grouping, sort and visible columns, with subtotals and a grand total. Built for big exports: 100,000+ rows stream out fast and memory-light. Works on every model, no setup.
Stop copy-pasting records or building a custom report for every export. Universal Excel Export adds an “Export to Excel” action to every list view in Odoo. The generated .xlsx mirrors exactly what is on your screen: the same records (after your filters), the same columns in the same order, and the same grouping — now with styled headers, per-group subtotals and a grand total.
It is a true dynamic Excel export that works on any model with zero configuration: sales, invoices, products, partners, stock, accounting, CRM or your own custom models. Records are streamed in batches, so even exports with 100k+ rows stay fast and light on memory.
Records are read in batches and streamed straight to the file, so exporting 100,000+ rows stays fast and won't blow up your server's memory — pull a whole year of invoices, your entire product catalog or all stock moves in a single click.
One click in the list view's Actions menu exports a clean, formatted .xlsx of what you see.
Group your list (e.g. by country) and the export keeps the groups, with subtotals.
Features
- Respects your filters — only the records you currently see are exported.
- Respects grouping with subtotals — grouped lists get a header per group and an automatic subtotal row for every numeric column.
- Grand total — a final total row sums all numeric columns across the whole export.
- Respects sort order — rows keep the exact on-screen order, including your current column sort.
- Only the columns you see — honours optional-column toggles and uses the proper field labels as headers.
- Clean, professional formatting — bold header, frozen header row, auto-fit widths; numbers, dates, booleans and selections rendered correctly.
- Big-data streaming — records read in batches and rows streamed to the file, so 100k+ row exports stay fast and memory-light.
- Works on any model — no per-model setup and no developer needed.
How it works
- Open any list view in Odoo (Sales Orders, Invoices, Products or any custom model).
- Apply the filters, grouping and sort you want — what you see is what you get.
- Open the Action menu (the cog / gear) and click “Export to Excel”.
- Your formatted .xlsx downloads instantly, with subtotals and a grand total already calculated.
Permissions & data security
Built to respect Odoo's access model — audited so nothing leaks between users or companies.
- 👤 Role-based access. The app respects Odoo's access groups — there is no portal or public exposure. Everything computes on your standard data through the app's own service, so no restricted field is ever surfaced.
- ✅ Secure by design — audited access model. Audited across the whole suite.
Keywords: export to excel Odoo, export list view to xlsx, one click excel export, Odoo excel export button, export with filters and grouping, export with subtotals and grand total, export any model to excel, download excel from Odoo, bulk export excel, formatted excel export, export large dataset Odoo, big data export fast and light, export current view to excel, custom excel report Odoo, spreadsheet export Odoo, export visible columns only, list to excel every model, export 100000 rows, Odoo report to excel, universal excel exporter.
Palabras clave: exportar a Excel Odoo, exportar vista de lista a xlsx, exportación a Excel con un clic, botón de exportar a Excel Odoo, exportar con filtros y agrupaciones, exportar con subtotales y total general, exportar cualquier modelo a Excel, descargar Excel desde Odoo, exportación masiva a Excel, exportación con formato a Excel, exportar grandes volúmenes de datos Odoo, exportación rápida y ligera de datos, exportar la vista actual a Excel, reporte personalizado en Excel Odoo, exportar a hoja de cálculo Odoo, exportar solo columnas visibles, lista a Excel en cualquier modelo, exportar 100000 filas, reporte de Odoo a Excel, exportador universal de Excel.
Works with Odoo Community and Enterprise, versions 16 to 19.
More from the author: Aski — ask your Odoo in natural language by chat or voice. aski.dev
Questions, or want a quick personalized demo? Email me at jhonrojas.dev@gmail.com — I am happy to answer questions or set up a short demo.
Support: jhonrojas.dev@gmail.com · License: OPL-1
About the author
Jhon Jairo Rojas Ortiz
Odoo developer · custom modules, integrations & business intelligence
5+ years of hands-on Odoo experience — building and shipping real modules, integrations and analytics for companies across LATAM and Europe. Every app I publish is maintained and supported personally.
Custom Odoo modulesIntegrations & APIsBI & analyticsOdoo 16–19
inConnect on LinkedIn →| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Lines of code | 385 |
| Technical Name |
jjro_universal_excel_export |
| License | OPL-1 |
| Website | https://www.linkedin.com/in/jjro |
Odoo Proprietary License v1.0 This software and associated files (the "Software") may only be used (executed, modified, executed after modifications) if you have purchased a valid license from the authors, typically via Odoo Apps, or if you have received a written agreement from the authors of the Software (see the COPYRIGHT file). You may develop Odoo modules that use the Software as a library (typically by depending on it, importing it and using its resources), but without copying any source code or material from the Software. You may distribute those modules under the license of your choice, provided that this license is compatible with the terms of the Odoo Proprietary License (For example: LGPL, MIT, or proprietary licenses similar to this one). It is forbidden to publish, distribute, sublicense, or sell copies of the Software or modified copies of the Software. The above copyright notice and this permission notice must be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
Please log in to comment on this module