When Exporting to Excel, values in lookup columns include the item's ID value RRS feed

  • Question

  • Hello,

    I have several lists that have lookup columns pointing back to source data (lookup column in place of a choice field).  However when the list is exported to excel, we see results in the choice fields like:


    I have searched for similar issues and have not found anything.  I thought perhaps the lookup fields were also set to carry over the value's ID, which may cause some issue (though it should not), but that is not the case.  Anyone have any ideas?

    Thank you

    Tuesday, July 31, 2012 1:03 AM


  • If you have "Allow multiple values" option selected for the lookup columns in concern this would work the way you have described. You need to uncheck that option before you make another attempt to export.

    Make sure to backup the data in concerned sharepoint list before you make a chage suggested above and let me know if this helps.

    Tuesday, July 31, 2012 2:38 PM