I have a list that contains a few columns of type Managed Metadata and want to upload a bunch of data (records) to the list. I understand that you can't do this within the Datasheet View of the list as the Managed Metadata fields are set to read only.

How can I achieve this? Out-Of-The-Box functionality? Custom Solution using Code? 3rd Party Tool? (if 3rd Party Tool, which ones could provide this functionality)

Any help on this would be much appreciated - we need to implement this functionality urgently.

Thanks in advance.


2 Answers 2


Unfortunately, there is no support for setting up metadata to multiple files at the time of uploading to SharePoint. However, you can use SharePoint 2010 Batch Edit for bulk updating managed metadata using the SharePoint ribbon.

In SharePoint 2013, the datasheet view functionality can even edit/update managed metadata columns. The purpose is enable the metadata modification functionality available when editing an individual item to datasheet editing.


I found this solution using MS Access- SharePoint this might be useful for someone - http://sharepointlogics.com/2014/07/how-to-import-excel-spreadsheet-to.html

  • 1
    Please don’t add just a link as answer to a question. If the link breaks, the answer you provided will not be useful for future visitors. Provide an answer of your own and use the link as reference. If needed, you can block quote the content from your link. More information is found in our help center, especially How do I write a good answer
    – Benny Skogberg
    Jul 18, 2014 at 11:59

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.