Read XLSB File in Pandas Python

Question

There are many questions on this, but there has been no simple answer on how to read an xlsb file into pandas. Is there an easy way to do this?

Answer 1

With the 1.0.0 release of pandas - January 29, 2020, support for binary Excel files was added.

import pandas as pd
df = pd.read_excel('path_to_file.xlsb', engine='pyxlsb')

Notes:

• You will need to upgrade pandas - pip install pandas --upgrade
• You will need to install pyxlsb - pip install pyxlsb