The specified file is not a valid spreadsheet or contains no data to import
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.
excel import, Internet Explorer, Microsoft Excel, Spreadsheet, xls
Chris
The error was not helpful but adding to trusted sites worked like a champ! This also work in SP 2013.
Thanks!
Keith Tuomi
Nice, thx for confirming with SP 2013.
Kara
Thanks so much, this worked for me for SP 2013 as well. I did notice that if the Excel spreadsheet hasn’t been preformatted as a “Table with Headers” in Excel prior to the import, SP won’t recognize the headers, but easy to rename in the SP list once the import is complete.
Keith Tuomi
Cool, thanks for sharing.
Aice
Thank you, it works!