Import term sets

You can import term sets into the Term Store management tool instead of building out term sets and terms manually. This can save time, especially if there are many terms.

There are three steps involved in importing a term set:

  1. Download a copy of the import file
  2. Fill out the import file by using your term set values
  3. Import a term set
What do you want to do?


Open the Term Store Management Tool

To open the Term Store management tool, select the SharePoint environment that you use, and then follow these steps.

In SharePoint Online

  1. Go to the SharePoint Online admin center.
  2. Click Term Store to open the Term Store management tool.

In SharePoint Server

  1. From the site collection Home page, click Site Contents.
  2. On the Site Contents page, click Settings.
  3. On the Site Settings page, in the Site Administration group, click Term store management.

After you open the Term Store management tool, you can download a copy of the import file or import a term set.

Download a copy of the import file

In the Term Store management tool, you can download a copy of a .CSV (comma-separated values) file that you can use to compile the terms in your term set.

  1. Open the Term Store Management Tool.
  2. Select the taxonomy in the tree view pane on the left.
  3. On the General tab of the properties pane, in the Sample Import section, click View a sample import file.
  4. In the File Download dialog box, click Save, and select the location where you want to save the file.

Top of Page Top of Page

Fill out the import file by using your term set values

Each import file can contain a single term set. You can arrange the terms in a hierarchy that is up to seven levels deep. If you want to import multiple term sets, you have to create a file for each term set. Before you fill out the import file, you'll want to give some thought about how you want to group your organization’s metadata into term sets and terms. For more information about how to plan the content of your term sets, see Plan terms and term sets in SharePoint Server 2013.

Follow these steps to fill out the import file:

  1. Open the sample import file that you have downloaded.
  2. Study the file to become familiar with the hierarchy of a term set.
  3. To add terms, delete all rows in the CSV except the first, and then enter the information for the terms that you want to use.

For more information about how to plan to import term sets, see Plan to import managed metadata. For more detailed information about the input file format for term sets and how to fill out the file, see Managed metadata input file format.

Import a term set

You must be assigned to a Term Store Administrator or a Group Manager role to import term sets. For more information about managed metadata roles, see Assign roles and permissions to manage term sets.

  1. Open the Term Store Management Tool.
  2. In the tree view pane on the left, expand the groups to find the group where you want to import the term set.
  3. Point to the group, click the arrow that appears, and then click Import Term Set.
  4. In the Term set import dialog box, click Browse, locate the import file that you have updated with the term set values, and then click Open.
  5. In the Term set import dialog box, click OK.
 
 
Applies to:
SharePoint admin center, SharePoint Online Enterprise (E1), SharePoint Online Enterprise (E3 & E4), SharePoint Online Midsized Business, SharePoint Online operated by 21Vianet - Enterprise (E1 & E2), SharePoint Online operated by 21Vianet - Enterprise (E3 & E4), SharePoint Online operated by 21Vianet - Midsized Business, SharePoint operated by 21Vianet - admin center, SharePoint Server 2013 Enterprise, SharePoint Server 2013 Standard