Super User is a question and answer site for computer enthusiasts and power users. 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 an excel sheet with ~200 names, which I'd like to translate into folders in a SharePoint 2007 library. Is this possible with a simple copy/paste, or is there another solution?


share|improve this question
up vote 0 down vote accepted

What's your intention with 200 folders in a list? If you're going to store data per name (within each of your folders) then I highly recommend the use of metadata columns rather than folders.

share|improve this answer
Different security levels per folder. – xdumaine Mar 11 '11 at 14:54
Right. Easiest way to do this then is with code in a console application - or PowerShell (which is slightly tricky in 2007 compared to 2010). If code is not an option, you can create 200 folders the hard way through the UI, create a Datasheet view, select the Title of the folder (might have to select a different column cell then arrow across to the folder), then Paste your names from your Excel column over the Folder Titles column. This might take a while to process though (~5mins). – James Love Mar 11 '11 at 15:01

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .