How do I set up certain types of data in an imported Microsoft List?

Question

I have moved a Microsoft List from one shared platform to my platform. The way I did this was to first download it as an Excel file to my local computer. Then I formatted the CSV data to be an actual Table in Excel. Then I saved this into an Excel Workbook file.

Now, I assume it goes without saying that, doing all this and using the resulting file to upload and create a new Microsoft List would mean that all the data type information is lost and each column would be assumed to be text.

After I have used the Excel Workbook file to set up the new Microsoft List, I am taken to the "Customize" phase where I can define the column type. I can match the "Title" column to be the same as the Microsoft List I am copying from. I can set data types defined as Choice to be a Choice type. But here I come to my first question. How do I further set up a Choice data types to be a set of types and have them color-coded as they are in the List I am copying from?

And here is my second question. A few of the columns are Person types. How do I set up a Person type? The Person option is not even available as an option in the Customize phase.

The only options I am given are:

• Single Line of Text
• Multiple Line of Text
• Choice
• Title
• Do Not Import

Answer 1

What does "set up a Choice data types to be a set of types" refer to?

You could import data from an excel file into SharePoint list, but you cannot import color formatting from an excel file into SharePoint list. You should do color formatting directly in the SharePoint list.

For people column, there is no OOTB way. You should use flow to import data from an excel file into SharePoint list.

Here is a post about how to step by step to create a flow for your reference:

https://learn.microsoft.com/en-us/answers/questions/1361772/specific-user-can-not-be-found-while-running-power

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.