Microsoft SharePoint 2013:Data import from Excel spreadsheet to SharePoint list

From PlexHosted Knowledgebase
Jump to: navigation, search
Dedicated SharePoint Hosting Services at PlexHosted

If you have data within Excel spreadsheet, and you want to share the data with your team you could use SharePoint to import information from spreadsheet into a SharePoint list. This article describes how to import Excel spreadsheet to SharePoint list.

Data import from Excel spreadsheet to SharePoint list

  1. Login to your SharePoint site. Click Settings, click Site Content
    Data import from Excel spreadsheet to SharePoint list 1.png
  2. Click "Add an app"
    Data import from Excel spreadsheet to SharePoint list 2.png
  3. Type "excel" in the Find an app textbox. Click Import Spreadseet
    Data import from Excel spreadsheet to SharePoint list 3.png
  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.png
  5. Select the Range type and select the range for the data. Click Import button
    Data import from Excel spreadsheet to SharePoint list 5.png
  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.png