How to Install openpyxl in Python?

by 
pip install openpyxl

The Python openpyxl library is among the top 100 Python libraries, with more than 31,880,691 downloads. This article will show you everything you need to get this installed in your Python environment.

Alternatively, you may use any of the following commands to install openpyxl, depending on your concrete environment. One is likely to work!

💡 If you have only one version of Python installed:
pip install openpyxl

💡 If you have Python 3 (and, possibly, other versions) installed:
pip3 install openpyxl

💡 If you don't have PIP or it doesn't work
python -m pip install openpyxl
python3 -m pip install openpyxl

💡 If you have Linux and you need to fix permissions (any one):
sudo pip3 install openpyxl
pip3 install openpyxl --user

💡 If you have Linux with apt
sudo apt install openpyxl

💡 If you have Windows and you have set up the py alias
py -m pip install openpyxl

💡 If you have Anaconda
conda install -c anaconda openpyxl

💡 If you have Jupyter Notebook
!pip install openpyxl
!pip3 install openpyxl

How to Install openpyxl on Windows?

  1. Type "cmd" in the search bar and hit Enter to open the command line.
  2. Type “pip install openpyxl” (without quotes) in the command line and hit Enter again. This installs openpyxl for your default Python installation.
  3. The previous command may not work if you have both Python versions 2 and 3 on your computer. In this case, try "pip3 install openpyxl" or “python -m pip install openpyxl“.
  4. Wait for the installation to terminate successfully. It is now installed on your Windows machine.

Here’s how to open the command line on a (German) Windows machine:

Open CMD in Windows

First, try the following command to install openpyxl on your system:

pip install openpyxl

Second, if this leads to an error message, try this command to install openpyxl on your system:

pip3 install openpyxl

Third, if both do not work, use the following long-form command:

python -m pip install openpyxl

The difference between pip and pip3 is that pip3 is an updated version of pip for Python version 3. Depending on what’s first in the PATH variable, pip will refer to your Python 2 or Python 3 installation—and you cannot know which without checking the environment variables. To resolve this uncertainty, you can use pip3, which will always refer to your default Python 3 installation.

How to Install openpyxl on Linux?

You can install openpyxl on Linux in four steps:

  1. Open your Linux terminal or shell
  2. Type “pip install openpyxl” (without quotes), hit Enter.
  3. If it doesn’t work, try "pip3 install openpyxl" or “python -m pip install openpyxl“.
  4. Wait for the installation to terminate successfully.

The package is now installed on your Linux operating system.

How to Install openpyxl on macOS?

Similarly, you can install openpyxl on macOS in four steps:

  1. Open your macOS terminal.
  2. Type “pip install openpyxl” without quotes and hit Enter.
  3. If it doesn’t work, try "pip3 install openpyxl" or “python -m pip install openpyxl“.
  4. Wait for the installation to terminate successfully.

The package is now installed on your macOS.

How to Install openpyxl in PyCharm?

Given a PyCharm project. How to install the openpyxl library in your project within a virtual environment or globally? Here’s a solution that always works:

  • Open File > Settings > Project from the PyCharm menu.
  • Select your current project.
  • Click the Python Interpreter tab within your project tab.
  • Click the small + symbol to add a new library to the project.
  • Now type in the library to be installed, in your example "openpyxl" without quotes, and click Install Package.
  • Wait for the installation to terminate and close all pop-ups.

Here’s the general package installation process as a short animated video—it works analogously for openpyxl if you type in “openpyxl” in the search field instead:

Make sure to select only “openpyxl” because there may be other packages that are not required but also contain the same term (false positives):

How to Install openpyxl in a Jupyter Notebook?

To install any package in a Jupyter notebook, you can prefix the !pip install my_package statement with the exclamation mark "!". This works for the openpyxl library too:

!pip install my_package

This automatically installs the openpyxl library when the cell is first executed.

How to Resolve ModuleNotFoundError: No module named ‘openpyxl’?

Say you try to import the openpyxl package into your Python script without installing it first:

import openpyxl
# ... ModuleNotFoundError: No module named 'openpyxl'

Because you haven’t installed the package, Python raises a ModuleNotFoundError: No module named 'openpyxl'.

To fix the error, install the openpyxl library using “pip install openpyxl” or “pip3 install openpyxl” in your operating system’s shell or terminal first.

See above for the different ways to install openpyxl in your environment.

Improve Your Python Skills

If you want to keep improving your Python skills and learn about new and exciting technologies such as Blockchain development, machine learning, and data science, check out the Finxter free email academy with cheat sheets, regular tutorials, and programming puzzles.

Join us, it’s fun! 🙂