Import excel data to SharePoint 2010 list

This SharePoint 2010 tutorial explains, how we can import excel data into a SharePoint 2010 list.

Follow the below steps:
1. Open your SharePoint 2010 Site.

2. Go to Site Actions -> More options.

3. Choose List from the left side, then choose “Import Spreadsheet” from the right side and then click on Create as shown in the fig below:

Import excel data to SharePoint 2010
Import excel data to SharePoint 2010

4. Provide name and description and click on Browse to import your Excel file as shown in the figure below:

Import excel data to SharePoint 2010
Import excel data to SharePoint 2010

5. Then click on Import.

6. After you click on Import, it will open your Excel file to specify your cell range.

7. From the drop-down, choose “Range of cell” and in the 2nd dropdown specify the cell range.

8. Now click on import and your Excel file imported to your site.

You may like following InfoPath 2010 tutorials:

Hope this SharePoint 2010 tutorial explains how to import excel data to SharePoint 2010 list using Import Spreadsheet option.

Donwload Hub site pdf

Download SharePoint Online Tutorial PDF FREE!

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

>