Sharepoint Online connection to Excel - Person or Group values


  • I am using Sharepoint Online with Excel 2016 and have setup a data connection in the excel workbook to pull out the data from a Sharepoint list. This works great except for list columns which are of type "Person or Group" or "Lookup" which just provides back a number value cooresponding. I would like to convert the "Person or Group" values into the DisplayName value, and for the "Lookup" values to provide the text conversion.

    How can I do this?

    Thursday, March 23, 2017 12:07 AM

All replies

  • Hi Erica,

    I suggest you using "export to excel", when you export a list to excel, "Person or Group" or "Lookup" which will provides back corresponding values:

    Best Regards,

    Lisa Chen

    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact

    Friday, March 24, 2017 7:13 AM
  • Although a helpful workaround, I don't believe this answers the question with regard to using a data connection vs. an export to excel.
    Wednesday, May 24, 2017 7:12 PM