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

Posted by Keith Tuomi on November 29, 2011 in Errors, Office, SharePoint Enterprise, SharePoint Foundation, SharePoint Standard | 0 comments

Trying to import an Excel file in as SharePoint 2010 List resulted in the error:

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

Double-checked the spreadsheet for formula errors, consistency etc. everything looked good but still no importo. The solution is to go to Internet Explorer > Internet Options > Security > Trusted Sites and add your SharePoint site to the list of trusted sites. You can use a *. to avoid having to list multiple subdomains, e.g. “https://*.mySharePointSite.com”

Be sure to disable the HTTPS checkbox if it’s not a requirement for your deployment.

Incoming search terms:

• the specified file is not a valid spreadsheet or contains no data to import
• the specified file is not a valid spreadsheet sharepoint 2010
• the specified file is not a valid spreadsheet
• sharepoint the specified file is not a valid spreadsheet
• sharepoint the specified file is not a valid spreadsheet or contains no data to import
• the specified file is not a valid spreadsheet or contains no data to import in sharepoint
• sp2010 Error: import excel the specified file is not
• the specified file is not a valid spreadsheet or contains no data to import sharepoint
• sharepoint import export specified value is not supported for the urloffile parameter
• sharepoint 2010 the specified file is not a valid spreadsheet or contains no data to import sharepoint 2010