How to Map SharePoint Metadata to Fields in a Word Document
Question details
The user wants to map and expose SharePoint document-library columns as document properties to automatically display metadata in Word document templates.
- Product
- Microsoft Word
- Device & OS
- not provided
- Scenario
- Setting up a Word template in a SharePoint library so that metadata like department, project, and document owner appear automatically in the document body.
- Observed behavior
- SharePoint library metadata needs to be dynamically linked into the Word document template so that field values sync between SharePoint and the file.
Ensure you have the appropriate permissions to edit Library settings in SharePoint and that you are using the desktop version of Microsoft Word, as the Quick Parts feature is limited in Word for the Web.
Use Quick Parts to Insert SharePoint Metadata
By enabling content-type management in SharePoint, you can expose library columns to Word and insert them directly into your templates using the Quick Parts feature.
Mapping SharePoint columns to a Word document requires linking the SharePoint library content type to your document template. Once linked, Word recognizes the library columns as document properties.
Navigate to your SharePoint library. Click the gear icon to open 'Library settings', go to 'More library settings', select 'Advanced settings', and set 'Allow management of content types?' to 'Yes'. Click OK.
Return to the Library settings page. Under the 'Content Types' section, click on the 'Document' content type. Select 'Advanced settings', and choose 'Edit Template' to open the document in the Microsoft Word desktop application.
In Word, place your cursor where you want the metadata to appear. Go to the 'Insert' tab on the ribbon, click 'Quick Parts' in the Text group, and hover over 'Document Property'.
From the 'Document Property' flyout menu, select the SharePoint columns (such as Department, Project, or Status) to insert them into your document template. Save the document and close Word.
Looking for a fast, lightweight alternative to Microsoft Word?
If you need a reliable, high-performance word processor for managing complex documents outside of SharePoint, WPS Office offers an excellent free alternative with seamless format compatibility and advanced editing features.
- 1. Download and install WPS Office: Visit the official WPS website to download the free suite and follow the simple installation prompts.
- 2. Open your existing Word documents: Launch WPS Writer, click 'Open', and select your existing .docx files to continue working seamlessly.
- 3. Edit and save with confidence: Edit your documents knowing that all standard text formatting, tables, and layouts will remain intact.
Frequently Asked Questions
Why aren't my SharePoint columns showing up in Word's Quick Parts menu?
This usually happens if the columns were added to the SharePoint library but not specifically assigned to the Document Content Type. Go to your Library settings, click on your Content Type, and ensure the necessary columns are included there.
Can I edit mapped metadata directly from the Word document?
Yes, when you update the mapped Document Property field within the Word document and save it back to SharePoint, the corresponding metadata column in the SharePoint library is automatically updated.
Does the Document Property mapping feature work in Word Online?
No, the ability to insert Quick Parts and map document properties is currently only supported in the Microsoft Word desktop application. You must use the 'Open in Desktop App' option to set up or view the fields properly.
Will mapped fields in Word update automatically if someone changes the metadata in SharePoint?
Yes. If the document is opened in the desktop app, the Quick Part fields will refresh to reflect the current metadata values stored in the SharePoint library columns.
