How to Set Folder Default Values in SharePoint
Some users won’t stop using folders. Folder Default Values make peace: keep folders, but get metadata for free.
What it is
Folder Default Values is a feature that lets you assign automatic metadata values to a folder. Drop a file into the ‘HR Policies’ folder, and SharePoint automatically tags it with ‘Document Type: Policy’ and ‘Department: HR’ — no user action required. The folder becomes a bridge between old folder-thinking and new metadata-thinking.
This is the right tool for teams transitioning from a folder-heavy mindset to a metadata-driven library. You don’t have to fight the habit; you embrace it and use it. Users keep dropping files into folders the way they always have, and the library gains structured metadata automatically.
It’s also useful for high-volume bulk uploads. Set up the right folders with the right defaults, drop in 500 files, and they’re all properly tagged in seconds. Combined with Quick Edit / Grid View for any corrections, this is one of the fastest ways to migrate a folder-heavy shared drive into a metadata-rich SharePoint library.
When to use this
- When users insist on using folders and you want metadata anyway.
- When migrating from a folder-heavy shared drive to SharePoint.
- When bulk uploading files where the folder structure carries meaning.
- When you want to reduce the manual tagging burden on users.
How to do it
- Open the library and go to Library settings.
- Open Column default value settings.
- Pick a folder.
- Set default values for one or more columns (e.g. Document Type = Policy, Department = HR).
- Save.
- Test by uploading a file to that folder and confirming metadata is applied.
- Repeat for other folders with their respective defaults.
Best practices
- Best ‘bridge’ for users who refuse to stop using folders. Don’t fight the habit; channel it.
- Speed up bulk uploads. Folder defaults turn 500 file uploads into 500 properly-tagged files.
- Document the folder defaults. Future admins need to understand why files in ‘HR Policies’ all show ‘Policy’ tag.
- Combine with required columns and grid view. Defaults set the values; required columns enforce them; grid view fixes anomalies.
Common mistakes
- Setting up defaults but not telling anyone. Users wonder why some files have tags and others don’t.
- Defaults that contradict reality. If users put non-policies in ‘HR Policies’, the default tags them wrong.
- Relying on defaults instead of teaching metadata. Defaults are a transition tool, not a permanent substitute.
The File Sanity Kit gives you the Container Method™ — audit, restructure, and future-proof SharePoint without IT admin. The complete methodology, full workbook, and 8-tab Excel planner.
Get the File Sanity Kit — $27 →FAQ
What are folder default values in SharePoint?
Folder default values let you set automatic metadata for files uploaded to specific folders. Upload a file to the ‘HR Policies’ folder and its Document Type column auto-populates with ‘Policy’, Department with ‘HR’. The folder becomes a metadata stamping machine — saves users from tagging manually and makes legacy folder structures actually useful.
How do I set folder default values in SharePoint?
In Library Settings, go to Column default value settings, choose your library, then click on a folder to set defaults for files uploaded there. Pick the columns you want to default and the values. Save. From that point, every file uploaded to that folder is auto-tagged with the chosen values.
Can I set default values without using folders?
Yes — column-level defaults work without any folder structure. On the column itself, set a default value that applies to every new file in the library. Use folder default values when different folders need different defaults; use column-level defaults when one default applies library-wide. The two can coexist.
Why aren’t my folder default values applying to existing files?
Because defaults only apply to files uploaded after the rule is set — they don’t backfill existing files. To apply metadata to existing files, use Grid View or a Power Automate flow to set the values manually. Once defaults are in place, future uploads will tag automatically — the historic gap stays unless you fix it.