Python: Pandas pd.read_excel giving ImportError: Install xlrd >= 0.9.0 for Excel support

Question

I am trying to read a .xlsx with pandas, but get the follwing error:

data = pd.read_excel(low_memory=False, io="DataAnalysis1/temp1.xlsx").fillna(value=0) 

Traceback (most recent call last):
  File "/Users/Vineeth/PycharmProjects/DataAnalysis1/try1.py", line 9, in <module>
    data = pd.read_excel(low_memory=False, io="DataAnalysis1/temp1.xlsx").fillna(value=0)
  File "/Users/Vineeth/venv/lib/python2.7/site-packages/pandas/util/_decorators.py", line 118, in wrapper
    return func(*args, **kwargs)
  File "/Users/Vineeth/venv/lib/python2.7/site-packages/pandas/io/excel.py", line 230, in read_excel
    io = ExcelFile(io, engine=engine)
  File "/Users/Vineeth/venv/lib/python2.7/site-packages/pandas/io/excel.py", line 263, in __init__
    raise ImportError(err_msg)
ImportError: Install xlrd >= 0.9.0 for Excel support

I've also tried

data = pd.read_excel("DataAnalysis1/temp1.xlsx", low_memory=False).fillna(value=0)

And I Still get the same error.

Background: I'm trying to extract an excel file with multiple worksheets as a dict of data frames.I installed xlrd version 0.9.0 and the latest version(1.1.0) but I still get the same error. Thanks!

Did you try listening to the error message and installing the `xlrd` package? — cs95, Jan 02 '18 at 19:13
Yes, I installed the `xlrd` package. Edit: I tried to import the package, but python gives me a `import xlrd ImportError: No module named xlrd` error — Vineeth Sai, Jan 02 '18 at 19:18
@cs95, just got same error message, point is why i got this error message when i am just using function of this library, why didn't pandas installed all its dependency library. itself :( — Achintya Ranjan Chaudhary, Apr 11 '21 at 18:39

score 156 · Answer 1 · answered Jan 02 '18 at 19:17

156

As @COLDSPEED so eloquently pointed out the error explicitly tells you to install xlrd.

pip install xlrd

And you will be good to go.

answered Jan 02 '18 at 19:17

Grr

15,553
7
65
85

7

I exactly had the same issue, I had to force re-install xlrd. pip install --upgrade --force-reinstall xlrd – Tamas Szuromi Feb 05 '18 at 13:17
8

@TamasSzuromi Unfortunately I keep having the same error message after trying both of your commands : `Install xlrd >= 0.9.0 for Excel support ` :/ – Revolucion for Monica May 14 '18 at 10:12
same here (on v 1.1.0)...and I cannot import it either, as suggested here https://stackoverflow.com/questions/51227745/importerror-install-xlrd-0-9-0-for-excel-support-when-using-pd-readexcel-to/51286813 – jjrr Nov 01 '18 at 15:39
4

tech-prism's answer below is more modern. – Parm May 19 '21 at 20:52
1

If you see this message: _Your version of xlrd is 2.0.1. In xlrd >= 2.0, only the xls format is supported. Install openpyxl instead._ Please see message from @tech-prism and go for `pip install openpyxl` – Wojciech Jakubas Dec 13 '21 at 11:25

score 117 · Answer 2 · answered Jan 06 '21 at 08:27

117

Since December 2020 xlrd no longer supports xlsx-Files as explained in the official changelog. You can use openpyxl instead:

pip install openpyxl

And in your python-file:

import pandas as pd
pd.read_excel('path/to/file.xlsx', engine='openpyxl')

answered Jan 06 '21 at 08:27

tech-prism

1,215
1
7
8

4

That is the only answer that worked for me! Thanks! I hope they accept your answer. – Charles Santana Feb 15 '21 at 23:05
1

This is exactly what I needed. My program ran fine on Python 3.9 with a newer version of pandas (1.2.3) but trying to make it compatible with python 3.6 I can only get pandas up to 1.1.5 which must still use XLRD as the default engine. Thank you for this answer! – Drew Mares Apr 09 '21 at 16:06
For me in the terminal: pip install openpyxl command, solved the issue. No need to set: engine='openpyxl' in the read_excel method. But works with it , too. Just make sure its installed on your path. – tonycor nikolauos Aug 14 '22 at 20:15

score 38 · Answer 3 · edited Jun 14 '20 at 21:50

38

Either use:

pip install xlrd

And if you are using conda, use

conda install -c anaconda xlrd

That's it. good luck.

edited Jun 14 '20 at 21:50

Gonçalo Peres

11,752
3
54
83

answered Nov 12 '18 at 14:18

E. Erfan

1,239
19
37

1

I've installed xlrd and shows up when I run `pip freeze` however still having same error message... – haneulkim Mar 10 '21 at 01:27

score 9 · Answer 4 · answered Mar 24 '21 at 22:02

9

If you are in ubuntu this work for me:

python3 -m pip install openpyxl
python3 -m pip install xlrd

answered Mar 24 '21 at 22:02

Gustavo Marquez

419
4
6

3pitt · Answer 5 · 2018-03-06T14:26:49.673

This happened to me after I ran a script with cProfile a la python3 -m cProfile script.py even though xlrd was already installed and had never thrown this error before. it persisted even under python3 script.py. (Granted, I agree this wasn't what happened to OP, given the obvious import error)

However, for cases like mine, the following fixed the issue, despite being told "requirement already met" in every case.

pip install --upgrade pandas
pip install --upgrade xlrd

Pretty confounding stuff; not sure if cProfile was the cause or just a coincidence

The following should work, assuming your pip install operated on python2.

python3 -m pip install xlrd

Omkar · Answer 6 · 2019-12-18T03:05:32.447

6

I was getting an error

"ImportError: Install xlrd >= 1.0.0 for Excel support"

on Pycharm for below code

import pandas as pd
df2 = pd.read_excel("data.xlsx")
print(df2.head(3))
print(df2.tail(3))

Solution : pip install xlrd

It resolved error after using this. Also no need to use "import xlrd"

edited Dec 18 '19 at 03:05

answered May 06 '19 at 09:59

Omkar

3,253
3
20
36

score 3 · Answer 7 · answered Dec 19 '19 at 07:54

3

This works for me: For Python 3

pip3 install xlrd --user

For Python2

pip install xlrd --user

answered Dec 19 '19 at 07:54

Minhaj Javed

913
8
20

score 2 · Answer 8 · edited Jul 25 '18 at 20:33

I don't know if this will be helpful for someone, but I had the same problem. I wrote pip install xlrd in the anaconda prompt while in the specific environment and it said it was installed, but when I looked at the installed packages it wasn't there. What solved the problem was "moving" (I don't know the terminology for it) into the Scripts folder of the specific environment and do the pip install xlrd there. Hope this is useful for someone :D

score 2 · Answer 9 · answered Jan 01 '19 at 12:24

2

Was getting the error while I was using jupyter.

ModuleNotFoundError: No module named 'xlrd'
...
ImportError: Install xlrd >= 0.9.0 for Excel support

it was resolved for me after using.

!pip install xlrd

answered Jan 01 '19 at 12:24

Santosh sanwal

134
1
4
15

score 1 · Answer 10 · edited Jun 17 '19 at 18:48

1

I encountered same problem and took 2 hours to figure it out.

pip install xlrd (latest)
pip install pandas (latest)
Go to C:\Python27\Lib\site-packages and check for xlrd folder (if there are 2 of them) delete the old version
open a new terminal and use pandas to read excel. It should work.

edited Jun 17 '19 at 18:48

Alex Myers

6,196
7
23
39

answered Jun 17 '19 at 18:20

Vivek Sh

11
1

score 1 · Answer 11 · answered Jun 01 '20 at 16:34

I had the same problem and none of the above answers worked. If you go into the settings (CTRL + ALT + s) and search for project interpreter you will see all of the installed packages. Click the + button at the top right and search for xlrd, then click install package at the bottom left.

I had already done the "pip install xlrd" command from the file location of my python.exe before this, so you may need to do that as well. (you can find the file location by searching it in windows search bar and right click -> open file location, then type cmd into the file explorer address bar)

score 1 · Answer 12 · answered May 17 '21 at 18:49

1

This can be because your required libraries are been installed in Python environment instead of Spyder.

https://github.com/spyder-ide/spyder/wiki/Working-with-packages-and-environments-in-Spyder

answered May 17 '21 at 18:49

Babulal

349
3
11

score 1 · Answer 13 · answered Aug 18 '21 at 08:36

1

I had the same problem. Actually, the problem is that even after installing packages/libraries using pip these packages are not integrated with IDE. So, need to add libraries specifically to the ide.

answered Aug 18 '21 at 08:36

Attique Ahmed

11
2

score 0 · Answer 14 · answered Mar 27 '18 at 15:07

0

First of all you need to install xlrd & pandas packages. Then try below code.

import xlrd
import pandas as pd

xl = pd.ExcelFile("fileName.xlsx")
print(xl.parse(xl.sheet_names[0]))

answered Mar 27 '18 at 15:07

reza.cse08

5,938
48
39

nilsoviani · Answer 15 · 2018-05-21T19:05:10.580

0

You need to install the "xlrd" lib

For Linux (Ubuntu and Derivates):

Installing via pip: python -m pip install --user xlrd

Install system-wide via a Linux package manager: *sudo apt-get install python-xlrd

Windows:

Installing via pip: *pip install xlrd

Download the files: https://pypi.org/project/xlrd/

edited May 21 '18 at 19:05

answered May 21 '18 at 19:00

nilsoviani

344
5
16

score 0 · Answer 16 · answered Feb 18 '19 at 01:05

Another possibility, is the machine has an older version of xlrd installed separately, and it's not in the "..:\Python27\Scripts.." folder.

In another word, there are 2 different versions of xlrd in the machine.

when you check the version below, it reads the one not in the "..:\Python27\Scripts.." folder, no matter how updated you done with pip.

print xlrd.__version__

Delete the whole redundant sub-folder, and it works. (in addition to xlrd, I had another library encountered the same)

score 0 · Answer 17 · edited Apr 09 '19 at 23:40

I encountered a similar issue trying to use xlrd in jupyter notebook. I notice you are using a virtual environment and that was the key to my issue as well. I had xlrd installed in my venv, but I had not properly installed a kernel for that virtual environment in my notebook.

To get it to work, I created my virtual environment and activated it.

Then... pip install ipykernel

And then... ipython kernel install --user --name=myproject

Finally, start jupyter notebooks and when you create a new notebook, select the name you created (in this example, 'myproject')

Hope that helps.

score 0 · Answer 18 · answered Jul 12 '19 at 05:55

Please make sure your python or python3 can see xlrd installation. I had a situation where python3.5 and python3.7 were installed in two different locations. While xlrd was installed with python3.5, I was using python3 (from python3.7 dir) to run my script and got the same error reported above. When I used the correct python (viz. python3.5 dir) to run my script, I was able to read the excel spread sheet without a problem.

score 0 · Answer 19 · answered Dec 01 '22 at 23:52

As @WojciechJakubas mentioned to install openpyxl instead of xlrd, I used openpyxl and it worked.

pip install openpyxl

import openpyxl
path = "path to file.xlxs"
wb_obj = openpyxl.load_workbook(path)
sheet_obj = wb_obj.active
length_col = sheet_obj.max_row
print("Length of rows : ", length_col)

I hope it will help lot of people in 2023.

score 0 · Answer 20 · answered May 22 '23 at 23:47

0

Nothing worked for me until I just uninstalled it first and reinstalled from scratch:

pip uninstall xlrd
pip install xlrd

answered May 22 '23 at 23:47

Boingoloid

107
2
9

Python: Pandas pd.read_excel giving ImportError: Install xlrd >= 0.9.0 for Excel support

20 Answers20

Linked

Related