I imported the data from excel file, but some column data type I need to change from single line of text to Lookup value. How to do this? I am using SharePoint 2013

1 Answer 1


I guess there is no out of the box way of doing this. You could do it by powershell: 1. Create a new list column (lookup) 2. Iterate trough your list, check for the value in the old column and check for values in the list you want to make the lookup from. 3. Write matches to new list column

Some powershell reference: http://www.c-sharpcorner.com/uploadfile/anavijai/add-and-modify-the-existing-site-column-in-sharepoint-2010-using-powershell/

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.