Create an App using Import Spreadsheet Option in SharePoint 2016

import spreadsheet into sharepoint office 365

SharePoint 2016 / 2013 provides an app which we can use to create a list of the columns and data presented in an existing spreadsheet. But you should make sure to follow a few guidelines for the spreadsheet.


– Make sure your spreadsheet looks like a table with no blank columns or rows.
– Make sure your spreadsheet has headers. All columns in the SharePoint app need to have a column title.
– Make sure your data is consistent. For example, if a cell has a comment in it, but it should contain a date, remove the comment text.
– Make sure your column heading in the first row is representative of the data. SharePoint reads the headings in the first row and makes assumptions about the information in those columns.

Create an App using Import Spreadsheet Option:

To create an app using the Import Spreadsheet option follow the below steps.

First let us create an excel which will have 3 columns like:
– FirstName (Single line text)
– LastName (Single line text)
– DateOfJoining (Date Type Field)

The excel sheet looks like below:

import spreadsheet into sharepoint list 2013
import spreadsheet into sharepoint list 2013

Now open your SharePoint 2016 site in the browser and click on the gear icon and then click on Add an app. Then from the list of app select “Import Spreadsheet” option. Then give a name, description and choose the spreadsheet file which we have created before as shown in the fig below:

sharepoint 2013 update list from excel
sharepoint 2013 update list from excel

If in the next step you get an error like below:
Cannot import the spreadsheet into SharePoint. This feature requires a browser that supports ActiveX controls like below, then you make sure you are trying in IE browser because this features requires ActiveX.

this feature requires a browser that supports activex controls sharepoint 2016
this feature requires a browser that supports activex controls sharepoint 2016

If you are getting the error in IE then we may need to enable “SharePoint SpreadSheet Launcher” add-on in IE.

Check out a detailed SharePoint blog post: Cannot import the spreadsheet into SharePoint. This feature requires a browser that supports ActiveX controls

Once you will click on OK to create the list, first it will display the Import to Windows SharePoint Services list dialog box like below.

this feature requires a browser that supports activex controls ie 11
this feature requires a browser that supports activex controls ie 11

Here Select Range type as Range of Cells and then select the range, you can directly select the whole range in spreedsheet itself like below:

import spreadsheet into sharepoint office 365
import spreadsheet into sharepoint office 365

Also, read some SharePoint tutorials:
Working with Nintex Workflow for Office 365 SharePoint Online

SharePoint Online Check current user belongs to a particular SharePoint group using JavaScript object model

Change width of list view column in SharePoint 2013 using SharePoint designer 2013

Then it will create the list like below:

import excel spreadsheet into sharepoint list 2016
import excel spreadsheet into sharepoint list 2016

Hope in this article, you got an idea on how to use import from a spreadsheet in SharePoint 2016 and how to solve the issue this feature requires a browser that supports ActiveX controls in SharePoint 2016.

Hope this article will be helpful.


You May Also like the Following SharePoint Online Tutorials:

About Bijay Kumar

I am Bijay from Odisha, India. Currently working in my own venture TSInfo Technologies in Bangalore, India. I am Microsoft Office Servers and Services (SharePoint) MVP (5 times). I works in SharePoint 2016/2013/2010, SharePoint Online Office 365 etc. Check out My MVP Profile.. I also run popular SharePoint web site SharePointSky.com

View all posts by Bijay Kumar →