Exporting and importing test cases in Excel from TFS
While test cases in TFS can be accessed from Microsoft Test Manager as well as Team Web Access, you may still find stakeholders wanting to access the test cases from Excel. As a matter of preference, a few of your stakeholders may find it easier to document test cases in excel. While TFS does not offer an out-of-the-box feature to export and import test cases in Excel, it offers a good Software Development Kit (SDK) that can be used to create tools that enable such functionality. In this recipe, you'll learn how to use "test case export to excel" and "Test Case Migrator Plus (open source community tools)" to export test cases into Excel and import test cases from Excel into TFS.
Getting ready
Download and install the following utilities on your machine:
Test case export utility: https://tfstestcaseexporttoexcel.codeplex.com
Test case import utility: http://tcmimport.codeplex.com
Note
You'll need elevated permissions to install these utilities...