Fix most common issues with SharePoint Import Spreadsheet functionality
Every once in a while, I stumble across SharePoint functionalities that are only available when using Internet Explorer, on this post I’ll explain you how to overcome two common issues when trying to import a spreadsheet into a SharePoint list.
If you are dealing with the error messages below this post is for you.
This feature requires a browser that supports ActiveX controls
ActiveX is a software framework created by Microsoft that adapts its earlier Component Object Model (COM) and Object Linking and Embedding (OLE) technologies for content downloaded from a network, particularly from the World Wide Web. Microsoft introduced ActiveX in 1996. In principle, ActiveX is not dependent on Microsoft Windows operating systems, but in practice most ActiveX controls only run on Windows.
ActiveX components will not work on any modern browser, including Microsoft Edge, they are only available through Internet Explorer which means that the only way to get a Spreadsheet into SharePoint is using Internet Explorer.
|Microsoft Internet Explorer|
The specified file is not a valid spreadsheet or contains data to import
Even when using Internet Explorer this functionality can present errors to the user, if after uploading the spreadsheet you are presented with the message “The specified file is not a valid spreadsheet or contains data to import” follow the steps below:
- On Internet Explorer go to Settings
- Select Internet Options
- Open the Security tab
- Select the Trusted sites
- Add your SharePoint site to this zone
- Reduce the Security level to Medium-low
- Restart Internet Explorer
How to import an Excel Spreadsheet to SharePoint
Now that you know how to solve the most common issues with the import Spreadsheet feature lets check all the steps needed to get your file content copied to SharePoint.
- Go to the Internet options and make sure your SharePoint site is added to the Trusted zone and the security level is set to Medium-low
- Open your SharePoint site using Internet Explorer
- Go to Settings and then Site Contents
- Click on Add an app
- Search for Import Spreadsheet and open the app
- Provide a name and a description to the SharePoint list
- Browse the Spreadsheet and click Import
- Select the Range Type and then select the Range
- Once the import finishes the SharePoint list will open with all the records selected by the range