I was in a client meeting yesterday and they had some concerns with the amount of time it would take their users to upload and tag all their documents. They were wanting me to write a script to transverse through the directory structure and tag the files. The problem was the heirarchy didn't match the tags. After 10 minutes of this I remembered two features in SharePoint that might alievate their concerns. The DataSheet View and Open in Explorer Option.
DataSheet View
Under the Actions menu in a document library selecting this option will bring up the document library in a grid with similiar functionality to Excel. This allows the users to drag values as well as copy/paste making editing all of those site columns pretty fast.
Open in Explorer
This option is also found under Actions and will open the document library in Windows Explorer allowing users to drag files into the library. Even better they can drag the entire heirarchy and the subdirectories will show up in the library as well.