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.)

Creating 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.

Mapping Excel data to the new list

Multi-geo capabilities for SharePoint and Office 365 Groups

Multi-geo capabilities for SharePoint and Office 365 are designed to meet even the most complex data residency requirements. Today we announced multi-geo capabilities for SharePoint and Office 365 Groups are generally available, which means you can get started right away.


These new multi-geo capabilities allow you to store your SharePoint and Office 365 Groups mailbox/sites data in one or more worldwide locations to satisfy data sovereignty requirements specific to those locations.