Monday, 27 May 2019

Create a SharePoint list from an existing list or from Excel

Lists from lists

You can create a list from all existing lists within any site where you’re an editor.  When the new list is created, the entire list structure is copied, including forms, formatting, and custom metadata columns.   (Content will not be copied.)
L2.jpgCreating a list from other lists
Figure 1 - Creating a list from other lists

Lists from Excel

To create a list from Excel, you can select a table from your most recent Excel files in SharePoint or OneDrive.  You can change the field type of the column if needed, and all your table data will be copied to the new lists.

L6.jpgMapping Excel data to the new list

No comments:

SharePoint Template Sites

  SharePoint look book Get inspired Discover the modern experiences you can build with SharePoint in Microsoft 365 https://lookbook.microsof...