In my situation, I was actually trying to open a strict open xml spreedsheet. It had the same file extension of ".xlsx". Instead of dealing with the issue of opening an xml file in pandas, I resorted to converting it to a csv.