I have SharePoint 2007 list that has 'person or group' field, lets call it employee. When I export this list to excel, I get the column values as display name 'firstname + lastname (Joe Blog), what I need is domain\username. I need this so I can import the list to newer version of SharePoint (2013).
I can achieve the above by going to employee column in sp2007 and change the show filed type to Account, and then do the export to Excel.
But there must be a way of doing this without changing the show filed type for the column.
May be editing the owssvr.iqy file to include domain\username instead of default display name.
Thanks for your help.