Upload Excel Data to SharePoint using Import Spreadsheet option in SharePoint

This SharePoint tutorial explains, how to upload excel data to SharePoint using the Import Spreadsheet option in SharePoint 2013. It will create a list as well as it adds columns that are there in the excel sheet and upload data to it.

But this feature will work only on those browsers that support ActiveX. Else it will give an error like “Cannot import the spreadsheet into SharePoint. this feature requires a browser that supports ActiveX controls”. So it will work fine in Internet Explorer browser.

Upload Excel Data to SharePoint using Import Spreadsheet
Upload Excel Data to SharePoint using Import Spreadsheet

If you are getting the above error in Google Chrome, then you can try doing the operation using Internet Explorer. Make sure to use the 32-bit version of Internet Explorer 10 or 11 to import a spreadsheet in SharePoint 2016 or SharePoint 2013 on SharePoint online.

If the error is coming in IE, then we need to enable “SharePoint SpreadSheet Launcher” add-on in IE.

Cannot import the spreadsheet into SharePoint. This feature requires a browser that supports ActiveX controls in SharePoint 2013.

To use Import Spreadsheet open, Open SharePoint 2013 site, from the Settings Icon click on Add an app. Then select Import Spreadsheet App as shown in the fig below:

import spreadsheet sharepoint 2013
import spreadsheet sharepoint 2013

Then in the Next page, Give the name and description and then choose the spreadsheet (excel) file. And then click on Import.

Import Spreadsheet option in SharePoint 2013
Import Spreadsheet option in SharePoint 2013

Then it will open the Import to Windows SharePoint Services List. There select the Range of Cells from the Range Type: And then put the cursor in the Select Range, it will allow you to select whatever you want to add from the excel. see pics below.

Import Spreadsheet option in SharePoint
Import Spreadsheet option in SharePoint

Then click on Import. This will create the list like below which will include the column names also.

Upload Excel Data to SharePoint using Import Spreadsheet
Upload Excel Data to SharePoint using Import Spreadsheet

You may like following SharePoint customization tutorials:

This way you can create easily a SharePoint list from excel with data in SharePoint 2013/2016 or SharePoint Online.

Donwload Hub site pdf

Download SharePoint Online Tutorial PDF FREE!

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

>