Remove the ID and # from SharePoint list when export to excel. RRS feed

  • Question

  • Hi,

    I have a sharepoint 2013 list with look up fields and when export to excel showing the #tag and IDs. The client wants to remove those extra things from the excel spread sheet. Has anyone come across this issue and please advise how to get rid of these?



    Monday, September 25, 2017 7:16 AM


  • Hi,

    It seems that the “#tag” is caused by that lookup column allows multiple values. This is by design. Columns with multiple values would contain “#tag” if you export list to excel.

    There is no OOB way to get rid of these from SharePoint side. You can replace the “#tag” with space in excel client application.


    Dean Wang

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

    • Marked as answer by Divya.Nair Tuesday, September 26, 2017 11:37 PM
    Tuesday, September 26, 2017 6:00 AM