Share via

My Sharepoint Create a list from an existing list doesn't bring in the data

Anonymous
2022-12-14T16:35:57+00:00

Hi

How can I import all the data from an excel to a SP list? - I dont see an option and I am an Admin.

including like Person or Group fields,

I created the list from a list , but is empty, I have the data in excel, but will it bring the data formatted for those type of fields (Person or Group fields)

Microsoft 365 and Office | SharePoint | For business | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-12-15T06:49:31+00:00

    Dear Gladys,

    Greetings! Thank you for posting in Microsoft forum.

    In your post you mentioned “How can I import all the data from an excel to a SP list? - I dont see an option”, may I confirm if From Excel option is missing from the Create a list window as shown below?

    Please note, creating a list from an Excel spreadsheet is not available in the GCC High and DoD environments.

    Further, in the next line you mentioned “I created the list from a list , but is empty”, may I know if the list (or the source list) from which you created a new list is an existing SharePoint list? If so, then I would like to mention when we create a SharePoint list from an existing SharePoint list, the entire list structure is copied, including views, formatting, and columns. However, the actual content of the original list isn't copied. Please check the following article for reference:

    Create a new list based on the columns in another list - Microsoft Support

    Regarding “I have the data in excel, but will it bring the data formatted for those type of fields (Person or Group fields)”, when you import an Excel spreadsheet to a SharePoint custom list, you are limited to a subset of column types. The column types you can specify for each column are limited. You will not be able to select people, locations, and hyperlink column types. Also, if you have data validation columns like Excel dropdowns, you will have to recreate them in the SharePoint list.

    The types of columns that are created for a list are based on the kinds of data that are in the columns of the spreadsheet. For example, a column in the spreadsheet that contains dates will typically be a date column in the SharePoint list. If you have any column with names in Excel, it will import as Single line of Text.

    Besides, there’s another method of moving data into SharePoint is to export a table directly from Excel. For more info, see Export an Excel table to SharePoint.

    If my understanding above is not consistent with yours, you can also post back and point that out.

    Your understanding and patience will be highly appreciated. I hope that you are keeping safe and well!

    Sincerely,

    Neha | Microsoft Community Moderator

    0 comments