How to workaround a issue that "Failed to open .xls error" is raised while importing Excel Data


When you try to import a .xls file, you see “Failed to open /xxx.xls” error message like below.


Open it with Excel and save it as “.xlsx”

On Excel’s Save As Dialog, select “Script Open XML Spreadsheet (.xlsx)” like below.

Go to Exploratory and select “.xlsx” file instead of “.xls” file. Then you might be able to import the file.