0

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?

Thanks

Improve this question

1 Answer 1

Reset to default
0

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.

Improve this answer
2
  • Different security levels per folder.
    – xdumaine
    Mar 11, 2011 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, 2011 at 15:01

You must log in to answer this question.

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