Import excel spreadsheet into SharePoint list 2013

This SharePoint tutorial will discuss how to import an excel spreadsheet into SharePoint 2013 or SharePoint 2016 or SharePoint Online.

import excel spreadsheet into SharePoint list

Here I have an excel which has column has Name, EmailID, and Course. And also it has 2 records. The excel spreadsheet looks like below:

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

To work with import excel spreadsheet, use a 32-bit version of Internet Explorer 10 or 11. Else you will get an error like below: The list cannot be imported because a Microsoft SharePoint Foundation-compatible spreadsheet application is not installed or is not compatible with your browser

Open SharePoint 2016/2013 or SharePoint online site. Then from the Settings icon -> Add an app. And then select the “Import Spreadsheet” app. Then in the New app, give a name, description and choose the excel file which we have created earlier. The screen looks like below: Then click on import.

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

Then you can choose from Table Range, Range of Cells, or Named Range, choose Range of Cells, and then click Select Range manually. Then click on Import.

import excel spreadsheet into sharepoint online list
import excel spreadsheet into sharepoint online list

After that you can see the list will get created with the columns and data. The list looks like below:

import excel file into sharepoint list 2013
import excel file into sharepoint list 2013

The types of columns that are created for a list are based on the kinds of data that are in the columns of the spreadsheet.

If you got the error as: The specified file is not a valid spreadsheet or contains no data to import SharePoint 2016/2013 or SharePoint Online

You may like following SharePoint tutorials:

I hope this SharePoint tutorial, will help to import excel spreadsheet into SharePoint list.

>