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

Written by Keith Tuomi on. Posted in Errors, Office, SharePoint Enterprise, SharePoint Foundation, SharePoint Standard

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

Specified file is not valid spreadsheet1 The specified file is not a valid spreadsheet or contains no data to import SharePoint 2010 sharepoint standard sharepoint foundation sharepoint enterprise office errors

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
  • the specified file is not a valid spreadsheet or contains no data to import sharepoint 2010
  • the internet address is not valid sharepoint
  • the specified file is not valid spreadsheet or contains no data to import
  • sharepoint excel import not a valid spreadsheet no data
  • sharepoint explorer trusted site request even though it is
  • sharepoint open file the internet address is not valid
  • sxcel liste in sharepoin 2013 importieren liste

Tags: , , , ,

Trackback from your site.

Keith Tuomi

itgroove is a team of dedicated professionals specializing in Microsoft technologies for the small and medium sized business. Our SharePoint practise offers expert level assistance in architecting, implementing, and customising this industry leading collaboration platform.

Comments (2)

  • Chris

    |

    The error was not helpful but adding to trusted sites worked like a champ! This also work in SP 2013.

    Thanks!

    Reply

    • Keith Tuomi

      |

      Nice, thx for confirming with SP 2013.

      Reply

Leave a comment

Follow me on Twitter