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