Tips ‘N’ Tricks – TFS – Managing TFS Work Items through Microsoft Excel
Team Foundation Server (TFS) is an excellent tool for Version Control (Software Change Management). It is also a great tool to manage Backlogs, Bugs, and Tasks etc. (Work Items in General). Many of the times you might need to create/edit work items in bulk especially in the beginning/end of a sprint cycle when you are working in an Agile/Scrum model. To address this specific need in particular and easy management of Work Items in general, TFS allows connecting to the TFS through Microsoft Excel and perform a range of actions related to TFS Work Items.
By connecting to TFS Team Project through Microsoft Excel, one can perform the following most common actions (apart from various other actions):
Create, Open, and Edit One or More Work Items (Basically allows publishing Work Item Creation/Modification to TFS)
Query the TFS Work Items and include the columns of your interest in the excel sheet
- Work with the Work Items Offline while the excel is not connected to TFS
Refer to this Books Online Article for detailed step by step instructions for performing various actions related to TFS Work Items from within Microsoft Office Excel.
I have found working with TFS Work Items through Excel really very convenient and a real time saver. Let me know your experiences and your stories of managing TFS Work Items through Excel 🙂
Take a look at the other Tips and Tricks in this Series on Tips, Tricks, Techniques, and Shortcuts to Improve Productivity, and Design and Coding Skills.
Posted on May 7, 2012, in MS Office, TFS, TFS Tips, Tips 'N' Tricks and tagged Agile Methodology, Excel, Microsoft Excel, Microsoft Office, Microsoft Visual Studio, Scrum, Software configuration management, Spreadsheet, Sprint, Team Foundation Server, TFS, TFS Work Items, Tips, Tips and Tricks, Version Control. Bookmark the permalink. 1 Comment.