Quick Edit mode - Copy and paste from excel with Managed Meta Data columns RRS feed

  • Question

  • Hi,

    I'm trying to migrate a meta data from an excel spreadsheet to a SP 2013 document library. The columns are managed meta data columns with pre defined terms matching the data in the excel spreadsheet. 

    However I cannot copy and paste data from excel via Quick Edit in the doucment library without getting the following error "The data returned from the tagging UI was not formatted correctly"

    This happens even when I remove all formatting or paste to notepad first.

    Are there any simple solutions to this issue?


    Wednesday, April 23, 2014 10:10 AM


  • Hi , 

    It's by design that the Managed Metadata column in Quick Edit doesn't support the data paste from excel and will display this validation message.

    It seems you would use the third party tool suggested by teylyn to bulk update the list Managed Metadata column vallues as a workaround per the following similar post.


    Daniel Yang
    TechNet Community Support

    • Marked as answer by star.wars Sunday, May 4, 2014 2:42 PM
    Thursday, April 24, 2014 4:02 PM