Now that I’ve got your attention with the donuts… 🙂
I was recently asked what the pros/cons of metadata versus folders were and if my opinion has changed in the modern SharePoint world. I’ve documented my complete list below for both metadata and folders and have highlighted (*) what I’ve added to address the new, modern capabilities of SharePoint.
In SharePoint, you have 4 options for organizing content in a library:
- no folders nor metadata (Use only search and sorting to find a document)
- combination of metadata and folders
- Allows for easy filtering/grouping/sorting by metadata on-the-fly *
- Microsoft Flow logic can leverage metadata *
- You can set a retention label based on a metadata value *
- Can update in Office clients in SharePoint property pane *
- Reducing/eliminating nested folder structures results in a shorter URL length
- Changing metadata does not change the URL (changing folder does)
- Better for new people (they don’t have to know folder structure)
- Flexible to change a value after-the-fact
- Higher data integrity with metadata value names (more controlled than folder names)
- Metadata is indexed and therefore searchable
Pro-tip: standardize metadata thru the use of site scripts and site designs for common sites across your environment (Team sites, Project sites, Community sites, etc.)
- Viewing an entire library thru File Explorer (OneDrive Sync Client) can be confusing since there are no folders to organize, only metadata. (You can’t see metadata in File Explorer)
- Takes time for end-users to fill in; perceived to be slower than creating a folder
- Maintenance of metadata configuration requires training
- Cannot set permissions based on a metadata value
- Requires setup prior to documents being added (unless you allow fill-in values)
- If metadata is set as Required (not Optional) in SharePoint, when it is synced using the OneDrive Sync client, all files in the library will be locked from File Explorer (whether the metadata is filled in or not) *
- Folders are returned in search results *
- Retention label can be defaulted at a folder level *
- Can set permissions at the folder level
- Can share at the folder level
- Can sync at the folder level (OneDrive Sync Client)
- Can see folders in a synced library using File Explorer
- Easy for end-users to understand
- End-users can self-serve folder creation
Good-to-know: A Microsoft Teams channel provisions a folder in the Teams’ document library in the SharePoint site associated to the Team.
- You can’t filter on folder name
- Too many nested folders cause long URLs
- End-users generally create too many folders and complex structures
- End-users not familiar with the folder structure may not find it intuitive
- Limits you to 1 way of organizing content
- You need to click into the folder to view files inside of it
- To move documents from 1 folder to another will change the URL (breaking links)
- You can’t set a different default view inside a folder from outside a folder in the modern library experience *
Pro-tip: Left to their own devices, end-users will create folders (and usually a lot of them) to self-organize their content. You can turn off folder creation at the library level, however before doing so, ensure you have a strong metadata story for the library and a good training program for end-users.
It depends of course. 😉 My current preference is either metadata or a combination of metadata with a level (or 2) of folders for high-level organization. You can flatten the views without folders if it makes sense to do so and if you don’t run into the listview threshold limit. There are caveats to this as experience over time has shown me, particularly in SharePoint collaboration sites and not the more-structured publishing sites.
I’ll go out on a limb and share the typical things I consider:
- how open are your end-users to change? This can have a significant impact on the success of moving from the folder paradigm to metadata
- is this on a collaborative team site where there’s no requirement for structured business process automation? If so, you can use some limited foldering to organize it (although not required) Skip the metadata unless you have a reason to justify it
- is this for a collaboration team site that is fairly short-lived? If so, you can use some limited folders to organize it (although not required). Skip the metadata unless you have a reason to justify it
- how structured do you need the content to be? Is there business processes built off of the content that require metadata to function? If so, use metadata
- will you require automated retention to be set at a document level based on a metadata value rather than at a container level? (folder, library, site) If so, use metadata
- do you need to set permission based on content within a grouping of files in a library? If so, use folders (and metadata if required)
- Do you need to sort/filter/group documents based on multiple criteria? If so, use metadata for the criteria you need to sort/filter/group by
- is there a requirement to sync a portion of files using the OneDrive Sync client? If so, use folders (and metadata if required)
- do you expect there to be more than a couple hundred documents in the library? If so, use metadata to help filter/group/sort them
- do you expect there to be thousands of documents in the library? Watch the listview threshold issue and the metadata column types you’re wanting to group/sort/filter by. Refer to my blog post for more details: List View Threshold Error… watch your column types!
Are these recommendations true in all cases I come across? No, however they’re true for the majority of cases and a good place to start.
Share these pros/cons with Site Builders and Adoption/Training teams across your organization so they understand them and can tailor their solution and training accordingly. If you know the pros and cons, you can make an informed decision about what to use for your own use-case.
Thanks for reading. 🙂