如何从Chrome导出TFS WIT？无Visual Studio用户需导出至Excel

Got it, let's figure out how to get those TFS work items exported to Excel for your teammates who don't have Visual Studio. Since you've got VS but haven't found a plugin, here are some straightforward, built-in ways to make this happen:

• Use Visual Studio's native export feature
  You don't need extra plugins—VS has this tool baked right in. Here's how to do it:

  1. Fire up Visual Studio and connect to your TFS project.
  2. Head to the Work Items hub, then either create a new query to target the specific items your colleagues need, or load an existing shared query that already covers the right set.
  3. Once the work items list loads, right-click anywhere in the results and select Export to Excel. This will generate an Excel file with all the selected work item fields included.

• Share the exported file (and let them refresh data later)
  After exporting, just send the Excel file over to your colleagues. If they need to pull the latest updates without asking you again, the file can connect back to TFS:

  • In the Excel file, look for the Team tab (this appears if the Team Foundation Server Office Integration is installed—VS usually installs this automatically, and most Office setups include it too).
  • They can click the Refresh button on that tab to get the newest work item data, even without Visual Studio. If they don't see the Team tab, they can install the free TFS Office integration components separately.

• Bonus: Your colleagues might be able to export directly from Chrome
  You might not even need to do this for them! The TFS web portal has its own export option. Have them try these steps:

  1. In Chrome, go to the TFS web portal and navigate to the work items query they want to export.
  2. Look for the Export to Excel button in the top toolbar (it usually looks like the Excel logo).
  3. Click it, and it'll download an Excel file linked to TFS. They can refresh the data whenever they need, all from their browser—no Visual Studio required at all.

Quick tip: If they don't see the export button, make sure the query is set to display a list of work items (not a chart or dashboard view), and double-check that they have permission to export work items from TFS.

内容的提问来源于stack exchange，提问作者user459962