How to Organize Documents in SharePoint (Folders, Metadata and Views)

Published on by

Our account team had a shared drive with 14 folder levels and nobody could find last month’s invoice. Jordan Ellis, the account manager, asked me to move their client files into SharePoint without recreating that maze.

The fix was a library that uses one level of folders for each client, a few metadata columns for everything else, and views that answer the questions people actually ask, like “show me every invoice.”

In this tutorial, I’ll show you how to organize documents in SharePoint step by step, using a real client library with folders, columns, folder default values and saved views.

Here’s what we’re building, the ESP Client Files library grouped by document type:

ESP Client Files library grouped by Document Type with Client, Status and Document Date columns
  • Folders for the one thing that never changes per file: the client.
  • Metadata columns for document type, status and date.
  • Folder default values, so the Client column fills itself in on upload.
  • Views that group and filter across every folder at once.

Before You Start

You need Edit or Owner rights on the site to create a library, add columns and change views. Everyone else only needs Read. If libraries are new to you, start with what a SharePoint document library is.

Plan the structure before you upload anything. Ask two questions: what never changes for a file (that can be a folder), and what people filter by (that should be a column). Here’s the plan I used:

NameTypeNotes
Client (folder)Folder, one levelHarbor Logistics, Pinecrest Dental, Summit Roofing
ClientChoiceFilled in automatically from the folder
Document TypeChoiceContract, Invoice, Proposal, Report
StatusChoiceDraft or Final
Document DateDate onlyThe date on the document, not the upload date

These are some of the nine sample files, all dated November 2026:

FileFolderDocument TypeStatus
Harbor Logistics – Service Agreement.docxHarbor LogisticsContractFinal
Harbor Logistics – Invoice 1042.xlsxHarbor LogisticsInvoiceFinal
Pinecrest Dental – Website Proposal.docxPinecrest DentalProposalFinal
Pinecrest Dental – Service Agreement.docxPinecrest DentalContractDraft
Summit Roofing – Invoice 1044.xlsxSummit RoofingInvoiceFinal
Summit Roofing – Project Proposal.docxSummit RoofingProposalDraft

Step 1: Create a Library for One Kind of Content

One library per kind of content keeps permissions and columns simple. Client files get their own library instead of sharing the default Documents library. Not sure whether you need a list or a library? See SharePoint list vs library.

  1. On the site home page or Site contents, select + New > Document library.
  2. In Create new document library, choose Blank library.
  3. Name it ESP Client Files, add a short description, and select Create. Clear Show in site navigation if it shouldn’t appear in the left menu.
Create a document library dialog with the name ESP Client Files entered

Checkpoint: the new library opens empty, with only the Name, Modified and Modified By columns.

Step 2: Add a Shallow Folder Structure

Folders still have a job: they group files that share permissions or a fixed owner. Keep them to one or two levels, because every level makes the path longer and the files harder to find.

  1. In the library, select + Create or upload > Folder. Older libraries show + New instead.
  2. Type Harbor Logistics in the Create a folder dialog. The folder color is optional.
  3. Select Create.
  4. Repeat for Pinecrest Dental and Summit Roofing.
Create or upload menu in the ESP Client Files library with the Folder option
Create a folder dialog in the ESP Client Files library with the folder name Harbor Logistics

Pick a naming convention and write it down. I use “Client – Document name” for files and plain client names for folders, with no dates or version numbers in folder names (SharePoint keeps the versions for you).

Important: the whole decoded path, folder names plus file name, can’t be longer than 400 characters. Deep trees hit that limit fast, especially when people sync the library. My SharePoint limits and boundaries guide lists the other caps.

Checkpoint: the library shows three folders and nothing else.

Step 3: Add Metadata Columns

Columns are where the real organizing happens. A file can only sit in one folder, but it can have as many tags as you need. The SharePoint column types cheat sheet explains every type if you want more than Choice and Date.

  1. Select + Add column to the right of the last column, choose Choice, and select Next.
  2. In the Create a column panel, name it Document Type and replace Choice 1-3 with Contract, Invoice and Proposal. Select + Add Choice for Report.
  3. Open More options if you want to turn on Require that this column contains information, then select Save.
  4. Repeat for Client (the three client names) and Status (Draft, Final).
  5. Add a Date and time column named Document Date with Include Time set to No.
Create a column panel adding the Document Type choice column with Contract, Invoice, Proposal and Report

Choice columns beat free text here. Nobody can type “Invoce” by mistake, and every filter and group works on clean values.

Checkpoint: the library header now shows Client, Document Type, Status and Document Date.

Step 4: Set a Default Value for Each Folder

This is the step most guides skip. A column default value tied to a folder fills in the Client column for every file dropped into that folder, so nobody has to tag it by hand.

  1. Select Settings (the gear icon) > Library settings, then More library settings in the panel.
  2. Select Column default value settings. The Change Default Column Values page opens.
  3. Pick the Harbor Logistics folder under Location to configure.
  4. Select the Client column, choose Use this default value, type Harbor Logistics, and select OK.
  5. Repeat for the other two folders.
Column default value settings page with the Harbor Logistics folder selected and Client set to Harbor Logistics

Checkpoint: each folder icon in the tree gets a small green marker, and the Client row shows Harbor Logistics with This folder as the source of the default value.

Change Default Column Values page with green markers on the three client folders and Harbor Logistics as the Client default

Step 5: Upload and Tag the Files

Now the files go in. Drag each client’s files into its folder, then fill in the remaining columns in one pass. If people keep files in OneDrive, sync or Add shortcut to OneDrive lets them work on the same library from File Explorer.

  1. Open a folder and drag the files onto the page, or select Upload > Files.
  2. Select Edit in grid view on the command bar. Inside a folder, it’s in the Options menu (the sliders icon on the right).
  3. Set Document Type, Status and Document Date for each row. Changes save as you leave each cell.
  4. Select Options > Exit grid view when you’re done.
Edit in grid view in the Summit Roofing folder with Document Type, Status and Document Date filled in

Checkpoint: I never typed a client name, yet all nine files show the right Client. The folder defaults did that work.

Step 6: Create Views That Group and Filter

Views are saved ways of looking at the same files. They let one library answer many questions without moving anything. For a deeper look at view settings, see my complete guide to SharePoint views.

First, a view that ignores folders and groups every file by type. Until you flatten it, the three folders sit in an Unassigned group, because folders have no document type:

  1. Select the Document Type column header and choose Group by Document Type.
  2. Select the All Documents view button, choose Save view as…, name it By Document Type, and select Save.
  3. Select Options (the sliders icon) > Edit view. The classic Edit View page opens.
  4. Expand Folders, select Show all items without folders, and select OK.
Edit View page with the Folders setting Show all items without folders selected

Then a filtered view for the finance team:

  1. Select Filter (the funnel icon) to open the filters pane.
  2. Under Document Type, check Invoice. Under Status, check Final.
  3. Select the view button, choose Save view as…, and name it Final Invoices.
Filters pane with Invoice and Final checked showing three invoices from three client folders

Checkpoint: Final Invoices shows three files from three different folders: invoices 1042, 1043 and 1044.

Step 7: Make the Best View the Default

People land on the default view, so pick the one that answers the most common question. For this team, that’s By Document Type.

  1. Switch to By Document Type.
  2. Select Options (the sliders icon) > Set current view as default.
View menu with Set current view as default for the By Document Type view

Note: only a public view can be the default. Personal views stay visible to the person who made them.

Test the Library

To test the setup, I uploaded a new file, Summit Roofing – December Invoice 1045.xlsx, into the Summit Roofing folder and set only Document Type to Invoice and Status to Final.

The Client column showed Summit Roofing the moment the upload finished, and Final Invoices grew from three files to four. Before that upload, the three November invoices totaled $13,345.50: $4,850.00, $2,375.50 and $6,120.00.

New invoice uploaded to the Summit Roofing folder with the Client column filled in automatically

That’s the payoff. Folders keep each client’s files together, and the views find any file in two clicks no matter which folder it sits in.

Same Library with Content Types or Document Sets

When different documents need different columns, a contract needs a renewal date while a report doesn’t, use content types instead of piling every column onto one library. My guide to SharePoint content types walks through it.

Document sets go one step further. They group related files, like everything for one project, into a single item with shared metadata. They’re great for case files, but they add setup, so I only reach for them when a plain folder plus columns isn’t enough.

Make It Production-Ready

  • Set permissions on the site or library, not on individual folders. Microsoft recommends staying under 5,000 unique permissions per library, and SharePoint permissions are much easier to audit that way.
  • Make key columns required in the column settings, so files can’t be saved without a Document Type.
  • Write the folder and naming rules on a page and show them to the team in a short training session.
  • Review the library every quarter: archive old files, remove unused choices, and check that check-out and check-in rules still fit.
  • Once a library passes 100,000 items, you can’t break permissions inheritance on it or its folders, so plan the structure early.

Troubleshooting

  • Folder is missing from + Create or upload: in Library settings > Advanced settings, set Make “New Folder” command available to Yes.
  • The Client column stays blank after upload: the default is set on a different folder, or the file was uploaded to the library root. Check the folder tree in Column default value settings.
  • A grouped view still shows folders: the view isn’t set to show items without folders. Edit the view and change the Folders setting.
  • A file won’t upload or sync: the path is probably over 400 characters. Shorten the folder or file names.

Where to Take It Next

Put the By Document Type view on a page with the Document library web part, so the team sees it on the home page. If contracts need sign-off before they count as Final, turn on content approval in the library.

More ways to get more out of your SharePoint libraries:

Frequently Asked Questions

Should I use folders or metadata in SharePoint?

Use both. Keep one or two levels of folders for things that never change per file, like the client or permissions boundary, and use metadata columns for everything people filter or group by.

How many folder levels should a SharePoint library have?

One or two. Each level lengthens the path, which is capped at 400 characters, and makes files harder to find and sync.

Can SharePoint fill in metadata automatically?

Yes. Column default value settings let you set a default per folder, so every file uploaded to that folder gets the value without anyone typing it.

How do I show all files without folders in a SharePoint view?

Edit the view and choose Show all items without folders under Folders, then save it. Microsoft explains the view settings in Create, change, or delete a view of a list or library.