Data import from Excel spreadsheet to SharePoint list

We would like to show you how to import your data within Excel spreadsheet into a SharePoint list.

It’s quite simple. Follow the instructions:

1. Login to your SharePoint site. Click Settings, click Site Content

Data_import_from_Excel_spreadsheet_to_SharePoint_list_1

2. Click “Add an app”

Data_import_from_Excel_spreadsheet_to_SharePoint_list_2

3. Type “excel” in the Find an app textbox. Click Import Spreadseet

Data_import_from_Excel_spreadsheet_to_SharePoint_list_3

4. Type the name for the new list, description. Click Browse button and select your Excel spreadsheet file. Click Import button

Data_import_from_Excel_spreadsheet_to_SharePoint_list_4

5. Select the Range type and select the range for the data. Click Import button

Data_import_from_Excel_spreadsheet_to_SharePoint_list_5

6. Now you can see your new list with the data that was imported from Excel spreadsheet

Data_import_from_Excel_spreadsheet_to_SharePoint_list_6

 

LinkedIn
Facebook
Facebook
Google+
Google+
https://blog.plexhosted.com/2015/06/21/data-import-from-excel-spreadsheet-to-sharepoint-list/

Leave a Reply

Your email address will not be published. Required fields are marked *