Hi,

Please refer to the blog:

https://www.cybrosys.com/blog/import-xlsx-files-in-odoo-using-openpyxl

Hope it helps.

Problem:

You installed openpyxl (for Excel imports), but Odoo still doesn’t recognize it. Here’s how to fix it easily.

Why This Happens

Odoo uses its own Python environment, so installing openpyxl globally (with regular pip) won’t work. You need to install it where Odoo can see it.

Step-by-Step Fix

1. Find Odoo’s Python Path

• If you installed Odoo manually, its Python is usually in:
  bash

  /path/to/odoo-venv/bin/python  # Example path

• If you used apt/docker, Odoo’s Python might be:
  bash

  /usr/bin/python3

2. Install openpyxl Correctly

Run:

bash

# For manual installations (venv):
source /path/to/odoo-venv/bin/activate  # Activate Odoo’s environment
pip install openpyxl

# For system-wide installations:
sudo /usr/bin/python3 -m pip install openpyxl

3. Verify Installation

Check if Odoo can see openpyxl:

bash

/path/to/odoo/python -c "import openpyxl; print('Success!')"

(If you see Success!, it’s installed correctly.)

4. Restart Odoo

• Linux (systemd):
  bash

  sudo systemctl restart odoo

• Docker:
  bash

  docker-compose restart odoo

• Manual: Stop and restart Odoo manually.

Still Not Working?

• Permission Issues: Ensure Odoo’s user has access:
  bash

  sudo chown -R odoo:odoo /path/to/odoo-venv

• Check odoo.conf: Ensure no weird Python path settings exist.

Done!

Your Excel imports should now work. 🎉

🚀 Did This Solve Your Problem?

If this answer helped you save time, money, or frustration, consider:

✅ Upvoting (👍) to help others find it faster

✅ Marking as "Best Answer" if it resolved your issue

Your feedback keeps the Odoo community strong! 💪

(Need further customization? Drop a comment—I’m happy to refine the solution!)