Fix Python Pandas Read Excel File – ImportError: Missing optional dependency ‘xlrd’

Python pandas read_excel() can allow us to read an excel file easily, however, you may find this ImportError: Missing optional dependency ‘xlrd’. In this tutorial, we will fix this error with some steps.

This import error likes:

How to fix this importerror?

Install python xlrd package

We can use pip install command to install xlrd package.

pip install -i https://pypi.tuna.tsinghua.edu.cn/simple xlrd

Here we use pip https://pypi.tuna.tsinghua.edu.cn/simple mirror to install.

Then we will find this import error is fixed and we can read excel file successfully.