The Export Table to SharePoint List Wizard.
In the Export Table to SharePoint List Wizard:
Type or paste the URL address of your SharePoint site. Remember, you only need everything from before "/default.aspx." So if your URL was http://contoso/default.aspx, the Web address for the list would be http://contoso.
Type a name for the list, for example, Training presentations
Type a brief description of what the list is for.
Decide whether you want to be able to update the table in Excel with changes made to the SharePoint list later on. If you do, select the Create a read-only connection to the new SharePoint list
in the dialog box to verify that the types of data in each column are properly recognized (you'll learn more about this in the practice). And then click Finish
. Excel automatically exports the table as a list to your SharePoint site.