One a recent project for Slalom Consulting, my employer, we had a project that made use of SharePoint 2010 Managed metadata including groups, term sets and terms. As we began to create new environments, one of the laborious tasks was to populate the Taxonomy Term Store using the term store manager page accessible via Central Administration or the related site collection (“_layouts/termstoremanager.aspx”). The terms are loaded into the Taxonomy Term Store via CSV file that adheres to a specific format that you can see via the url of your SharePoint Central Administration site: http://centraladminurl/_layouts/1033/ImportTermSet.csv
To manually import a file, you must first create group, then click on that group and chose “Import Term Set”:
You are then presented with a dialog box where you can select a CSV file that adheres to the required format to import:
This process is fine if you only have one or two terms to load but as your continue to build out a solution and have to do this process over and over again, it can be come tedious. The following is my PowerShell script that loops through all the .csv files in the same directory as the PowerShell script. The caution is the script deletes the terms each time, so any site columns you create from this will need to adjusted if you delete and recreate the term set. However, this is useful during setting up environments during the development process as you create site collections. Use with caution . I am also very much open to feedback on the PowerShell script and how to improve it.