This tutorial demonstrates an easy way to import an existing list into SharePoint.

  1. Create a list in Microsoft Excel or use an existing list.
  2. Highlight your list and navigate to Home -> Format as Table.
    Format-As-Table
  3. Navigate to Design -> Export -> Export Table to SharePoint List…
    Export-Table-To-SharePoint-List
  4. Fill out the Address to your SharePoint site and the Name and Description of the List.
    Export-Table-To-SharePoint-List-1
  5. Click the Next button.
  6. If your website is secure you may be asked to login with your credentials in order to connect to your SharePoint site.
  7. Your list should display with the recognized SharePoint data types. If the data looks correct, select the column that is the Key Cell and click the Finish button.
    Export-Table-To-SharePoint-List-2
  8. You should get a success message similar to the following:
    Microsoft-SharePoint-Foundation
  9. Click on the link in the success message to view the imported list in your SharePoint site.
    Imported-SharePoint-List
Like this post? Share it!

Social Stream