How To Create A SharePoint List From An Excel Export [Tutorial]

How To Create A SharePoint List From An Excel Export [Tutorial]

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

Submit a Comment

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">