How do you make a SharePoint library behave like a folder on your computer?

By Michael Obraitis, Managing Partner, and Michael Dale, CEO · Published August 21, 2026 · Last reviewed August 2026 · ADAM Pulse Knowledge Base · Microsoft 365 Series

Short answer

You do not map a SharePoint library to a drive letter any more. You connect it through the OneDrive sync app, and it appears in File Explorer on Windows or Finder on macOS like an ordinary folder.

There are two ways to do that, and they are not equivalent:

• Add shortcut to OneDrive puts the library or a single folder inside your own OneDrive. Because it lives in your OneDrive rather than on the machine, it follows you to every computer you sign in to.
• Sync creates a connection between that library and that one computer. Set it up again on a second machine and you have configured it twice.

Microsoft's own recommendation is not ambiguous:

We recommend using OneDrive shortcuts as the more versatile option.

Two things that catch people out, both covered below: you cannot use both methods on the same library — it is blocked by design, not merely discouraged — and there is a 300,000-item ceiling across everything you sync that applies to shortcuts too.

What "map SharePoint as a drive" usually means

Almost nobody who asks this question wants a drive letter. What they want is:

• SharePoint files visible in File Explorer or Finder
• Opening a file without going through a browser
• Saving straight from Word or Excel
• Changes going back to SharePoint on their own
• Something usable when the connection drops
• Ordinary drag-and-drop

All of that is what the OneDrive sync app does. The drive letter is the mental model people arrive with, inherited from a file server. It is the one part of the request that modern SharePoint does not grant, and the one part nobody actually misses once the folder is there.

The two methods, and which one to reach for

Add shortcut to OneDrive

The label varies slightly depending on where you are in the interface — you will see Add shortcut to OneDrive in some places and Add shortcut to My files in others. They are the same feature.

1. Open the SharePoint site in a browser.
2. Open the document library.
3. Select the folder you want — or the library itself.
4. Choose Add shortcut to OneDrive.
5. Open File Explorer and expand OneDrive – Your Organization Name.

The folder appears there, marked with a small shortcut arrow. Nothing downloads until you open something.

The advantage that matters in practice is that you can point a shortcut at one folder rather than the whole library. Microsoft's guidance is explicit about why that helps:

Shortcuts are more performant because rather than syncing the entire library, only the specific folder is synced. Additionally, because the shortcuts are added to a user's OneDrive rather than to the device, it's easier to access content across all devices.

Sync

1. Open the SharePoint site and the document library.
2. Choose Sync.
3. Let the browser hand off to OneDrive.
4. Sign in with your work account if prompted.
5. Open File Explorer.

The library appears under your organisation's name. Edits flow both ways.

Sync is still the right answer when you specifically want a relationship tied to one machine — a workstation that must hold a particular library locally, for instance, without that arrangement following the user to their laptop.

Side by side

Files On-Demand, and the state everyone misreads

Adding a library does not drag every file onto the disk. Files On-Demand shows the files in File Explorer while leaving the contents in the cloud until something opens them.

There are three states, not two, and the difference between the middle one and the last one is where people get burned.

This matters if anyone is relying on offline access. Somebody who checked that their files "had the green tick" before a flight, and did not right-click and choose Always keep on this device, may find them gone. Storage Sense makes this more likely still: it can be configured to flip anything unopened for a set number of days back to online-only.

To reclaim space deliberately, right-click and choose Free up space. The cloud copy is untouched.

The number nobody mentions until it hurts

This is the most useful figure in this article, and it is missing from most guides.

Microsoft documents a 300,000-item soft limit for OneDrive sync — and the wording is broader than people assume:

...the same performance issues can occur if you have 300,000 items or more across all libraries you're syncing, even if you aren't syncing all items in those libraries. The 300K file "soft" limit for OneDrive Sync also applies to shortcut folders.

Three things follow from that sentence:

• It is cumulative across everything, not per library. Six libraries of 60,000 items each puts you over.
• It counts items you are not even using. Being in scope is enough.
• Shortcuts do not exempt you. The natural assumption — that shortcuts are lighter, so the limit is a sync-button problem — is wrong.

If a site is slow and nobody can explain why, add up the items across every library each affected person has connected before looking anywhere else.

Path length, which breaks things silently

Two separate ceilings, and they interact badly.

The 400-character limit covers folder path plus filename after decoding, so a short filename buried in a deep structure still fails. Files that exceed it do not sync, and the failure is quiet — the file is simply not there locally.

This is where shortcuts help twice over. Pointing at a folder several levels down means the local path starts at that folder rather than at the top of the library, which buys back a considerable number of characters. Microsoft has also been chipping at this recently: a 2026 sync app update corrected how shortcut paths are measured, so fewer files are wrongly flagged as too long, and administrators can now shorten the default local folder name to reclaim more.

You cannot use both methods on one library

This is usually described as something to avoid because it causes confusion. It is firmer than that. It is blocked, and Microsoft says so plainly:

This behavior is by design. You can't sync a document library that's already set as a shortcut in OneDrive. Similarly, you can't use the Add shortcut to My files option if the document library is already synced.

The error reads:

Sorry, we can't sync this folder. You're already syncing a shortcut to a folder from this shared library.

Pick one method per library and stay with it. If you inherited a machine where somebody tried both, remove one relationship before adding the other. Recent sync app builds will offer to replace an existing sync location with a folder shortcut rather than making you unpick it manually.

Why the Sync button is missing

Usually because somebody switched it off deliberately. There are two distinct controls, and knowing which one is in play saves an afternoon.

Tenant-wide. A SharePoint administrator can remove the Sync button across every library in the organisation using the Set-SPOTenant cmdlet with -HideSyncButtonOnTeamSite $true.

Worth knowing: this blocks new syncs from starting but does not disturb syncs that already exist. So a colleague who set theirs up last year still has a working folder while you cannot create one, and neither of you has done anything wrong.

Per site. A site administrator can make a site unavailable offline, under Site Settings → Search and Offline Availability → Offline Client Availability. The give-away is a specific error:

Options set for this library by your administrator prohibit users from syncing it to a local computer. For more information, see your SharePoint administrator.

If you see that sentence, it is a setting, not a fault. Stop troubleshooting the client.

Does deleting a local file delete it from SharePoint?

Yes, in the ordinary case. A synced folder is the same data seen from a different window, not a second copy of it.

That is the whole point of synchronisation and it is also the reason for the next section.

Sync is not backup

Worth stating flatly, because the folder looks exactly like the local drive it replaced, and people carry the old assumptions across.

If a user deletes a directory, a script overwrites a hundred files, or ransomware encrypts what it can reach, synchronisation does what it was built to do: it propagates the change. Version history and the recycle bin help, and they are bounded — by retention windows and by how long it takes anyone to notice.

Whether that is sufficient is a decision to make on purpose rather than by default. It depends on the recovery window the business can actually tolerate and on what any regulator expects. The wrong time to work it out is while looking at an empty folder.

Permissions do not change

Connecting a library locally grants nothing. Read access stays read access. If someone can suddenly edit files they should not, that permission already existed in SharePoint and the local folder merely made it visible.

What about a drive letter?

Legacy WebDAV mapping exists. It is not where Microsoft 365 is going, and it gives up Files On-Demand, offline handling, conflict resolution and modern authentication to get a letter in front of the path.

SharePoint is a collaboration platform, not an SMB file server. If the requirement is genuinely "make it look like a folder," the sync app already does that. If the requirement is "a drive letter because our line-of-business application demands one," that is a different problem and worth solving as one, rather than mapping the whole library and hoping.

Teams files and SharePoint

Files in a standard Teams channel live in a SharePoint document library. Teams is the interface; SharePoint is the storage. So the answer to "why are my Teams files in SharePoint?" is that they were always in SharePoint.

Which also means they connect locally the same way: open the underlying library and add a shortcut.

A checklist worth keeping

Before you start

• OneDrive desktop app installed and signed in with the work account
• The library opens in a browser
• No existing sync or shortcut on the same library

Setting it up

• Add shortcut to OneDrive, targeting the narrowest folder that does the job
• Confirm it appears under OneDrive – Organisation in File Explorer
• Open a file, change it, confirm SharePoint sees the change

Offline

• Identify what genuinely has to work without a connection
• Right-click and choose Always keep on this device — the solid green circle, not the outline
• Test it with the network off, if it matters

Operationally

• Total items across everything connected, per person, kept well under 300,000
• Deep folder structures flattened before they hit 400 characters
• Backup treated as a separate decision from sync

Frequently asked questions

Related articles

• What does AI data governance actually require in 2026? — the same theme of data reaching places nobody scoped, one layer up.
• Stop making one Google account the master key to your entire business — another case where convenience quietly becomes an exposure.
• Five inexpensive things you can do today to make your business much harder to hack — including why sync is not the same thing as a backup.

References

Every claim here comes from Microsoft's own documentation on Microsoft Learn — the product guidance, the service limits, the troubleshooting articles and the sync app release notes. No vendor blogs and no forum folklore, because the two things people get wrong about this (the item ceiling and what a green tick actually promises) are both documented facts that simply do not travel well.

1. Microsoft Learn — Sync in SharePoint and OneDrive— the primary source for the two available methods and for Microsoft's position that OneDrive shortcuts are the recommended option because they follow the user across devices rather than binding to one machine. Also the source for the PowerShell command that hides the Sync button tenant-wide and the note that removing it blocks new syncs without affecting existing ones.
2. Microsoft Learn — Recommended sync app configuration— source for the quoted reasoning that shortcuts are more performant because only the specific folder is synced rather than the entire library, and that content is easier to reach across devices because the shortcut lives in the user's OneDrive.
3. Microsoft Learn — You can't sync a shared folder that's set as a shortcut in OneDrive sync app— source for the fact that combining Sync and Add shortcut on the same document library is blocked by design rather than merely discouraged, and for the exact wording of the error a user sees.
4. Microsoft Learn — SharePoint limits— source for the 300,000-item soft limit for OneDrive sync, the statement that it is cumulative across all libraries being synced even where not all items are in use, the explicit note that it also applies to shortcut folders, the 400-character decoded path limit, the 250 GB single file upload limit and the 30 million item library ceiling.
5. Microsoft Learn — Overview of OneDrive in Microsoft 365— source for how Files On-Demand presents files in File Explorer without downloading them, the cloud and green tick status icons, and the Always keep on this device and Free up space commands.
6. Microsoft Learn — Query and set Files On-Demand states in Windows— source for the three distinct Files On-Demand states (always available, locally available, online-only) and their underlying pinned, clearpin and unpinned file attributes, which is what makes the locally available state reclaimable and the always available state not.
7. Microsoft Learn — Query and set Files On-Demand states on Mac— the macOS equivalent, and the source for SharePoint libraries behaving the same way in Finder as they do in File Explorer.
8. Microsoft Learn — Resolve sync issues in OneDrive for work or school— source for the per-site Offline Client Availability setting under Site Settings, the exact administrator-prohibits-syncing error text, and the warning that renaming a synced folder after the fact breaks the sync relationship.
9. Microsoft Learn — IT Admins: use OneDrive policies to control sync settings— source for the 120-character ceiling on the local OneDrive sync root folder path and for the guidance to keep folder names short to reduce max-path failures.
10. Microsoft Learn — OneDrive sync release notes— source for the 2026 change to how folder shortcuts are measured against the maximum path length, and for administrators being able to set a custom, shorter name for the local OneDrive folder.