The specified file is not a valid spreadsheet or contains no data to import in SharePoint

If you are getting the below error while importing spreadsheet in SharePoint 2016/2013 or SharePoint online. The error comes as: The specified file is not a valid spreadsheet or contains no data to import. Also, the error can come as: unexpected error importing spreadsheet SharePoint 2013.

The error looks like below:

the specified file is not a valid spreadsheet sharepoint 2013
the specified file is not a valid spreadsheet sharepoint 2016

The specified file is not a valid spreadsheet or contains no data to import in SharePoint

The solution is to add the site to “Trusted sites” in Internet Explorer. Open Internet Explorer. Click on the Settings icon and then click on Internet options.

Then go to the Security tab. Then choose Trusted sites and then click on the Sites button. There add the site in the Add this website to the zone. And click on Add like below:

sharepoint 2016 import spreadsheet an unexpected error has occurred
sharepoint 2013 import spreadsheet an unexpected error has occurred

Now it should work fine.

You may like following tutorials:

This is how we can fix error, The specified file is not a valid spreadsheet or contains no data to import in SharePoint.

>