Python How To Install Xlrd

The xldr module is a library that can be used to work with Excel files. This is specifically for files in the “.xls” format. This is ONLY for “.xls” files. It also doesn’t support many features such as chargers and pictures.

To install xlrd just use pip like this:

pip3 install xlrd

Once you have it installed you should be able to import the library and tested it out by opening Excel files like this:

import xlrd
book = xlrd.open_workbook("datasheet1.xls")