Limited column types in a microsoft list

Question

Hello,

Im creating a SharePoint List for my organization that I integrated from an excel spreadsheet. However, I only have a few choices to choose from for "column type" as shown in attached pic. I need this column to be a "person" column but as you can see i dont get that option. What am I missing?

Answer 1

Hi @Tanner, Shane ,

As per my test, it is only this several type of columns when you export to SharePoint list. You could not focus on special data types when importing or change type of existing columns.
The best option is probably to:

1. Create a new column for the name with the person and group type in SharePoint online.
2. Select all the values in the old name column in excel
3. Copy the values in excel
4. Paste the values to new column that you created new person and group type in SharePoint online.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it.

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.

Answer 2

Hello and thanks for the info. However, i don't think i was clear enough with the info i gave or im not understanding your reply. My apologies if im misunderstanding. This is in regards to a sharepoint "list" that i created from integrating an excel spreadsheet. Even during the integration process i don't get all the column types and instead am only able to choose from a few column types. I'm curious why i don't get to choose from all 11 types. Specifically the "person or group" type which is the one i need for this column.

1. Single Line of Text
2. Multiple Lines of Text
3. Number
4. Location
5. Date and Time
6. Yes/No
7. Person or Group
8. Hyperlink
9. Choice
10. Image
11. Currency

Answer 3

Hi @Tanner, Shane ,

1.You could create a person and group type column in SharePoint list.

2.Click edit in grid view.

3.Select the column what you want in excel. Copy this column.

4.Paste this column to your SharePoint list.

---

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

Answer 4

This helped me:

When creating a SharePoint list from an Excel spreadsheet, you might notice that you have limited options for column types. Specifically, you’re unable to choose from all 11 types. The “person or group” type is one that you need, but it’s not available during the integration process.

Here are a couple of approaches you can consider:

1. Create a New Column in SharePoint Online:

	○ After integrating your Excel spreadsheet into SharePoint, create a new column specifically for the “person or group” type.

	○ Select all the values from the old name column in Excel.

	○ Copy these values in Excel.

	○ Paste the values into the new column you created in SharePoint, specifying the “person or group” type.