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


Popular posts from this blog

Total Count of Items in a List in Sharepoint

How to filter SharePoint List based on user permission

SharePoint Scrolling Announcement/ News Scroll for 2010/2013