Import values as 'person or group' type RRS feed

  • Question

  • Hello all,

    I have an excel sheet with URLs and users (Name, email and alias/id stored in different columns). I would like to transfer this excel sheet into a task list. The tasks should be named by the url and they should be assigned to the people from the list.

    If I just import that excel sheet, I get a custom list not a task list. The column "Name" is of type text and I can't convert it to person or group.

    I wonder if it is possible to import Users from an excel sheet to a task list? Which format do I need? Maybe there is a workaround? Something like read the names as text, create a user and insert it into the assigned to column.

    I am thankful for any ideas




    Friday, March 7, 2014 2:14 PM


All replies