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  lt module gt      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  gt   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

User · Answer

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')

User · Answer

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

User · Answer

Was getting the error while I was using jupyter   ModuleNotFoundError  No module named  xlrd      ImportError  Install xlrd  gt   0 9 0 for Excel support   it was resolved for me after using    pip install xlrd

User · Answer

This works for me  For Python 3     pip3 install xlrd --user   For Python2     pip install xlrd --user

User · Answer

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

User · Answer

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

User · Answer

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

User · Answer

As  COLDSPEED so eloquently pointed out the error explicitly tells you to install xlrd   pip install xlrd   And you will be good to go

User · Answer

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

User · Answer

Either use   pip install xlrd   And if you are using conda  use   conda install -c anaconda xlrd   That s it  good luck

User · Answer

First of all you need to install xlrd  amp  pandas packages  Then try below code   import xlrd import pandas as pd  xl   pd ExcelFile  fileName xlsx   print xl parse xl sheet names 0

User · Answer

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

User · Answer

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

User · Answer

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

User · Answer

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

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

Examples related to python

Examples related to excel

Examples related to python-2.7

Examples related to pandas