One error you might encounter when working with Excel files in Python is:
ModuleNotFoundError: No module named 'openpyxl'
This error occurs when Python can’t find the openpyxl library in the current environment.
In this tutorial, I will show you an example that causes this error and how to fix it in practice.
How to reproduce the error
Suppose you want to use the openpyxl module to create an Excel Workbook and a Sheet as follows:
from openpyxl import Workbook
wb = Workbook()
ws = wb.active
ws1 = wb.create_sheet("Sheet")
But you get the following error when running the code:
Traceback (most recent call last):
File "main.py", line 1, in <module>
from openpyxl import Workbook
ModuleNotFoundError: No module named 'openpyxl'
To my knowledge, the ModuleNotFoundError happens when Python can’t find the module you’re trying to import.
The openpyxl module is not bundled with Python, so you need to install it first.
How to fix this error
To resolve this error, you need to install the openpyxl library using the pip install command:
pip install openpyxl
# For pip3:
pip3 install openpyxl
Once the module is installed, you should be able to run the code that imports openpyxl without receiving the error.
Install commands for other environments
The install command might differ depending on what environment you used to run the Python code.
Here’s a list of common install commands in popular Python environments to install the openpyxl module:
# if you don't have pip in your PATH:
python -m pip install openpyxl
python3 -m pip install openpyxl
# Windows
py -m pip install openpyxl
# Anaconda
conda install openpyxl
# Jupyter Notebook
!pip install openpyxl
Once the module is installed, you should be able to run the code without receiving this error.
Other common causes for this error
If you still see the error even after installing the module, it means that the openpyxl module can’t be found in your Python environment.
There are several reasons why this error can happen:
- You may have multiple versions of Python installed on your system, and you are using a different version of Python than the one where openpyxl is installed.
- You might have openpyxl installed in a virtual environment, and you are not activating the virtual environment before running your code.
- Your IDE uses a different version of Python from the one that has openpyxl
- The package is not installed in PyCharm
Let’s see how to fix these errors in practice.
1. You have multiple versions of Python
If you have multiple versions of Python installed on your system, you need to make sure that you are using the specific version where the openpyxl module is available.
You can test this by running the which -a python or which -a python3 command from the terminal:
$ which -a python3
/opt/homebrew/bin/python3
/usr/bin/python3
In the example above, there are two versions of Python installed on /opt/homebrew/bin/python3 and /usr/bin/python3.
Suppose you run the following steps in your project:
- Install openpyxl with
pipusing/usr/bin/Python version - Install Python using Homebrew, you have Python in
/opt/homebrew/ - Then you run
import openpyxlin your code
The steps above will cause the error because openpyxl is installed in /usr/bin/, and your code is probably executed using Python from /opt/homebrew/ path.
To solve this error, you need to run the pip install openpyxl command again so that openpyxl is installed and accessible by the active Python version.
2. Python virtual environment is active
Another scenario that could cause this error is you may have openpyxl installed in a virtual environment.
Python venv package allows you to create a virtual environment where you can install different versions of packages required by your project.
If you are installing openpyxl inside a virtual environment, then the module won’t be accessible outside of that environment.
You can see if a virtual environment is active or not by looking at your prompt in the terminal.
When a virtual environment is active, the name of that environment will be shown inside parentheses as shown below:
In the picture above, the name of the virtual environment (demoenv) appears, indicating that the virtual environment is currently active.
If you run pip install while the virtual environment is active, then the package is installed only for that environment
Likewise, any package installed outside of that virtual environment won’t be accessible from the virtual environment. The solution is to run the pip install command on the environment you want to use.
If you want to install openpyxl globally, then turn off the virtual environment by running the deactivate command before running the pip install command.
3. IDE using a different Python version
Finally, the IDE from where you run your Python code may use a different Python version when you have multiple versions installed.
For example, you can check the Python interpreter used in VSCode by opening the command palette (CTRL + Shift + P for Windows and ⌘ + Shift + P for Mac) then run the Python: Select Interpreter command.
You should see all available Python versions listed as follows:
You need to use the same version where you installed openpyxl so that the module can be found when you run the code from VSCode.
Once done, you should be able to import openpyxl without receiving any errors.
4. You see this error in PyCharm
If you’re using PyCharm as your IDE, then this error might occur because the package is not installed in the Python interpreter used by PyCharm.
This is because PyCharm creates a new virtual environment for each project you create using the IDE.
To resolve this error, you can install the package using PyCharm’s terminal.
For more information, you can see the guide to install and uninstall packages in PyCharm.
Conclusion
In summary, the ModuleNotFoundError: No module named 'openpyxl' occurs when the openpyxl library is not installed in your Python environment. To resolve this error, you need to run the pip install openpyxl command.
If you already have the module installed, make sure you are using the correct version of Python, check if the virtual environment is active if you have one, and check for the Python version used by your IDE.
By following these steps, you should be able to import the openpyxl module in your code successfully.
I hope you find this tutorial helpful. Until next time! 👋
