Connecting SharePoint List To Excel Doesn't Return Person Column Data

LuiIacobellis Probably because person or group and lookup columns are complex fields, not like simple text fields.

These fields have additional data associated with it like person columns has different properties like user display name, email, job title, etc.

Similarly, lookup columns has lookup list item ID and lookup value of primary column selected in column settings.

Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.