SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a new SP 2007 site which I have been loading about a terabyte of files into. File types include .doc, .docx, .ppt, .pptx, .xls, .xlsx, .xlsm, .jpg, .gif, .pdf.

What I need to do is add custom metadata for each file. Fields include project name and department. Since there are a large number of files, adding the data manually isn't an option.

How could I add it in bulk?

share|improve this question
thank you for the answers! I have to put my testing on hold as we are now upgrading to 2010. I will revisit this in a couple of weeks. Sorry for the delay! – user2404 Feb 23 '11 at 15:58

You could write a simple console application that would do it for you through the SharePoint Object Model. You could also do it with PowerShell.

share|improve this answer

There are several third party tools that let you do bulk import and bulk metadata setting, with some automation, including DocKIT, RoboMETA, and Classifier.

Since you are adding metadata and importing a very large number of documents, do you really want to put them all in the same document library? There is a limit in 2007. You might look into in the routing capability of the Records Center site template in SharePoint 2007, or move to SharePoint 2010 and use the more flexible Content Organizer or the metadata navigation features.

share|improve this answer

If you need to use Web Services, you can use UpdateListItem

share|improve this answer
Console is better for 1 TB – Nat Feb 28 '11 at 21:19

you could import the metadata dorectly using a metadata file. Get the sample file from the metadata service application itself.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.