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
π‘ If you don't have PIP or it doesn't workopenpyxl
python -m pip install
π‘ If you have Linux and you need to fix permissions (any one):openpyxl
python3 -m pip installopenpyxl
sudo pip3 install
π‘ If you have Linux with aptopenpyxl
pip3 installopenpyxl
--usersudo apt install
π‘ If you have Windows and you have set up theopenpyxl
py
aliaspy -m pip install
π‘ If you have Anacondaopenpyxl
conda install -c anaconda
π‘ If you have Jupyter Notebookopenpyxl
!pip install
openpyxl
!pip3 install
openpyxl
How to Install openpyxl on Windows?
- Type
"cmd"
in the search bar and hitEnter
to open the command line. - Type “
pip install openpyxl
” (without quotes) in the command line and hitEnter
again. This installs openpyxl for your default Python installation. - 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
“. - 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:
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:
- Open your Linux terminal or shell
- Type “
pip install openpyxl
” (without quotes), hit Enter. - If it doesn’t work, try
"pip3 install openpyxl"
or “python -m pip install openpyxl
“. - 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:
- Open your macOS terminal.
- Type “
pip install openpyxl
” without quotes and hitEnter
. - If it doesn’t work, try
"pip3 install openpyxl"
or “python -m pip install openpyxl
“. - 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 clickInstall 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! π