ModuleNotFoundError: No module named 'openpyxl' in Python

avatar

Borislav Hadzhiev

Mon Apr 18 20224 min read

banner

Photo by Dorota Sleuth

ModuleNotFoundError: No module named 'openpyxl' in Python #

The Python "ModuleNotFoundError: No module named 'openpyxl'" occurs when we forget to install the openpyxl module before importing it or install it in an incorrect environment. To solve the error, install the module by running the pip install openpyxl command.

no module named openpyxl

Open your terminal in your project's root directory and install the openpyxl module.

shell
# ๐Ÿ‘‡๏ธ in a virtual environment or using Python 2 pip install openpyxl # ๐Ÿ‘‡๏ธ for python 3 (could also be pip3.10 depending on your version) pip3 install openpyxl # ๐Ÿ‘‡๏ธ if you get permissions error sudo pip3 install openpyxl # ๐Ÿ‘‡๏ธ if you don't have pip in your PATH environment variable python -m pip install openpyxl # ๐Ÿ‘‡๏ธ for python 3 (could also be pip3.10 depending on your version) python3 -m pip install openpyxl # ๐Ÿ‘‡๏ธ for Anaconda conda install -c anaconda openpyxl

After you install the openpyxl package, try importing it like:

main.py
import datetime from openpyxl import Workbook wb = Workbook() ws = wb.active ws['A1'] = 42 ws.append([1, 2, 3]) ws['A2'] = datetime.datetime.now() wb.save("sample.xlsx")

The Python error "ModuleNotFoundError: No module named 'openpyxl'" occurs for multiple reasons:

  1. Not having the openpyxl package installed by running pip install openpyxl.
  2. Installing the package in a different Python version than the one you're using.
  3. Installing the package globally and not in your virtual environment.
  4. Your IDE running an incorrect version of Python.
  5. Naming your module openpyxl.py which would shadow the official module.
  6. Declaring a variable named openpyxl which would shadow the imported variable.

If the error persists, get your Python version and make sure you are installing the package using the correct Python version.

shell
python --version

get python version

For example, my Python version is 3.10.4, so I would install the openpyxl package with pip3.10 install openpyxl.

shell
pip3.10 install openpyxl # ๐Ÿ‘‡๏ธ if you get permissions error use pip3 (NOT pip3.X) sudo pip3 install openpyxl

Notice that the version number corresponds to the version of pip I'm using.

If the PATH for pip is not set up on your machine, replace pip with python3 -m pip:

shell
# ๐Ÿ‘‡๏ธ make sure to use your version of Python, e.g. 3.10 python3 -m pip install openpyxl

If the "No module named 'openpyxl'" error persists, try restarting your IDE and development server / script.

You can check if you have the openpyxl package installed by running the pip show openpyxl command.

shell
# ๐Ÿ‘‡๏ธ check if you have openpyxl installed pip3 show openpyxl # ๐Ÿ‘‡๏ธ if you don't have pip setup in PATH python3 -m pip show openpyxl

The pip show openpyxl command will either state that the package is not installed or show a bunch of information about the package, including the location where the package is installed.

If the package is not installed, make sure your IDE is using the correct version of Python.

If you have multiple Python versions installed on your machine, you might have installed the openpyxl package using the incorrect version or your IDE might be setup to use a different version.

For example, In VSCode, you can press CTRL + Shift + P or (โŒ˜ + Shift + P on Mac) to open the command palette.

Then type "Python select interpreter" in the field.

python select interpreter

Then select the correct python version from the drop down menu.

select correct python version

Your IDE should be using the same version of Python (including the virtual environment) that you are using to install packages from your terminal.

If you are using a virtual environment, make sure you are installing openpyxl in your virtual environment and not globally.

You can try creating a virtual environment if you don't already have one.

shell
# ๐Ÿ‘‡๏ธ use correct version of Python when creating VENV python3 -m venv venv # ๐Ÿ‘‡๏ธ activate on Unix or MacOS source venv/bin/activate # ๐Ÿ‘‡๏ธ activate on Windows (cmd.exe) venv\Scripts\activate.bat # ๐Ÿ‘‡๏ธ activate on Windows (PowerShell) venv\Scripts\Activate.ps1 # ๐Ÿ‘‡๏ธ install openpyxl in virtual environment pip install openpyxl

Your virtual environment will use the version of Python that was used to create it.

If the error persists, make sure you haven't named a module in your project as openpyxl.py because that would shadow the original openpyxl module.

You also shouldn't be declaring a variable named openpyxl as that would also shadow the original module.

If the error is not resolved, try to uninstall the openpyxl package and then install it.

shell
# ๐Ÿ‘‡๏ธ check if you have openpyxl installed pip3 show openpyxl # ๐Ÿ‘‡๏ธ if you don't have pip setup in PATH python3 -m pip show openpyxl # ๐Ÿ‘‡๏ธ uninstall openpyxl pip3 uninstall openpyxl # ๐Ÿ‘‡๏ธ if you don't have pip setup in PATH python3 -m pip uninstall openpyxl # ๐Ÿ‘‡๏ธ install openpyxl pip3 install openpyxl # ๐Ÿ‘‡๏ธ if you don't have pip setup in PATH python3 -m pip install openpyxl

Try restarting your IDE and development server / script.

You can also try to upgrade the version of the openpyxl package.

shell
pip3 install openpyxl --upgrade # ๐Ÿ‘‡๏ธ if you don't have pip setup in PATH python3 -m pip install openpyxl --upgrade
If the error persists, I would suggest watching a quick video on how to use Virtual environments in Python.

This one is for using using virtual environments (VENV) on Windows:

This one is for using using virtual environments (VENV) on MacOS and Linux:

Use the search field on my Home Page to filter through my more than 1,000 articles.

Copyright ยฉ 2022 Borislav Hadzhiev