How to Create a Document Library With Required Metadata

When you create a document library in SharePoint, you often need contributors to fill in specific details about each file, such as project name, document type, or approval status. Without required metadata, users can upload files without providing this information, making it hard to organize and find documents later. SharePoint lets you add columns to a library and mark them as required, forcing users to enter that data before they can save a file. This article walks you through creating a new document library, adding custom columns, and configuring those columns to require input on every upload.

What Required Metadata Means in a SharePoint Document Library

Metadata is data about a file, such as its author, creation date, or a custom category like Project Name. When you mark a column as required, SharePoint prevents users from uploading or saving a file unless they provide a value for that column. This applies to all methods of adding files: drag-and-drop, the Upload button, and the New button for creating documents from templates.

Before you begin, you need at least Edit or Contribute permission on the site where the library will live. Site owners can create libraries and manage columns. If you are not a site owner, ask your administrator for the appropriate access.

Prerequisites

You must have a SharePoint site where you can add a library. The steps in this article work for SharePoint Online (part of Microsoft 365) and SharePoint Server 2019 or later. If you use SharePoint Server 2016 or older, the interface may differ slightly, but the column configuration process is similar.

Steps to Create the Document Library and Add Required Columns

This process has two main parts: creating the library and then adding columns that enforce required input. Follow these steps in order.

1. Go to Site Contents and create a new library
   Open your SharePoint site. Click the gear icon in the upper right and select Site contents. On the Site contents page, click New and then choose Document library. In the dialog that appears, type a name for the library, such as “Project Documents” or “Team Files.” Click Create.
2. Open Library Settings
   Inside the new library, click the gear icon again and select Library settings. If you do not see Library settings, you may need to click List settings or Library settings from the settings menu. This page shows all current columns and settings for the library.
3. Add a column for metadata
   Under the Columns section, click Add a column. Choose the type of column you need. Common types for metadata include Choice for a drop-down list, Single line of text for short entry, or Date and Time. For example, select Choice to create a list of document categories.
4. Configure the column name and options
   In the column settings page, type a name like “Document Type.” Under Type each choice on a separate line, enter options such as Contract, Report, Invoice, and Policy. Set Display choices using to Drop-Down Menu. Under Default value, you can leave it blank or select one option.
5. Make the column required
   Scroll down to the Require that this column contains information section. Select Yes. This setting forces users to provide a value for this column before they can save a file. Click OK to save the column.
6. Repeat for each required metadata field
   Add additional columns as needed, such as Project Name (Single line of text) or Approval Status (Choice). For each column, set the required option to Yes. You can also add multiple columns at once by using the Add from existing site columns link in Library settings.
7. Test the library with a file upload
   Go back to the library. Click Upload and select a file. After the file uploads, a panel appears asking you to fill in the required columns. If you try to save without entering data, SharePoint displays an error and prevents the save. Enter the required values and click Save.

Common Mistakes and Limitations When Using Required Metadata

Setting up required metadata is straightforward, but several issues can cause confusion or frustration. Here are the most frequent problems and how to avoid them.

Required Metadata Does Not Appear When Uploading Files via Drag-and-Drop

When you drag and drop files from your computer into the library, SharePoint does not always prompt for metadata immediately. The files are uploaded, but the metadata panel may not appear. To fix this, after the files appear in the library, select all the newly uploaded files by clicking the checkbox next to each one. Then click the Edit button in the toolbar. The panel opens and shows all required columns. Fill in the values and click Save. To avoid this, use the Upload button instead of drag-and-drop when you want metadata prompts.

Users Can Still Save Files Without Metadata by Using Quick Edit

Quick Edit mode in SharePoint lets users edit multiple rows in a grid view. If a user has Edit permission, they can paste file names into the grid and save without filling in required columns. SharePoint does not enforce required metadata in Quick Edit mode. To prevent this, disable Quick Edit for the library. Go to Library settings > Advanced settings and set Quick Edit to No. This removes the Quick Edit button from the library toolbar.

Changing a Column from Optional to Required Does Not Affect Existing Files

If you add a required column to a library that already contains files, those existing files remain with a blank value for that column. SharePoint does not backfill required metadata. To fix this, you must manually edit each existing file and provide the missing metadata. You can do this by selecting multiple files and using the Edit button in the toolbar, then filling in the column values for all selected files at once.

Document Library With Required Metadata vs Without Required Metadata

Item	With Required Metadata	Without Required Metadata
Upload behavior	Prompts for column values before saving	Saves file immediately with no prompts
Data consistency	Every file has values for specified columns	Many files may have blank metadata
Search and filtering	Reliable filtering and search by metadata	Incomplete or missing metadata reduces search accuracy
User training needed	Users must learn to fill in fields	No additional training required
Administration effort	Higher initial setup time	Lower setup time but more cleanup later

You can now create a document library that enforces required metadata on every file upload. Start by building the library and adding columns for the information you need, such as project name, document type, or department. Set each column to require input, then test the library to confirm the prompts appear. For libraries with existing files, remember to update those files manually or use the Edit button to fill in missing metadata in bulk. A useful advanced tip: use a site column instead of a library column so you can reuse the same metadata across multiple libraries on the same site.