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.


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

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

Google+ photo

You are commenting using your Google+ 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 )

Connecting to %s

%d bloggers like this: