SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

What is the correct way to create a term store for taxonomy planning for a medium size company?

Is it import from excel file or creation through website?

Again this is for a medium size company?

share|improve this question

I would use excel (use Wictors Excel Sheet: or Powershell.

With that approach you can implement the taxonomy on Dev/Prod - with the same values.

With Powershell you can even have the same Term Ids.

share|improve this answer
Thanks Paul. I guess for planning of a large size organization term store will be common for the organization not for individual departments. If we use excel file in that case how to ensure that there is no duplication happens. How the organizations are really maintaining terms in single excel file? At what schedule organizations are updating terms in the application? – user17251 Jun 16 '13 at 3:34
Can you please elaborate on Powershell approach? – user17251 Jun 16 '13 at 3:35
Sure, see this blog post:… <br/> Read the comments, there is a fix in it and the blog author did not update it. – Max Melcher Jun 17 '13 at 7:28

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.