Using Excel with Bugs
Excel provides a neat way of getting a large number of Bugs loaded into Team System or
performing multiple similar edits very efficiently. It is also a great way to work with the
backlog for team members who don't have or don't want to use Visual Studio.
To connect an Excel spreadsheet to a Team System project see Artefacts in Team System
Using Excel to Work With Bugs
Having successfully connected an Excel worksheet to your Team Foundation Server you can
create new Bugs and "Publish" them back to the connected Scrum project.
Select the fields that you are interested in by using the "Column Chooser" to select and order
them. Ensure that your spreadsheet includes the "Work Item Type" column as you will need to
specify that each item is set to a "Bug" type.
The example below shows a Bug item being added through a spreadsheet created
with the "Input List" (indicated by "Query: None"). In order to write this new backlog item
back to the Scrum project use the "Publish" button on the Team Foundation toolbar.