Import Termset and Terms into Termstore Management in Sharepoint 2013

Arunraj Venugopal
 
SharePoint Developer
April 11, 2014
 
Rate this article
 
Views
15105

Let us discuss about how the termset and terms can be imported to Termstore Management under a group Name in Sharepoint 2013.

By importing Termset and Terms into Termstore Management using excel will reduce the time consumption for manual process and power shell script.

Procedure for importing termset and Terms into Termstore Management

Step1: Open Central Administration

clip_image002

Step2: Click Manage Service applications

clip_image004

Step3: Click ManagedMetadataServices

clip_image006

Step4: Create Group Name “Test” by clicking on the dropdown icon on the ManagedMetadataServices

clip_image008

clip_image010

Step5: Prepare Csv file with termset and Terms.

Note: In the excel file, Testing is a termset in which two different terms are existing; they are Home and Home2. The excel file contains term level from 1 to 7, but this example contains term level till 4th level.

In the column D, the value true for each terms since tagging is available for all ther terms. It could be false if you there is no tagging which doesn’t create any impact.

clip_image012

Step6: Save the file.clip_image014

Step7: Click dropdown icon on Test group name to import the termset and its terms.

clip_image016

clip_image018

Step8: The below screenshot shows the result of the termset imported from the csv file.

clip_image020

I hope it is useful for everyone.

Author Info

Arunraj Venugopal
 
SharePoint Developer
 
Rate this article
 
Works as a SharePoint Developer in a CMM Level 5 Company ...read more
 

Leave a comment