Export test cases to Excel from TFS 2012 (or MTM)
Help. I'm stuck. When I was using TFS 2010 I was able to export my test cases to excel using a 3rd party tool. However, that tool isn't compatible with 2012. Does anyone know of a tool that is compatible with TFS 2012 or MTM that allows me to export test cases to Excel?
The method is kind of sideways. You need to create a query that contains all the test cases you want to export with all the data you want in them.
After that, you use Excel to connect to that specific query, and you have your export that way - it's the same method you use to export any other work item type.
This is great for generating a list.
However, it doesn't list out the steps.
Note: this is the same thing as going into Visual Studio and clicking "Open in Microsoft Office" and selecting Excel.
You can get the steps this way: if you're using shared steps, a parent-child query will bring those in. Then you need to add the steps to columns returned by the query. They'll come out in XML, which you can strip in Excel.
It's cludgy, but it does work.
I'd need to dig to see if it's possible to build a custom report that pulls the data in excel or CSV format - which means you're not going to get that answer from me any time soon
Have you try "Test case extractor" tool ? If not then please try it out.
lease use this tool to export test cases from TFS (or MTM) into excel. It works fine with TFS 2012:
The tool provides some really good options to the user while exporting multiple test suites.
The user can also specify if they want the test case results to be exported.
You can download the tool from: