The question of exporting term sets from the term store was brought to our attention a few months ago. Users are finding that there is no out of the box solution available; we found a blog that solved this problem:
However, FiveP’s Matt Narayan has called out an easier way of doing it.
- Using Excel, blank workbook
- Data ribbon, connect to other sources
- Select XML source
- Enter the location of the file from “%LOCALAPPDATA%\Microsoft\Office\TermSets”
- Select the latest XML files and import into your worksheet
This will essentially load up the latest locally cached version of a terms that you’ve used recently. You can then copy this to standard CSV file for cleaning up and importing back into your next term store.