How do I create a report in Excel Odoo 12?

Prerequisites
  1. You must have python 3 installed in your system.
  2. You must have Odoo 12 already running in your System.
  3. Download and Add this module in the addons folder, Base Report XLSX.
  4. You have installed the xlsxwriter package in your system.

How do I create an XLS file?

How to Create XLS Files
  1. Open the Microsoft Excel program on your computer. Enter all of your desired data into the Microsoft Excel spreadsheet.
  2. Click on “File.” Select “Save As.” Enter the name that you would like for your Excel spreadsheet to be saved as.
  3. Click the “File Type” drop down menu. Select the “. XLS” file extension.

How do you import data from Excel to Odoo?

You can import data on any Odoo’s business object using either Excel (. xlsx) or CSV (. csv) formats: contacts, products, bank statements, journal entries and even orders! Open the view of the object you want to populate and click on Favorites ‣ Import records.