Export Data / Generate report from TFS

Export / Generate report from Microsoft TFS in excel format.

It is possible to export your TFS records in excel. To export the records to excel user need to have team option in menu. If team option is not available in excel you can add it.

How to add team menu in Excel

1. Open Microsoft excel
2. Click on File Menu
3. Click on sub- menu Options
4. Click on Customized ribbon
5. Check the box against team option under main tabs
6. Click on OK

How to fetch data / reports in excel from Microsoft TFS?

1. Click on team option
2. Click on New List from the sub-menu
3. Select the Team foundation server(TFS server) From dropdown
4. Select the project from team project collection
5. Select team project from the list
6. Click on connect
7. Select the query list
8. Select the query which need to export to the excel
9. Click on OK

In team menu an option available named “choose columns” by selecting it you can choose or remove the columns you wish to have in excel sheet

This excel sheet will give you detail in excel format of Bug list, Test cases, Active bugs, Reopened bugs etc.

You can able to export all Raw Data which you have created in Microsoft TFS Project.