“The specified file is not a valid spreadsheet or contains no data to import” Error When Importing an Excel Spreadsheet into SharePoint 2010

In Internet Explorer click Tools –> Internet Options.

Click Security –> Trusted Sites > Sites –> and add your site name.

Make sure to enter both the http and https form of the URL.

You’ll need to uncheck the box for “require sever verification”