Others

How to Import and Synchronize External Data with SharePoint Term Store

Camila MilosovichCamila Milosovich Nov 3, 2026 869 views

Question details

The user wants to import term sets and continuously synchronize changing external data with the SharePoint Online Term Store.

How to Import and Synchronize External Data with the SharePoint Term Store
Product
SharePoint Online
Device & OS
not provided
Scenario
Managing enterprise metadata by integrating external systems with the SharePoint Term Store.
Observed behavior
SharePoint supports manual term set imports but lacks a built-in feature for automated, continuous data synchronization.
Before you start

Ensure you have Term Store Administrator permissions in the SharePoint admin center and a correctly formatted CSV file for manual term imports.

Solution 1Recommended

Import Term Sets Manually via Term Store Management Tool

Use this built-in method to bulk import metadata from a CSV file into SharePoint Online.

1
Access the Term Store

Navigate to the SharePoint admin center, expand 'Content services' in the left navigation pane, and select 'Term store'.

2
Select a Term Group

Expand the taxonomy tree to find the specific term group where you want to create or update the term set.

3
Initiate Import

Click the three dots (...) next to the chosen term group and select 'Import term set' from the dropdown menu.

4
Upload the CSV File

Browse for your properly formatted CSV file containing the external data and upload it to complete the manual import.

Import Term Sets Manually via Term Store Management Tool
Sample File Template: You can download the sample CSV template directly from the Term Store Management Tool before uploading to ensure your external data follows the required formatting structure.
Free Microsoft Office alternative

Looking for a seamless and lightweight Office alternative?

While SharePoint handles your enterprise metadata and online document libraries, you need a reliable desktop application to create, view, and edit those files locally. WPS Office is a powerful, lightweight, and completely free alternative to Microsoft Office that perfectly supports Word, Excel, and PowerPoint files.

Fully compatible with Microsoft Word, Excel, and PowerPoint formats (.docx, .xlsx, .pptx).Lightweight application that uses minimal system resources.Familiar tabbed user interface for an easy transition without a learning curve.Includes advanced PDF viewing, editing, and conversion capabilities out of the box.
microsoft office alternative - wps office

Frequently Asked Questions

Can I automate the Term Store sync using out-of-the-box SharePoint features?

No, SharePoint Online does not currently offer a built-in method to continuously synchronize the Term Store with external data. Custom API development or third-party tools are required for automation.

Where can I request native synchronization features for SharePoint Online?

You can submit feedback, feature requests, and use cases regarding Term Store synchronization directly through the official Microsoft Tech Community.

Does this manual import process apply to SharePoint Server (on-premises)?

While the manual import process is similar across versions, specific architecture and synchronization questions regarding SharePoint Server should be directed to the Microsoft Q&A community rather than SharePoint Online forums.

What permissions are required to update the Term Store?

To import or synchronize data, you must be assigned the Term Store Administrator role globally, or be designated as a Group Manager for the specific term group you are modifying.