After upgrading to Team Foundation Server 2012, I got the following question from one of our PM’s:
“In TFS 2010 Web Access I could export my work items to excel. How could I do the same thing in TFS 2012 Web Access?”
Unfortunately there is no direct way of doing this. I know only two possible alternatives/workarounds:
- Install Team Explorer 2012. This will give use an extra Team tab in Excel and makes it possible to import the work items directly.
- Use the good old copy/paste trick:
- Select the work items you want to export from a query result
- Press Ctrl+C or open up the popup menu by clicking the down arrow icon on the left of one of the selected work items and click copy (at the bottom)
- Press Ctrl+C
- Paste to Excel
Anyone with a better alternative?