Organisation5 min read
Setting Up a Folder Structure in OneDrive and SharePoint: Layout, File Names, Bulk Renaming
According to Microsoft, shared company files belong in a SharePoint team site rather than a personal OneDrive. How to keep the structure flat, agree on file names and rename old files in one go.
- #organisation
- #digitalisierung
- #onedrive
Before creating the first folders, it is worth asking a question many guides skip: do the company's files belong in OneDrive at all? Microsoft draws a clear line here. OneDrive is one person's own storage, much like the hard drive in their computer. Files that several people work on and that belong to the business should go into a SharePoint team site, which is created automatically when you set up a team in Microsoft Teams (Microsoft Learn: Set up file storage and sharing).
In practice, if the customer folders sit in the owner's OneDrive and she leaves or her account is deleted, the shared filing system depends on that single account. A team site's library belongs to the group.
When OneDrive on its own is enough
For sole traders, Microsoft explicitly recommends OneDrive with case-by-case sharing, and the same for two co-owners who share files back and forth. Once three or four people work on shared customer files, a team site is the better choice. The folder structure described here works the same either way: in OneDrive as folders under "My files", in SharePoint as folders in the document library.
People working in a team can still see the library in File Explorer. With "Add shortcut to My files", a shared folder or a whole library appears in your own OneDrive and syncs like a local folder. You need edit permission on the folder for this (Microsoft Support: Add shortcuts to shared folders).
A structure with few levels
For most small businesses, a flat layout with four to six main folders is enough. They should follow the work, not the people. An example for a small service company:
- 01_Customers: one subfolder per customer, named with customer number and name, such as
10234_Miller-Plumbing. - 02_Projects: only if projects cannot clearly be assigned to one customer; otherwise keep them as subfolders under the customer.
- 03_Admin: contracts, insurance, vehicles.
- 04_Finance and HR: keep these apart if not everyone is allowed in.
- 09_Archive: closed customers and past years.
The leading numbers fix the order regardless of the names. Hardly any small business needs more than three levels below a main folder. Every extra level is one more decision when filing something, and those decisions are where filing systems break down in daily use.
Permissions: separate areas work better
In OneDrive you can share any folder with individual people, choosing between edit and view. That quickly becomes confusing, because nobody remembers which subfolder is shared with whom. For confidential areas such as HR and finance, Microsoft suggests a separate team site that only a small group can access. That is cleaner than a folder with special permissions inside the shared library.
For external customers who need to see or upload files, Microsoft also recommends a separate site per customer, so one customer cannot accidentally see another customer's documents.
File names that sort properly
A good folder structure does not help much if every folder contains quote_new_final2.docx. Three rules are enough:
- Date first, as YYYY-MM-DD, for example
2026-03-14_Quote_Heating.pdf. This ISO 8601 format sorts chronologically when sorted alphabetically. - No version numbers in the name. OneDrive and SharePoint keep earlier versions of a file themselves. Right-click the file and choose "Version history" to view and restore an older version (Microsoft Support). How many versions are kept is set by the administrator.
- Avoid forbidden characters. OneDrive and SharePoint do not allow
" * : < > ? / \ |, leading or trailing spaces, or names such asCONordesktop.ini(Microsoft Support: Restrictions and limitations in OneDrive and SharePoint). Files moved from an old network drive often fail to upload for this reason.
Very deep folder chains with long names cause problems too, because different programs cope with different path lengths. That is another argument for few levels.
Renaming old files in one go
A move usually brings hundreds of inconsistently named files. On Windows, PowerRename from Microsoft's free PowerToys does the job: select the files in Explorer, right-click, "Rename with PowerRename". It replaces parts of names, numbers files, can write the creation date into the name as $YYYY-$MM-$DD, and shows a preview before anything changes. A mistake can be undone with Ctrl+Z in Explorer. With regular expressions it can even turn a European-style date like 29-03-2020 into 2020-03-29 (Microsoft Learn: PowerRename).
Bulk Rename Utility and Advanced Renamer are often mentioned as alternatives. Both are free only for private use. For business use, both vendors require a paid licence, and Bulk Rename Utility needs one per computer (Bulk Rename Utility licence terms, Advanced Renamer).
Rename before uploading, and work on a copy. If hundreds of files are renamed at once inside a synced folder, the OneDrive client has to transfer every change, and anyone who has one of those files open will run into conflicts.
Getting the team on board
Setting up the structure takes about an hour; getting everyone to use it is harder. Half a page listing the main folders and naming rules, pinned next to the screen, helps, as does a fixed date about four weeks later to check together which files have ended up on desktops or in the top-level folder after all. For photos and receipts coming from phones there is a separate guide: Clearing up a small business's photo and receipt folder in an hour.
When this approach does not fit
A folder system in OneDrive or SharePoint is not an archive in the sense of legal retention duties. In Germany, invoices and accounting records must be kept for years under Section 147 of the Fiscal Code (Abgabenordnung), in a way that prevents unnoticed changes. A folder structure in which every authorised user can delete or overwrite files does not achieve that by itself. That is the job of the accounting software or an archiving system. The article on the paperless office covers this in more detail.
And if most work happens in industry software with its own document storage, do not maintain a second structure in OneDrive alongside it. Two filing systems for the same documents almost always mean that neither one has everything.
Read next
Organisation
Cleaning Up a Small Business's Photo and Receipt Files in One Hour
Free browser tools can turn scattered phone photos, scanned receipts and a quick look at the company website into a usable system within an hour — here's the order that actually works.
Organisation
Asana for Free: Creating a Project, Setting Deadlines and the New Two-User Limit
Asana's free plan handles projects and tasks with due dates. Since November 2025, however, it has been limited to two users for new accounts.
Organisation
Sorting Files with Sorana: What the AI Agent Does and How to Test It Safely
Sorana is a desktop AI workspace that can organise files on request. How it works, what it costs and what to watch out for on data protection.