Pandas read_excel error : ValueError: Your version of xlrd is 2.0.1. In xlrd >= 2.0, only the xls format is supported. Install openpyxl instead.

[ Code ]

import pandas as pd


df = pd.read_excel("test.xlsx")

 

[ Error message ]

Pandas read_excel error : 

ValueError: Your version of xlrd is 2.0.1. In xlrd >= 2.0, only the xls format is supported. Install openpyxl instead.

 

[ Reason ]

Since xlrd 2.0 and above only supports the xls format and not the xlsx format,

install the openpyxl module to process the xlsx format with read_excel in Pandas.

 

[ Solution ]

- Install the openpyxl

pip install openpyxl