Subfolder Hell on SharePoint?

Many users end up duplicating their fileshare structures on SharePoint, this is not ideal and it is better to use metadata where possible.

Once the concept of metadata has been embraced, users invariably want to fix the subfolder hell they inherited / created.  Sometimes it’s easier to just create the library again and start over, but that’s not always possible and sometimes you need to fix the library where it is.

Extracting the metadata from the subfolders currently on the site is easy though, simply export the library to Excel.

Export Subfolders to ExcelThe list of subfolders are conveniently all listed for you.

Excel subfolder reportCopy the values and paste them into a choice field, lookup or site column.

Create ColumnNow the library is ready for some reorganising of documents.

Document Type Column Added

Click in the subfolders one at a time, go to Quick Edit / Datasheet View, and bulk tag them.

Tag the DocumentsOnce all the documents have been reclassified using metadata, you need to move the documents out of the subfolders to library level.  Go to Content and Structure, select the subfolder in the library so the documents display on the right. Select all the documents then Actions and Move, and move them one level up.

Move Documents to Library LevelWhen the documents are out of the subfolder, you can delete the subfolder then create views to slice and dice the documents as required.

It’s quite the mission, so use metadata instead from the beginning and just avoid all this. 😉

 

 

 

About Veronique Palmer

Empowering people one at a time.
This entry was posted in Office 365, SharePoint 2010, SharePoint 2013, Tutorial. Bookmark the permalink.

4 Responses to Subfolder Hell on SharePoint?

  1. Pleasure ladies! Glad to help.

    Like

  2. Athena says:

    Thank you V, this is so relevant with our current “clean up” have shared with our Data Stewards.

    Like

  3. Jeanndré Spies says:

    Thank you. Great tip about exporting to excel!

    Kind Regards,

    Jeanndré Spies

    C: 0728744745 | LinkedIN | Twitter: @jeanndre

    Like

  4. shewrite63 says:

    Thanks for this refresher. Some of the users on our new 2013 migration are catching on well. Others appreciate the reassurance that we can copy the existing structure then fix things up later. Bookmarked :o)

    T

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s