Microsoft SharePoint 2013:Export an Excel table to a SharePoint site

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

This article describes how to export Excel table to SharePoint list.

Export an Excel table to a SharePoint site

  1. Open your Excel document
  2. Click "Design" on the "Table Tools" section, click "Export", click "Export Table to SharePoint list"
    Export Table 1.png
  3. Type the URL of the SharePoint site. Type the name for the new list and list description. Click "Next"
    Export Table 2.png
  4. Enter the user credentials for SharePoint site in the popup window
  5. Click Finish. A dialog box appears with the URL of your new SharePoint list. Follow this URL to see your new SharePoint list
    Export Table 3.png

[[Category:{SharePoint 2013 architecture}]]