I have a document library.and a excel with few columns of data that should be populated against sharepoint documents based on the file names.datasheet view is of little help as few of the colums are radio buttons/drop downs/name fields.any ways doing this.


1 Answer 1


Yes, you will need to make a small application to perform it but that would be fine.

1) Set up your metadata columns for the document library. 2) Build an application that iterates through the document library and looks up in the spreadsheet for the file name 3) Add the correct data into the managed metadata columns.

You need to make sure that the account you use has sufficient permissions to do this, you can do this by making it a windows form application in visual studio or a console application, then adding the windows account under the permissions tab as full permissions and as an administrator as full permissions under central admin for the managed metadata service.

However if you are unable to write an application for this, then no it is not OOTB.

Some links for you to get you going:



I hope this helps.

Your Answer

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

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