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

Recently when I am trying to upload excel data to my SharePoint 2013 site by using the Import Spreadsheet option by following this article, I got the below error “The specified file is not a valid spreadsheet or contains no data to import”. File format and data everything was correct.

The error “The specified file is not a valid spreadsheet or contains no data to import” can come in SharePoint 2013 or SharePoint 2016 or SharePoint Online while importing an excel using the Import Spreadsheet option.

the specified file is not a valid spreadsheet or contains no data to import sharepoint 2016

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

I searched and found the below solutions are working.

Solution-1:

I was doing these stuff in IE 8 browser, but when I follow the same steps in IE 9 or above, then everything works fine for me.

Solution-2:

This solution also worked for me. Open the IE browser, then navigate to Internet Options -> Security Tab. And then in the “Select a zone to view or change security settings”, click Trusted Sites. Then add the site to the trusted site list. Then Set the Security level for this zone of the Trusted sites to Low.

the specified file is not a valid spreadsheet or contains no data to import sharepoint

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

Now close the browser and open again.

Solution-3:

The below solution I have not tried and I got this solution from this Technet URL.

You can give a try and check if it is working (if the above solutions did not work).
In Internet Explorer click Tools -> Internet Options.
Then Click Security -> click sites -> and add this URLs https://.emea.microsoftonline.com and https://.microsoftonline.com

After following the above approach, The specified file is not a valid spreadsheet or contains no data to import SharePoint error will not appear.

You may like following SharePoint tutorials:

Here we learned how to solve the specified file is not a valid spreadsheet or contains no data to import sharepoint error.

Donwload Hub site pdf

Download SharePoint Online Tutorial PDF FREE!

Get update on Webinars, video tutorials, training courses etc.

>