Fix xlrd.biffh.XLRDError: Excel xlsx file; not supported – Python Pandas Tutorial

By admin | August 23, 2021

In this tutorial, we will introduce how to fix xlrd.biffh.XLRDError: Excel xlsx file; not supported error when reading xlsx file using python pandas.

For example:

import  pandas  as pd

excel_file = 'test.xlsx'
excel_data = pd.read_excel(excel_file, header=None)

Run this code, you will get this error:

How to fix this xlsx not supported error?

We should install python xlrd 1.2.0.

Here is an example:

pip install xlrd==1.2.0

Then, we can find this error is fixed.