Knowledge Base · Section M

Metadata & Organisation in SharePoint

Columns, term sets, views, naming conventions — the structural decisions that make SharePoint and Copilot actually work. There is no AI without IA.

The 45 topics in this section cover every metadata decision you’ll need to make when building a SharePoint library that scales beyond a thousand files, supports Copilot, and stays maintainable for years. Start with column types, move through the term store, master views, and finish with the naming conventions that hold it all together.

45 Topics

4 Areas

~28 Min read

45 topics

Column Types

M-01 → M-12 · 12 topics

The foundational column types — Choice, Text, Person, Date, Lookup, Managed Metadata — and how to pick the right one for your data. Get this layer right and everything else works.

M-01

Create a New Metadata Column

Add a column in 8 steps. The 3-column starter rule that transforms any library.

M-02

Choose the Right Column Type

Picking the wrong type means broken filters. Match the data shape to the column.

M-03

Choice Column

The workhorse of clean metadata. Fast, consistent, easy to filter.

M-04

Single Line of Text Column

Use deliberately, not as default. Where consistency goes to die.

M-05

Multiple Lines of Text Column

For descriptions and change logs. Append Changes is the hidden superpower.

M-06

Person or Group Column

Connect to real M365 accounts. Powers [Me] views and automated notifications.

M-07

Date and Time Column

Review dates, expiries, deadlines. The time dimension your library needs.

M-08

Yes/No Column

Simplest column type. Perfect for triggers, checklists, and binary states.

M-09

Number Column

For counting, calculating, aggregating. Anything you might sum or average.

M-10

Currency Column

When the data is money. Handles symbols, decimals, and totals correctly.

M-11

Hyperlink or Picture Column

URLs and images as metadata. For references, registers, and visual identification.

M-12

Lookup Column

Connect lists together. Maintain data once, use it everywhere on the site.

The Term Store

M-13 → M-18 · 6 topics

The central brain of your tenant’s metadata. Define vocabulary once, use it everywhere. This is the foundation for serious Copilot readiness.

M-13

Managed Metadata Column

Your tenant-wide vocabulary. The foundation for serious AI readiness.

M-14

What is the Term Store?

The central brain of your tenant’s metadata. Where term sets and groups live.

M-15

Adding Terms (Manual)

Day-to-day term management. Synonyms, descriptions, translations.

M-16

Bulk Upload Terms via CSV

When you have hundreds of terms to load. Migrate taxonomies in one operation.

M-17

Using a Term Set in a Column

Connect the Term Store to a library. Where central work pays off.

M-18

Managed Metadata vs Choice

Both look similar to users. Choosing right matters for long-term scalability.

The complete toolkit Clean up the mess. Keep it clean.

The File Sanity Kit is the companion to this section. The Container Method™ — audit, restructure, and future-proof SharePoint using a thinking system that holds. No IT admin required. Methodology deck, full workbook, and 8-tab Excel planner.

Get the File Sanity Kit — $27 →

Structural Columns

M-19 → M-28 · 10 topics

The columns every library should have — Document Type, Department, Status, Project, Due Date. Combined, they answer almost every question users ask about content.

M-19

Calculated Column

Derive values from other columns automatically. Auto review dates, summary fields.

M-20

Location Column

Real-world addresses with structured map data. For site visits and registers.

M-21

Document Type Column

The single most important column. The number-one Copilot enabler.

M-22

Department/Function Column

Second-most-important after Document Type. Who owns what.

M-23

Document Status Column

Draft, Review, Approved, Published. Makes the lifecycle visible.

M-24

Topic or Category Column

When content crosses departments. The cross-cutting view.

M-25

Project Name Column

Connect every project file. See all content for one project at once.

M-26

Project Phase Column

Initiation, Planning, Execution, Closure. Portfolio-level reporting.

M-27

Project Lead Column

Single owner per project. Clean accountability and automated notifications.

M-28

Due Date Column

Turn documents into actionable items. Powers deadlines and reminders.

Views

M-29 → M-35 · 7 topics

How views replace folder navigation with something smarter. Flat lists, grouping by metadata, [Me] filters, and the missing-metadata check that keeps a library clean.

M-29

Creating a New View

Saved configurations of how data displays. One library, many uses.

M-30

No Folders (Flat View)

See every file regardless of folder. Where metadata-first thinking starts.

M-31

My Documents View

One filter, infinite personalisation. The [Me] token in action.

M-32

Group by Document Type

Folder-like browsing without folders. Set default collapsed for clean entry.

M-33

Recently Modified View

What’s changed. The ‘what’s new’ lens for managers and team members.

M-34

Missing Metadata View

Files that need attention. Five-minute weekly cleanup task.

M-35

Views vs Filtering vs Sorting

Knowing which to use saves time and avoids view sprawl.

Naming & Workflow

M-36 → M-45 · 10 topics

How files are named affects how findable they are — by humans, search, and Copilot. Plus the workflow shortcuts that make metadata practical at scale.

M-36

Naming Conventions

Turn random into intentional. The single most important file name rule.

M-37

Naming Conventions Examples

Concrete before-and-after pairs. What good naming looks like in practice.

M-38

Naming Conventions Rules

The handful of rules that prevent 90% of naming chaos.

M-39

Naming Dos and Don’ts

The quick reference card. What to do, what to avoid, why.