Team foundation server and excel

One of the greatest features of Tfs is that it is a single product that is able to manage the whole ALM of an application, but another strength point is high level of integration with other tools. One of the coolest feature is the ability to use Excel to manage workitems, without the need to even open visual studio.


It is enough for you to install the team exploer, and you will get office integration. Excel shows a new tab in the ribbon named Team that permits you to work with team foundation server. You can choose item specifying a standard workitem query, or you can directly create new workitem or load by id. As an example you can view all opened bugs.


Thanks to high level of integration, you can edit data with combo, in this screenshot you can verify that I can assign a bug to only valid user of tfs. If you want to change the state of a bug you can see that the state column is missing, all you need to do is to select what column to show.


This means that you can edit all information of every workitem, and when you are finished you can press the Publish button to send updated data to TFS. This is useful for massive operations on works items, since working in excel is simplier and quickier respect to manage work items in visual studio. This is especially useful for project manager, or similar project figures that are not programmers and does not want to install visual studio only to manage workitems.

Creating a new task is as simple as creating a new line on the worksheet, omitting the workitem id and then press publish, immediately you will see that the id field will be populated, thus confirming that new workitems are really added to tfs.


Tags: Team Foundation Server