When I export a list from a SharePoint site to Excel and then import this list to another site, the list content is untouched, but all columns change to "single line of text" only.
It is a problem because I need to have names "clickable" in fields like (created by, modified by etc..). The data is there, but there is no longer "person or Group" form but "single line of text".
How to keep the form the same without having all fields single line of text only. I cannot change this even in SharePoint Designer 2013 when I click change column type, there is no option to change it back to "person or group".