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):

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.

Advertisements

About Dattatrey Sindol (Datta)

Datta is a Microsoft BI Enthusiast, passionate developer, and a blogger. View Full Profile

Posted on May 7, 2012, in MS Office, TFS, TFS Tips, Tips 'N' Tricks and tagged , , , , , , , , , , , , , , . Bookmark the permalink. 1 Comment.

What are your thoughts?

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: