In this article we will discuss how we can create a SharePoint list from a Excel work sheet. You can do through browser as well as from SharePoint 2010 designer
. For this article we will discuss how to do it through browser.
First Open the SharePoint site in the browser. Then click on Site Actions -> More Options...
This will load all the templates to create list, library, page or site. From there choose Import SpreadSheet and click on Create as shown in the figure below.
This will open the page where we need to give the name, description and the path of the excel file from where we will import. My excel sheet contains 3 columns namely: Name, EmailID and Salary. And also contains some data. Fill all the details and click on Import.
This will open the Import to Windows SharePoint Services list. There in the range type you can select Range of cells, and in the Select Range you can give a range value. Here for this example we can give Sheet1!$A$1:$C$4, which means it will read from Sheet1 from A1 shell to C4 shell. Then click on Import as shown in the figure below.
This will create the list as shown in the figure below.