+- Sick Gaming (https://www.sickgaming.net)
+-- Forum: Programming (https://www.sickgaming.net/forum-76.html)
+--- Forum: Python (https://www.sickgaming.net/forum-83.html)
+--- Thread: [Tut] How to Install xlrd in Python? (/thread-103551.html)
[Tut] How to Install xlrd in Python? - xSicKxBot - 12-01-2025
[Tut] How to Install xlrd in Python?
<div>
<div class="kk-star-ratings kksr-auto kksr-align-left kksr-valign-top" data-payload='{"align":"left","id":"457130","slug":"default","valign":"top","ignore":"","reference":"auto","class":"","count":"2","legendonly":"","readonly":"","score":"5","starsonly":"","best":"5","gap":"5","greet":"Rate this post","legend":"5\/5 - (2 votes)","size":"24","title":"How to Install xlrd in Python?","width":"142.5","_legend":"{score}\/{best} - ({count} {votes})","font_factor":"1.25"}'>
<div class="kksr-stars">
<div class="kksr-stars-inactive">
<div class="kksr-star" data-star="1" style="padding-right: 5px">
<div class="kksr-icon" style="width: 24px; height: 24px;"></div>
</p></div>
<div class="kksr-star" data-star="2" style="padding-right: 5px">
<div class="kksr-icon" style="width: 24px; height: 24px;"></div>
</p></div>
<div class="kksr-star" data-star="3" style="padding-right: 5px">
<div class="kksr-icon" style="width: 24px; height: 24px;"></div>
</p></div>
<div class="kksr-star" data-star="4" style="padding-right: 5px">
<div class="kksr-icon" style="width: 24px; height: 24px;"></div>
</p></div>
<div class="kksr-star" data-star="5" style="padding-right: 5px">
<div class="kksr-icon" style="width: 24px; height: 24px;"></div>
</p></div>
</p></div>
<div class="kksr-stars-active" style="width: 142.5px;">
<div class="kksr-star" style="padding-right: 5px">
<div class="kksr-icon" style="width: 24px; height: 24px;"></div>
</p></div>
<div class="kksr-star" style="padding-right: 5px">
<div class="kksr-icon" style="width: 24px; height: 24px;"></div>
</p></div>
<div class="kksr-star" style="padding-right: 5px">
<div class="kksr-icon" style="width: 24px; height: 24px;"></div>
</p></div>
<div class="kksr-star" style="padding-right: 5px">
<div class="kksr-icon" style="width: 24px; height: 24px;"></div>
</p></div>
<div class="kksr-star" style="padding-right: 5px">
<div class="kksr-icon" style="width: 24px; height: 24px;"></div>
</p></div>
</p></div>
</div>
<div class="kksr-legend" style="font-size: 19.2px;"> 5/5 – (2 votes) </div>
</p></div>
<p>The Python <code>xlrd</code> library reads data and formatting information from Excel files in the historical <code>.xls</code> format. Note that it won’t read anything other than <code>.xls</code> files. </p>
<pre class="EnlighterJSRAW" data-enlighter-language="raw" data-enlighter-theme="" data-enlighter-highlight="" data-enlighter-linenumbers="" data-enlighter-lineoffset="" data-enlighter-title="" data-enlighter-group="">pip install xlrd</pre>
<p>The Python <strong><code>xlrd</code> </strong>library is among the top 100 Python libraries, with more than <strong>17,375,582</strong> downloads. This article will show you everything you need to install this in your Python environment.</p>
<p><img decoding="async" src="https://s.w.org/images/core/emoji/14.0.0/72x72/1f517.png" alt="?" class="wp-smiley" style="height: 1em; max-height: 1em;" /> <a title="https://pypi.org/project/xlrd" href="https://pypi.org/project/xlrd" target="_blank" rel="noreferrer noopener">Library Link</a><br /><img decoding="async" src="https://s.w.org/images/core/emoji/14.0.0/72x72/1f517.png" alt="?" class="wp-smiley" style="height: 1em; max-height: 1em;" /> <a href="https://www.python-excel.org/">Other Excel Python Libraries</a></p>
<p>Alternatively, you may use any of the following commands to install <code>xlrd</code>, depending on your concrete environment. One is likely to work!</p>
<pre class="wp-block-preformatted"><img decoding="async" src="https://s.w.org/images/core/emoji/14.0.0/72x72/1f4a1.png" alt="?" class="wp-smiley" style="height: 1em; max-height: 1em;" /> <em>If you have only one version of Python installed:</em>
<code><strong>pip install xlrd</strong></code> <img decoding="async" src="https://s.w.org/images/core/emoji/14.0.0/72x72/1f4a1.png" alt="?" class="wp-smiley" style="height: 1em; max-height: 1em;" /> <em>If you have Python 3 (and, possibly, other versions) installed:</em>
<code><strong>pip3 install xlrd</strong></code> <img decoding="async" src="https://s.w.org/images/core/emoji/14.0.0/72x72/1f4a1.png" alt="?" class="wp-smiley" style="height: 1em; max-height: 1em;" /> <em>If you don't have PIP or it doesn't work</em>
<code><strong>python -m pip install xlrd
python3 -m pip install xlrd</strong></code> <img decoding="async" src="https://s.w.org/images/core/emoji/14.0.0/72x72/1f4a1.png" alt="?" class="wp-smiley" style="height: 1em; max-height: 1em;" /> <em>If you have Linux and you need to fix permissions (any one):</em>
<code><strong>sudo pip3 install xlrd
pip3 install xlrd </strong>--<strong>user</strong></code> <img decoding="async" src="https://s.w.org/images/core/emoji/14.0.0/72x72/1f4a1.png" alt="?" class="wp-smiley" style="height: 1em; max-height: 1em;" /> <em>If you have Linux with apt</em>
<code><strong>sudo apt install xlrd</strong></code> <img decoding="async" src="https://s.w.org/images/core/emoji/14.0.0/72x72/1f4a1.png" alt="?" class="wp-smiley" style="height: 1em; max-height: 1em;" /> <em>If you have Windows and you have set up the <code>py</code> alias</em>
<code><strong>py -m pip install xlrd</strong></code> <img decoding="async" src="https://s.w.org/images/core/emoji/14.0.0/72x72/1f4a1.png" alt="?" class="wp-smiley" style="height: 1em; max-height: 1em;" /> <em>If you have Anaconda</em>
<code><strong>conda install -c anaconda xlrd</strong></code> <img decoding="async" src="https://s.w.org/images/core/emoji/14.0.0/72x72/1f4a1.png" alt="?" class="wp-smiley" style="height: 1em; max-height: 1em;" /> <em>If you have Jupyter Notebook</em>
<code><strong>!pip install xlrd</strong></code>
<code><strong>!pip3 install xlrd</strong></code></pre>
<p>Let’s dive into the installation guides for the different operating systems and environments!</p>
<h2 class="wp-block-heading">How to Install xlrd on Windows?</h2>
<ol>
<li>Type <code>"cmd"</code> in the search bar and hit <code>Enter</code> to open the command line.</li>
<li>Type “<code>pip install xlrd</code>” (without quotes) in the command line and hit <code>Enter</code> again. This installs xlrd for your default Python installation.</li>
<li>The previous command may not work if you have both Python versions 2 and 3 on your computer. In this case, try <code>"pip3 install xlrd"</code> or “<code>python -m pip install xlrd</code>“.</li>
<li>Wait for the installation to terminate successfully. It is now installed on your Windows machine.</li>
</ol>
<p>Here’s how to open the command line on a (German) Windows machine:</p>
<figure class="wp-block-image size-full"><img decoding="async" fetchpriority="high" width="986" height="852" src="https://blog.finxter.com/wp-content/uploads/2021/09/image-96.png" alt="Open CMD in Windows" class="wp-image-35703" srcset="https://blog.finxter.com/wp-content/uploads/2021/09/image-96.png 986w, https://blog.finxter.com/wp-content/uploads/2021/09/image-96-300x259.png 300w, https://blog.finxter.com/wp-content/uploads/2021/09/image-96-768x664.png 768w" sizes="(max-width: 986px) 100vw, 986px" /></figure>
<p>First, try the following command to install <strong>xlrd</strong> on your system:</p>
<pre class="EnlighterJSRAW" data-enlighter-language="powershell" data-enlighter-theme="" data-enlighter-highlight="" data-enlighter-linenumbers="" data-enlighter-lineoffset="" data-enlighter-title="" data-enlighter-group="">pip install xlrd</pre>
<p>Second, if this leads to an error message, try this command to install <strong>xlrd</strong> on your system:</p>
<pre class="EnlighterJSRAW" data-enlighter-language="powershell" data-enlighter-theme="" data-enlighter-highlight="" data-enlighter-linenumbers="" data-enlighter-lineoffset="" data-enlighter-title="" data-enlighter-group="">pip3 install xlrd</pre>
<p>Third, if both do not work, use the following long-form command:</p>
<pre class="EnlighterJSRAW" data-enlighter-language="generic" data-enlighter-theme="" data-enlighter-highlight="" data-enlighter-linenumbers="" data-enlighter-lineoffset="" data-enlighter-title="" data-enlighter-group="">python -m pip install xlrd</pre>
<p>The difference between <code>pip</code> and <code>pip3</code> is that <code>pip3</code> is an updated version of <code>pip</code> for Python <a href="https://blog.finxter.com/how-to-check-your-python-version/" target="_blank" rel="noreferrer noopener" title="HOW TO CHECK YOUR PYTHON VERSION">version </a>3. Depending on what’s first in the <code>PATH</code> variable, <code>pip</code> 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 <code>pip3</code>, which will always refer to your default Python 3 installation.</p>
<h2 class="wp-block-heading">How to Install xlrd on Linux?</h2>
<p>You can install xlrd on Linux in four steps:</p>
<ol>
<li>Open your Linux terminal or shell</li>
<li>Type “<code>pip install xlrd</code>” (without quotes), hit Enter.</li>
<li>If it doesn’t work, try <code>"pip3 install xlrd"</code> or “<code>python -m pip install xlrd</code>“.</li>
<li>Wait for the installation to terminate successfully. </li>
</ol>
<p>The package is now installed on your Linux operating system.</p>
<h2 class="wp-block-heading">How to Install xlrd on macOS?</h2>
<p>Similarly, you can install xlrd on macOS in four steps:</p>
<ol>
<li>Open your macOS terminal.</li>
<li>Type “<code>pip install xlrd</code>” without quotes and hit <code>Enter</code>.</li>
<li>If it doesn’t work, try <code>"pip3 install xlrd"</code> or “<code>python -m pip install xlrd</code>“.</li>
<li>Wait for the installation to terminate successfully. </li>
</ol>
<p>The package is now installed on your macOS.</p>
<h2 class="wp-block-heading">How to Install xlrd in PyCharm?</h2>
<p>Given a <a href="https://blog.finxter.com/pycharm-a-simple-illustrated-guide/" target="_blank" rel="noreferrer noopener">PyCharm </a>project. How to install the xlrd library in your project within a <a href="https://blog.finxter.com/python-virtual-environments-with-venv-a-step-by-step-guide/" target="_blank" rel="noreferrer noopener">virtual environment</a> or globally? Here’s a <a href="https://blog.finxter.com/how-to-install-a-library-on-pycharm/" target="_blank" rel="noreferrer noopener">solution </a>that always works:</p>
<ul>
<li>Open <code><strong>File > Settings > Project</strong></code> from the PyCharm menu.</li>
<li>Select your current project.</li>
<li>Click the <code><strong>Python Interpreter</strong></code> tab within your project tab.</li>
<li>Click the small <code><strong>+</strong></code> symbol to add a new library to the project.</li>
<li>Now type in the library to be installed, in your example <code>"xlrd"</code> without quotes, and click <code><strong>Install Package</strong></code>.</li>
<li>Wait for the installation to terminate and close all pop-ups.</li>
</ul>
<p>Here’s the general package installation process as a short animated video—it works analogously for xlrd if you type in <em>“xlrd”</em> in the search field instead:</p>
<figure class="wp-block-image"><img decoding="async" src="https://media.giphy.com/media/VQoZIvOyP23tVvQlW0/source.gif" alt=""/></figure>
<p>Make sure to select only <em>“xlrd” </em>because there may be other packages that are not required but also contain the same term (<em>false positives</em>):</p>
<h2 class="wp-block-heading">How to Install xlrd in a Jupyter Notebook?</h2>
<p>To install any package in a Jupyter notebook, you can prefix the <code>!pip install my_package</code> statement with the exclamation mark <code>"!"</code>. This works for the xlrd library too:</p>
<pre class="EnlighterJSRAW" data-enlighter-language="python" data-enlighter-theme="" data-enlighter-highlight="" data-enlighter-linenumbers="" data-enlighter-lineoffset="" data-enlighter-title="" data-enlighter-group="">!pip install my_package</pre>
<p>This automatically installs the xlrd library when the cell is first executed.</p>
<h2 class="wp-block-heading">How to Resolve ModuleNotFoundError: No module named ‘xlrd’?</h2>
<p>Say you try to import the xlrd package into your Python script without installing it first:</p>
<pre class="EnlighterJSRAW" data-enlighter-language="python" data-enlighter-theme="" data-enlighter-highlight="" data-enlighter-linenumbers="" data-enlighter-lineoffset="" data-enlighter-title="" data-enlighter-group="">import xlrd
# ... ModuleNotFoundError: No module named 'xlrd'</pre>
<p>Because you haven’t installed the package, Python raises a <code>ModuleNotFoundError: No module named 'xlrd'</code>. </p>
<p>To fix the error, install the xlrd library using “<code>pip install xlrd</code>” or “<code>pip3 install xlrd</code>” in your operating system’s shell or terminal first. </p>
<p>See above for the different ways to install xlrd in your environment. Also check out my detailed article:</p>
<p class="has-base-2-background-color has-background"><img decoding="async" src="https://s.w.org/images/core/emoji/14.0.0/72x72/1f517.png" alt="?" class="wp-smiley" style="height: 1em; max-height: 1em;" /> <strong>Recommended</strong>: <a href="https://blog.finxter.com/fixed-modulenotfounderror-no-module-named-xlrd/">[Fixed] ModuleNotFoundError: No module named ‘xlrd’</a></p>
<h2 class="wp-block-heading">Improve Your Python Skills</h2>
<p>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 <a href="https://blog.finxter.com/email-academy/" title="Email Academy" target="_blank" rel="noreferrer noopener">free email academy</a> with cheat sheets, regular tutorials, and programming puzzles.</p>
<p>Join us, it’s fun! <img decoding="async" src="https://s.w.org/images/core/emoji/14.0.0/72x72/1f642.png" alt="?" class="wp-smiley" style="height: 1em; max-height: 1em;" /></p>
<p class="has-base-2-background-color has-background"><img decoding="async" src="https://s.w.org/images/core/emoji/14.0.0/72x72/2705.png" alt="✅" class="wp-smiley" style="height: 1em; max-height: 1em;" /> <strong>Recommended</strong>: <a href="https://blog.finxter.com/python-excel-basic-worksheet-operations/">Python Excel – Basic Worksheet Operations</a></p>
<p>The post <a rel="nofollow" href="https://blog.finxter.com/how-to-install-xlrd-in-python/">How to Install xlrd in Python?</a> appeared first on <a rel="nofollow" href="https://blog.finxter.com">Be on the Right Side of Change</a>.</p>
</div>
https://www.sickgaming.net/blog/2023/09/26/how-to-install-xlrd-in-python/